Category: SQL Server

How to Check if a login exists in SQL Server ?

If you need to check if a login exists in SQL Server , you can use query the master.dbo.syslogins for it. How to Check if a login exists in SQL Server ? Here’s a sample query demonstrating how you can query master.dbo.syslogins to find out if the login exists in SQL Server. This would retreive all the details of the loginid ‘sa’.

SQL Server Error Code – 7862 an endpoint of the requested type alread

In this blog post, you’ll learn more about the SQL Server Error Code 7862 and the error message description that is shown SQL Server Error Code 7862 SQL Server Error Description for the Code :7862 An endpoint of the requested type already exists.  Only one endpoint of this type is supported.  Use ALTER ENDPOINT or DROP the existing endpoint and execute the CREATE ENDPOINT statement.

SQL Server Error Code – 10618 cannot %s_msg filtered index ‘%.*ls’ on

In this blog post, you’ll learn more about the SQL Server Error Code 10618 and the error message description that is shown SQL Server Error Code 10618 SQL Server Error Description for the Code :10618 Cannot %S_MSG filtered index ‘%.*ls’ on table ‘%.*ls’ because the statement sets the IGNORE_DUP_KEY option to ON. Rewrite the statement so that it does not use the IGNORE_DUP_KEY option.

SQL Server Error Code – 8560 attempting to recover in-doubt distribut

In this blog post, you’ll learn more about the SQL Server Error Code 8560 and the error message description that is shown SQL Server Error Code 8560 SQL Server Error Description for the Code :8560 Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.

SQL Server Error Code – 8975 dbcc cross-rowset check failed for objec

In this blog post, you’ll learn more about the SQL Server Error Code 8975 and the error message description that is shown SQL Server Error Code 8975 SQL Server Error Description for the Code :8975 DBCC cross-rowset check failed for object ‘%.*ls’ (object ID %d) due to internal query error %d, severity %d, state %d.  Refer to Books Online for more information on this error.