Category: SQL Server

SQL Server related articles and SQL Server related code examples and TSQL Codes

For XML Path in SQL Server

Hello everyone, In this article, I will talk about the use of For XML Path in SQL Server. In SQL Server, the For XML Path statement is an expression used to output XML. It is a structure similar to the use of For XML Explicit. It is easier to use....

For XML Explicit in SQL Server

Hello everyone, In this article, I will talk about the use of For XML Explicit in SQL Server. In SQL Server, For XML Explicit statement is used to output XML. The For XML Explicit statement is used with Tag and Parent statements. You might be a little confused when used...

Listing Agent Error Logs in SQL Server

Hello everyone, In this article, I will try to give information about listing Agent error logs in SQL Server. In SQL Server, in some cases, you may want to list Agent error Logs. The following TSQL codes will search all available SQL Server Error Logs or SQL Server Agent Error...

Listing System Administrators in SQL Server

Hello everyone, In this article, I will try to give information about listing System Administrators in SQL Server. In SQL Server you may want to list System Administrators in some cases. You can easily do this using the code below. SELECT name, type_desc, is_disabled FROM master.sys.server_principals WHERE IS_SRVROLEMEMBER(‘sysadmin’, name) =...

Don`t copy text!