Justin Cooney
Web Development Tips and Examples
Category: System Objects
-
A fairly common task is to add or remove user or group permissions to a SQL Server Stored Procedure, and also to maintain a list of database objects and the permissions associated with them. The syntax for these actions has remained fairly similar throughout the various versions of SQL Server, although SQL Server 200 and…
-
A great way to review all of the Clustered and NonClustered Indexes set up for a particular database is to query the SQL Server system tables. The sys.tables table contains the full list of tables for your database, and the sys.indexes table contains the full list of indexes. Simply join the two on their object_id…
-
What is the best way to see the full properties of all of the Linked Servers in SQL Server in one go? A SQL query is naturally the best way using SQL Server’s system tables! UI-Based Solutions: The properties view in the SSMS UI does not show sufficient information about the set-up and history of…
Justin Cooney 