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 [...]

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 syspermissions returns rows that describe permissions granted and denied to users, groups, and roles.  [...]