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 [...]
In a previous post, there was a comparison between sysperfinfo and sys.dm_os_performance_counters which included the use of a simple query. The query just returned the contents of the dynamic management view, but didn’t provide the data from the view in a manner that immediately useful for all performance counters. The reason the data isn’t entirely [...]
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)
