Author Archives: admin

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 more

SQL Management Studio – Windows Authentication – different domain

Sometimes you need to use windows authentication to SQL using SQL Management Studio, but the your domain and or username is different than who you are currently logged into you machine as.  In that case run the following command from a Command Prompt. runas /netonly /user:domainusername “C:Program Files (x86)Microsoft SQL Server100ToolsBinnVSShellCommon7IDESsms.exe”

Read more