Post reply

SET Commands

  • July 9, 2009 at 2:47 pm

    #384964

    Hi Guys,

    We normally set our enviroment while working in Query Analyzer inside the Management Studio. Right?

    For we set our environemt saying,

    SET NO COUNT ON

    SET ANSI_NULLS ON

    SET IMPLICIT_TRANSACTIONS ON and so on....

    Like Oracle, we use a command SET <> which displays the current settings in the sqlplus or sqlplusw windows. Do we have any similar kind of command through which we can display all the settings made to my current Query Window????????

  • July 9, 2009 at 2:56 pm

    #1022700

    Have a look to sys.dm_exec_sessions:

    SELECT * FROM sys.dm_exec_sessions WHERE session_id = @@SPID

  • July 9, 2009 at 3:21 pm

    #1022715

    Hey,

    That was very GOOD.

    But how could i get the infomartion whether my IMPLICIT_TRANSACTIONS is ON / OFF??????

  • July 9, 2009 at 4:31 pm

    #1022767

    have you looked at the gui options?

    tools - options - query execution - SQL Server - Advanced

    and

    tools - options - query execution - SQL Server - ANSII

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • July 9, 2009 at 7:44 pm

    #1022825

    Execute command dbcc useroptions under that database.

    MJ

  • July 9, 2009 at 10:02 pm

    #1022842

    Thank You.:-)

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

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