Post reply

Auto Login A User

  • August 28, 2007 at 3:36 am

    #69944

    Gents,

    SQL Server 2000. 

    Is there a TSQL command, system sp etc that allows you to login a user via a SQL script?

    Thanks in advance

    Stuart

  • August 28, 2007 at 4:57 am

    #729725

    You can impersonate another user with

    SETUSER 'foo'

    (on 2005 you should use EXECUTE AS)

    Is this what you are looking for?

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • August 28, 2007 at 6:46 am

    #729742

    Andras,

    Thanks for your input. That worked a treat.

    Stuart

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

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