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