Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Setting SingleUser
Message
From
20/03/2002 12:50:08
 
 
To
20/03/2002 12:34:43
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
00633529
Message ID:
00635088
Views:
19
>sorry for the delay in responding. Had a baby last week so it's been a little crazy.

Congrats! I hope everyone is doing well.

I'm really surprised that you're not seeing anything.

This is just a guess - try adding SET NOCOUNT ON to the batch:

SQLExec(chnd, "DELCARE @rc BIT; SET NOCOUNT ON;EXECUTE @rc = sp_dboption @database, 'single user', 'TRUE'; SELECT @rc")

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform