(Msg. 1) Posted: Sat Jan 31, 2009 9:28 am
Post subject: Detecting Single User Mode Archived from groups: microsoft>public>sqlserver>programming (more info?)
Is there a programatic way of detecting whether an instance of SQL has been
started in Single User Mode (-m)? Thanks.
(Msg. 2) Posted: Sat Jan 31, 2009 11:26 am
Post subject: Re: Detecting Single User Mode [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
> Is there a programatic way of detecting whether an instance of SQL has
> been
> started in Single User Mode (-m)? Thanks.
Detecting value changes and grouping by them - Hello, I was wondering if anyone can help me with a problem I have. I have a program (beyond my control) that constantly posts to a table the current value of a set of parameters identified by name. I need to query it and return for a given parameter...
Detecting an existence of local temporary table - Hi, I create a temporary table. for example: <font color=purple> ; create table #t1 (ID_T1 integer)</font> Next I would like to detect If the table already exists: exec sp_table #t1 if @@ROWCOUNT > 0 <font color=purple>&...
Database in recovery mode - For some reason on a restart today we had our main database go into "in recovery mode" what would cause this to happen? it seems like it recovered from the logs point of view... but there were tons of entries sayign stuff like 9000 transacti...
sqlcmd in silent mode - Is it possible to run sqlcmd in silent, or quiet mode where the console window does not appear? I am setting up an automatic backup system using calls to sqlcmd -Q with the Windows Task Scheduler. The transaction log backups, especially, will likely....
sqlcmd mode and r command - I have this small piece of SQL running in sqlcmd mode. DECLARE @v VARCHAR (MAX) SET @v = 'c:\asdf.sql' :setvar filename @v PRINT $(filename) :r $(filename) I get this error: A fatal scripting error occurred. The file specified for :r command was not..
All times are: Pacific Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You can edit your posts in this forum You can delete your posts in this forum You can vote in polls in this forum
FAQ
Search
Profile
Private Messages
Log in
