To be able to back up the SQL Server databases with DPM, the DPM Agent must be installed on the SQL Server servers via …
Read More »MSSQL
Subquery returned more than 1 value
ERROR MESAGGE: “Microsoft SQL Native Client (0x80004005) Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, …
Read More »The database “xxx” cannot be opened. It is acting as a mirror database.
ERROR MESAGGE: “The database “xxx” cannot be opened. It is acting as a mirror database.” EXPLANATION: You experience this error if you try to …
Read More »Database diagram support objects cannot be installed because this database does not have a valid owner
ERROR MESAGGE: “Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files …
Read More »The report server has encountered a configuration error. Access denied to the path ”.
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 »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 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 »