September 6, 2013 at 7:40 am
Hello Everyone
Happy Friday!!
I have something rather odd happening in SSMS as of yesterday. I had to start another instance of SSMS to run as a different user. Since then, my SSMS is showing the Create Object statements in the Sprocs and Views when I select to open the sproc or view in a new query window.
What happened to just showing the code of the query? Seems I ran into this a while back, but cannot remember what I did to correct it.
Thanks in advance
Andrew SQLDBA
September 6, 2013 at 1:41 pm
Does anyone have a clue how to turn this off in SSMS? I want to see only the content of the stored procedure, not all the dependent objects that the sproc uses. This is very annoying when one wishes to modify the sproc.
Thanks
Andrew SQLDBA
September 6, 2013 at 4:07 pm
I don't fully understand your description, but it seems that you check Tools->Options->SQL Server Object Explorer->Scripting and that the option "Generate script for dependent objects" is set to False.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
September 6, 2013 at 4:51 pm
Thank You Earland, that was it!! Mine had gotten set to "True".
Greatly appreciate that.
Have a nice weekend
Andrew SQLDBA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply