When a the User at the database level has no login, but there is one in the database. exec sp_change_users_login “auto_fix”, “cw_reports”;
Read moreMonthly Archives: July 2015
SSRS Scripts
Find reports that are not mapped to a data source: SELECT ItemPath = c.[Path], ItemName = c.Name, DatasourceRefrenceName=ds.Name FROM [Catalog] AS c INNER JOIN DataSource AS ds ON ds.ItemID = c.ItemID WHERE ds.Link IS NULL AND ds.Extension IS NULL order by ItemPath
Read moreSQL Server Backup and Maintenance Scripts
https://ola.hallengren.com/sql-server-backup.html
Read more