Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Shrink logs
Message
 
 
To
10/07/2009 15:45:22
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01411487
Message ID:
01411497
Views:
28
>Do you mean create one @ExeString with all of the commands for each pass through the cursor, and execute it?
>
>I could try that, but I think your suggestion of the sp_MSforeachdb might work better. I am looking into it now.
>
>Thank you!
>

Yes, I was thinking if we need to exclude certain databases, then we would create a script, then use EXECUTE with it.

Otherwise see my last reply on sp_MSForEachDB.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform