Category: SQL Server
SQL Server Error Code – 13157 terminate conversation
In this blog post, you’ll learn more about the SQL Server Error Code 13157 and the error message description that is shown SQL Server Error Code 13157 SQL Server Error Description for the Code :13157 terminate conversation
SQL Server Error Code – 14367 one or more schedules were not deleted b
In this blog post, you’ll learn more about the SQL Server Error Code 14367 and the error message description that is shown SQL Server Error Code 14367 SQL Server Error Description for the Code :14367 One or more schedules were not deleted because they are being used by at least one other job. Use “sp_detach_schedule” to remove schedules from a job.
SQL Server Error Code – 15009 the object ‘%s’ does not exist in databa
In this blog post, you’ll learn more about the SQL Server Error Code 15009 and the error message description that is shown SQL Server Error Code 15009 SQL Server Error Description for the Code :15009 The object ‘%s’ does not exist in database ‘%s’ or is invalid for this operation.
SQL Server Error Code – 43023 the storage size of %d mb is lower than
In this blog post, you’ll learn more about the SQL Server Error Code 43023 and the error message description that is shown SQL Server Error Code 43023 SQL Server Error Description for the Code :43023 The storage size of %d MB is lower than the source storage size.
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 – 7736 partition function can only be created i
In this blog post, you’ll learn more about the SQL Server Error Code 7736 and the error message description that is shown SQL Server Error Code 7736 SQL Server Error Description for the Code :7736 Partition function can only be created in Enterprise edition of SQL Server. Only Enterprise edition of SQL Server supports partitioning.
SQL Server Error Code – 29307 cannot set the roster property %s.
In this blog post, you’ll learn more about the SQL Server Error Code 29307 and the error message description that is shown SQL Server Error Code 29307 SQL Server Error Description for the Code :29307 Cannot set the roster property %s.
SQL Server Error Code – 4952 alter table switch statement failed beca
In this blog post, you’ll learn more about the SQL Server Error Code 4952 and the error message description that is shown SQL Server Error Code 4952 SQL Server Error Description for the Code :4952 ALTER TABLE SWITCH statement failed because column ‘%.*ls’ does not have the same ANSI trimming semantics in tables ‘%.*ls’ and ‘%.*ls’.
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 – 8986 too many errors found (%d) for object id
In this blog post, you’ll learn more about the SQL Server Error Code 8986 and the error message description that is shown SQL Server Error Code 8986 SQL Server Error Description for the Code :8986 Too many errors found (%d) for object ID %d. To see all error messages rerun the statement using “WITH ALL_ERRORMSGS”.
SQL Server Error Code – 14223 cannot modify or delete operator ‘%s’ wh
In this blog post, you’ll learn more about the SQL Server Error Code 14223 and the error message description that is shown SQL Server Error Code 14223 SQL Server Error Description for the Code :14223 Cannot modify or delete operator ‘%s’ while this server is a %s.
SQL Server Error Code – 2527 unable to process index %.*ls of table %
In this blog post, you’ll learn more about the SQL Server Error Code 2527 and the error message description that is shown SQL Server Error Code 2527 SQL Server Error Description for the Code :2527 Unable to process index %.*ls of table %.*ls because filegroup %.*ls is offline.