Browse by Tags

All Tags » view » tsql   (RSS)
TSQL to list all the reports inlcuding data sources on the SQL Server Reporting Server?
27 December 07 05:35 AM | SQL Master | 2 Comments   
Use ReportServer Go SELECT DS . Name as DataSourceName , CT . Name AS ItemName , CT . Path FROM dbo . Catalog CT INNER JOIN dbo . DataSource DS ON CT . ItemID = DS . ItemID Where Type = 2 Order by DataSourceName , ItemName Read More...
Display the server-level information the application role can currently view.
09 August 07 03:28 AM | SQL Master | 2 Comments   
SELECT sid, status, name, dbname, hasaccess, loginname FROM master.dbo.syslogins; GO SELECT spid, kpid, lastwaittype, waitresource, dbid FROM master.dbo.sysprocesses; GO Read More...
Find VIEW ANY Database permission privileges for all users
18 July 07 08:11 AM | satyaskj | 1 Comments   
You may be aware that any login that is created on SQL Server will have permission or privilege to see all databases on that instance. This is due to VIEW ANY DATABASE permission that regulates the exposure of metadata system databases. This permission Read More...