Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
If the view does not contain the object in another database, you only need to give the select authority on the view for the …
Read More »MSSQL
“Executing the query “EXECUTE master.dbo.xp_delete_file 0,N”,N”,N” ” failed with the following error: “Error executing extended
ERROR MESAGGE: “Executing the query “EXECUTE master.dbo.xp_delete_file 0,N”,N”,N’2007-11-14T13:06:42′ ” failed with the following error: “Error executing extended stored procedure: Invalid Parameter”. Possible failure reasons: …
Read More »“Msg 8152, Level 16, State 4, Line 1 String or binary data would be truncated. The statement has been terminated.”
ERROR MESSAGE: “Msg 8152, Level 16, State 4, Line 1 String or binary data would be truncated. The statement has been terminated.” EXPLANATION: …
Read More »Generating user instances in SQL Server is disabled. Use sp_configure ‘user instances enabled’ to generate user instances.
ERROR MESSAGE: Generating user instances in SQL Server is disabled. Use sp_configure ‘user instances enabled’ to generate user instances. EXPLANATION: You may experience …
Read More »How To Change SQL Server Database Name
If there is no open session using the database, you can change the name by pressing F2 while on the database. If there is …
Read More »How To Import Images To SQL Server with TSQL Codes
In this article we will import the image files in a folder into a table in the sql server database. First, we create the …
Read More »How To Import Excel To SQL Server Table
In the article “How to Transfer a Table From SQL Server To Excel“, I explained how to export our table from SQL Server to …
Read More »How To Export SQL Server Table To Excel
I explained how to transfer data from SQL Server database to SQL Server database. In this article I will describe how to transfer from …
Read More »SAN Infrastructure of SQL Server Servers and the Story of a Query
In this article, I will talk about how SQL Server writes data to storage and reads data from storage. I will also explain how …
Read More »Network Configuration of SQL Server Servers and Always ON Availability Group Synchronization From a Different Ethernet Card
Before reading this article, I suggest you read my article “SQL Server Always ON Availability Group” to understand the operation logic of the Availability …
Read More »