ERROR MESSAGE: “The report server has encountered a configuration error. Access denied to the path ‘c:\program files\microsoft sql server\mssql.3\reporting services\reportserver\rsreportserver.config’ is denied.” EXPLANATION: After …
Read More »Data Pump Export process waiting with the message “wait for unread message on broadcast channel”
During the DataPump export process, if the relevant session is waiting for the following message, you can resolve this issue by doing the following …
Read More »How To Authorize Only a View Without Authorizing Tables (Ownership Chains)
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 »“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 Increase Incremental Backup Speed with Block Change Tracking
You can increase the incremental backup speed with Block Change Tracking, which is one of the features that introduced with 10G. When we enable …
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 »What is Network Access Control List and How To Use It
From 11gR1, access to external network services in Oracle databases is done through the Access Control List (ACL). It is possible to perform operations …
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 »