Thursday 6 March 2014

sys.dm_server_services

sys.dm_server_services DMV is available in SQL Server 2008 R2 SP1 and SQL Server 2012. It will return the information about the below SQL Services on the current instance.

    SQL Server (2008 R2 SP1 and SQL Server 2012)
    SQL Server Agent services(2008 R2 SP1 and SQL Server 2012)
    Full-Text(SQL Server 2012)

No comments:

Post a Comment