Tech Off Thread

5 posts

Forum Read Only

This forum has been made read only by the site admins. No new threads or comments can be added.

SQL Server Management Studio

Back to Forum: Tech Off
  • User profile image
    Red5

    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.

  • User profile image
    stevef100

    view -> template explorer ??

  • User profile image
    fkerrigan

    I noticed this supresses parsing of the SQL code and can be quite anoying.

  • User profile image
    Red5

    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?

  • User profile image
    markheimonen

    I think you want "Tools-->Options-->Scripting-->Object Scripting Options-->Schema Qualify Object Names"

Conversation locked

This conversation has been locked by the site admins. No new comments can be made.