Category: SQL Server

SQL Server Error Code – 4629 permissions on server scoped catalog vie

In this blog post, you’ll learn more about the SQL Server Error Code 4629 and the error message description that is shown SQL Server Error Code 4629 SQL Server Error Description for the Code :4629 Permissions on server scoped catalog views or system stored procedures or extended stored procedures can be granted only when the current database is master.

SQL Server Error Code – 15382 failed to generate a user instance of sq

In this blog post, you’ll learn more about the SQL Server Error Code 15382 and the error message description that is shown SQL Server Error Code 15382 SQL Server Error Description for the Code :15382 Failed to generate a user instance of SQL Server due to failure in retrieving the user’s local application data path. Please make sure the user has a local user profile…

SQL Server Error Code – 4189 cannot convert to text/ntext or collate

In this blog post, you’ll learn more about the SQL Server Error Code 4189 and the error message description that is shown SQL Server Error Code 4189 SQL Server Error Description for the Code :4189 Cannot convert to text/ntext or collate to ‘%.*ls’ because these legacy LOB types do not support UTF-8 or UTF-16 encodings. Use types varchar(max), nvarchar(max) or a collation which does not…

SQL Server Error Code – 6363 alter schema collection failed. it canno

In this blog post, you’ll learn more about the SQL Server Error Code 6363 and the error message description that is shown SQL Server Error Code 6363 SQL Server Error Description for the Code :6363 ALTER SCHEMA COLLECTION failed. It cannot be performed on a schema collection that allows laxly validated content and is schema bound. Remove the schema binding before trying to alter the…

SQL Server Error Code – 22586 column ‘%s’ cannot be added or modified

In this blog post, you’ll learn more about the SQL Server Error Code 22586 and the error message description that is shown SQL Server Error Code 22586 SQL Server Error Description for the Code :22586 Column ‘%s’ cannot be added or modified in article ‘%s’ of publication ‘%s’. The DDL operatoin on hierarchyid and FILESTREAM columns is not supported for publications that have a ‘sync_mode’…

SQL Server Error Code – 49704 failed to apply server override on categ

In this blog post, you’ll learn more about the SQL Server Error Code 49704 and the error message description that is shown SQL Server Error Code 49704 SQL Server Error Description for the Code :49704 Failed to apply server override on category ‘%.*ls’, because physical db or instance ‘%.*ls’ in server ‘%.*ls’ is currently not in ‘Ready’ or ‘Deactivated’ state.