Category: Errors02/05/14
Problem
When executing queries using OPENROWSET statement, the following error can appear:
Msg 15281, Level 16, State 1, Line 1
SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this… more » Tags: opendatasource, openrowset
12/13/13
Problem
When running some transactions on a database the following error appears:
Msg 9002, Level 17, State 4, Line 2
The transaction log for database 'Database_Name' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_… more » 12/12/13
Problem
When trying to view the properties of a database (right click in SSMS and choose Properties from the drop down menu) the following error is displayed:
Cannot show requested dialog. (SqlMgmt)
Property Owner is not available for Database ?[Data… more » 12/04/13
Problem
When trying to install or uninstall SQL Server services, the setup process fails with the following message:
Rule "Restart Computer" failed. A computer restart is required. You must restart this computer before installing SQL Server.
Thi… more » Tags: restart computer failed
12/03/13
The following error is received when a user that is not sysadmin is trying to execute the xp_cmdshell stored procedure:
exec xp_cmdshell 'dir c:'
Msg 229, Level 14, State 5, Procedure xp_cmdshell, Line 1
The EXECUTE permission was denied on the o… more » |
11:29:00 am, by 
