SSMS Autocomplete

  • I love that 2008 includes autocomplete in SSMS. However, I would really like to turn off case sensitivity on it. Is there any way to do that?

    Thanks,

    Scott

  • Check if the "Casing for built-in function names" option (under Tools --> Text Editor --> Transact-SQL --> IntelliSense) is what you need

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • Pradeep-

    Thanks for the reply, but that did not contain an option for case sensitivity.

    Regards,

    Scott

  • I was referring to "Casing for built-in function names" under that option.

    But it seems to control the casing for BUILT-IN Function only

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • ALTER DATABASE Adventureworks SET SINGLE_USER WITH rollback immediate;

    go

    ALTER DATABASE Adventureworks COLLATE SQL_Latin1_General_CP1_CI_AS;

    GO

    ALTER DATABASE Adventureworks SET MULTI_USER;

    GO

    I guess this is what you want .

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply