Query Editor places unwanted code in stored procedure header

  • 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...

  • 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.

  • 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