Frank Carrelli
SSC-Addicted
Points: 460
More actions
November 17, 2008 at 7:02 am
#193867
Does anyone know how to suppress the automated "Use [DB]" code from being inserted into the header when opening a stored procedure in 2008 Management Studio?
Thanks in advance...
steveb.
SSC-Forever
Points: 46733
November 17, 2008 at 7:12 am
#899316
for 2005 it is;
Click on TOOLS --> OPTIONS --> SCRIPTING
and set Script USE <database > to FALSE
I can imagine that it is the same for 2008 but i am unable to check at the moment.
November 17, 2008 at 7:20 am
#899321
Thanks steveb,
That was it. I went through all of that a 100 times and did not see it. Thanks again...Frank
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply