Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSMS Showing Create Object in Sprocs and Views Expand / Collapse
Author
Message
Posted Friday, September 6, 2013 7:40 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, July 17, 2014 3:19 PM
Points: 975, Visits: 3,342
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
Post #1492238
Posted Friday, September 6, 2013 1:41 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, July 17, 2014 3:19 PM
Points: 975, Visits: 3,342
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
Post #1492401
Posted Friday, September 6, 2013 4:07 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 2:28 PM
Points: 786, Visits: 691
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.

Erland Sommarskog, SQL Server MVP, www.sommarskog.se
Post #1492451
Posted Friday, September 6, 2013 4:51 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, July 17, 2014 3:19 PM
Points: 975, Visits: 3,342
Thank You Earland, that was it!! Mine had gotten set to "True".

Greatly appreciate that.

Have a nice weekend

Andrew SQLDBA
Post #1492459
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse