Post reply

Change Subscription Owner with Direct SQL Update

  • March 11, 2010 at 7:22 am

    #217781

    I was asked to run the following script to change subscription owners from the login of someone who left the company to a different login.

    I would prefer not to do direct updates to the ReportServer database, but I do not know how to do this through the Report Manager. Is there any method to do this with Report Manager?

    declare @olduserid uniqueidentifier

    declare @newuserid uniqueidentifier

    select @olduserid = userid from dbo.users where username = 'ourdomain\oldlogin'

    select @newuserid = userid from dbo.users where username = 'ourdomain\ newlogin'

    update dbo.subscriptions set ownerid = @newuserid where ownerid = @olduserid

  • March 12, 2010 at 11:18 am

    #1132887

    I'm not sure about doing this as a direct update vs. report manager but if you're looking for other avenues, I'd think you might want to try the webservice and see if you can automate your updates that way.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

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

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