While using SQL Server Mgmt. Studio, I often right-click on a stored prodecure and select MODIFY.
When I do this, Mgmt. Studio likes to stick brackets [] around my proc name like:
[dbo].[prcMyProcedureToInsert]
Does anyone know of a way to surpress the brackets?
I cannot find an option anywhere.
Even the right-click
Script stored procedure as -->ALTER to-->New Query Window
does this too.
-
Follow
Oops, something didn't work.
Sign In to be begin to follow this thread
What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in. You need to be signed in to Channel 9 to use this feature.Getting "follow" information
Start following this thread
What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in and view them all on your notifications page.Removing your "follow"
Setting up your "follow"
Did you know you can
sign up for email notifications?
-
Red5
Systems Manager Curmudgen
-
stevef100
DaddyO
view -> template explorer ??
-
I noticed this supresses parsing of the SQL code and can be quite anoying.
-
Red5
Systems Manager Curmudgen
stevef100 wrote:view -> template explorer ??
This seems to be the location to edit your own custom?? templates and does not seem to include the option to remove qualifier brackets [ ] from the default Mgmt. Studio behavior.
fkerrigan wrote:I noticed this supresses parsing of the SQL code and can be quite anoying.
Could you explain this in more detail?
-
I think you want "Tools-->Options-->Scripting-->Object Scripting Options-->Schema Qualify Object Names"
Thread Closed
This thread is kinda stale and has been closed but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.