Category: SQL Server

SQL Server Error Code – 18799 only users who are members of the follow

In this blog post, you’ll learn more about the SQL Server Error Code 18799 and the error message description that is shown SQL Server Error Code 18799 SQL Server Error Description for the Code :18799 Only users who are members of the following roles can perform this operation: sysadmin fixed server role; dbowner or dbcreator fixed database role in the current database.

SQL Server Error Code – 40976 instance failover group cannot be create

In this blog post, you’ll learn more about the SQL Server Error Code 40976 and the error message description that is shown SQL Server Error Code 40976 SQL Server Error Description for the Code :40976 Instance Failover Group cannot be created because partner managed server “%.*ls” is not empty or does not have secondaries for all databases in the primary instance  “%.*ls” .

Sorting the Data in a Query in SQL Server

You want the results of the query to be displayed in a sorted order based on some query. In this case , you use the ORDER BY clause in the query by specifying the column on which the sort to work. For example , you want to sort the Departments table in the database by the column DepartmentName. Here’s how the query looks like This…