Each release of SQL Server is chalk full of new features and an assorted amount of bells and whistles. Some of these, like Availability Groups and ColumnStore, are great additions and their introduction includes much fanfare. Among all of those new features, is the occasional little bell which offers us a chance to change how we investigate SQL [...]
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective dynamic management objects. You can find a list of all of the deprecated views in the introduction post. The compatibility view syslockinfo returns information on lock requests. Whether the lock is granted, waiting to be [...]
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective dynamic management objects. You can find a list of all of the deprecated views in the introduction post. The compatibility view sysprocesses returns information on the processes that are running on a SQL Server instance. [...]
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective dynamic management objects. You can find a list of all of the deprecated views in the introduction post. The compatibility view sysprotects returns rows for permissions within a database. The view provides information on GRANT [...]
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective dynamic management objects. You can find a list of all of the deprecated views in the introduction post. The compatibility view sysservers provides information on linked servers, or servers an instance of SQL Server has [...]
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective dynamic management objects. You can find a list of all of the deprecated views in the introduction post. The compatibility view sysremotelogins returns a row for every remote user with access to call remote stored [...]
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective dynamic management objects. You can find a list of all of the deprecated views in the introduction post. The compatibility view sysreferences returns a row for every foreign key constraint in a database. The constraint [...]
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective dynamic management objects. You can find a list of all of the deprecated views in the introduction post. The compatibility view sysperfinfo returns rows for all of the internal SQL Server performance counters. Theses are [...]
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective dynamic management objects. You can find a list of all of the deprecated views in the introduction post. The compatibility view sysobjects returns one row for every object in a database. For each object, the [...]
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective dynamic management objects. You can find a list of all of the deprecated views in the introduction post. The compatibility view sysusers returns a row for every Windows user or group, SQL Server user, or [...]
_1262.png)
