Home Forums SQL Server 2005 Development Separate Login for a query in a stored procedure RE: Separate Login for a query in a stored procedure

  • If you set up roles on the server (Security tab), you can tell a job to run under a particular login/role.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon