SQL Server Performance

Changing ownership of Reports in SRS

Discussion in 'SQL Server 2005 Reporting Services' started by carloarango, Apr 26, 2010.

  1. carloarango New Member

    One of our developers left the company and we had to reactivate his Windows Account so the Reports he created in SQL Reporting Services wouldn't fail; is there a way to programmatically change ownership of Reports; it would be very cumbersome to have to republish every one of them manually.
    Thanks.
  2. benwilson New Member

    No 100% sure, but i think one of the fields in the Catalog table of the Report Server database holds the owner info. You could possibly write some SQL to update this? Hope that helps!

Share This Page