Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Setting SingleUser
Message
De
20/03/2002 12:50:08
 
 
À
20/03/2002 12:34:43
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Divers
Thread ID:
00633529
Message ID:
00635088
Vues:
20
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform