Post reply

How get environment variables without use xp_cmdshell ?

  • November 6, 2009 at 9:21 am

    #139268

    Hi,

    I need to write a trigger to write to a specific environment variable in a table. How can I do without using xp_cmdshell ?

    Thank

  • November 6, 2009 at 9:25 am

    #1075968

    Hi

    You can write a SQLCLR. Why without xp_cmdshell?

    Greets

    Flo

  • November 6, 2009 at 10:28 am

    #1076020

    Thank you for your response.

    I do not use xp_cmdshell to not affect the security of SQL.

    I will try SQLCLR.

  • November 6, 2009 at 10:55 am

    #1076034

    Hi

    Just a little hint:

    Keeping xp_cmdshell disabled in server configuration is a little security fake. Only users of "sysadmin" group are allowed to execute xp_cmdshell and each "sysadmin" is able to enable to enable xp_cmdshell whenever (s)he intends. 😉

    Greets

    Flo

Viewing 4 posts - 1 through 3 (of 3 total)

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