Post reply

Stored procedure with EXECUTE AS

  • June 15, 2010 at 9:58 pm

    #387165

    I have a procedure that calls the EXECUTE AS and I want to create this SP in different databases. What is a intelligent approach to create the SP? Basically I need to create it in several databases however I can't create it in only one database and then call it using the 3 naming convention. Because it won't work when the stored procedure is using the EXECUTE AS.

    I only can think about this:

    Use XXX

    GO

    Create proc sproc

    GO

    Use YYY

    GO

    Create proc sproc

    GO

    Use ZZZ

    GO

    Create proc sproc

    GO

  • June 16, 2010 at 9:09 am

    #1181086

    I’m not very clear on the question but I believe u need to create the impersonated user in the new databases

    Just a quick question, You mentioned that you intend to create this same procedure in different Databases. Are the new databases subscribers to some replication topology?

  • June 16, 2010 at 9:25 pm

    #1181343

    no replication involved.

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

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