Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set Query Results to 'File' to Text in script
Message
 
 
To
25/03/2010 17:15:15
General information
Forum:
Microsoft SQL Server
Category:
Scripting
Miscellaneous
Thread ID:
01457214
Message ID:
01457288
Views:
33
>What I was hoping for was an easy way to set output to file in the script. This is a one time thing where I need to remove about 600 SPs from a DB (long story). My source script creates such a script that I can edit to preserve the 6 SPs in that DB that are still used. My generated script also checks for existance before the DROP...

You can output the result to a file from SMSS. In the Query menu select Results to File.
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