Tag Archive for Catalog View

Lost In Translation

Lost in Translation – Deprecated System Tables – syslockinfo

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…

Lost In Translation

Lost in Translation – Deprecated System Tables – sysprocesses

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. …

Lost In Translation

Lost in Translation – Deprecated System Tables – sysprotects

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…

Lost In Translation

Lost in Translation – Deprecated System Tables – sysservers

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…

Lost In Translation

Lost in Translation – Deprecated System Tables – sysremotelogins

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…

Lost In Translation

Lost in Translation – Deprecated System Tables – sysreferences

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…

Lost In Translation

Lost in Translation – Deprecated System Tables – sysperfinfo

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…

Lost In Translation

Lost in Translation – Deprecated System Tables – sysobjects

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…

Lost In Translation

Lost in Translation – Deprecated System Tables – sysusers

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…

Lost In Translation

Lost in Translation – Deprecated System Tables – syspermissions

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. …