Category: Errors

Issue time11:29:00 am, by Tom Green Email 619432 views
Categories: SQL Server, Errors, Security
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 »

Leave a comment
Issue time11:01:00 am, by Tom Green Email 7340 views
Categories: SQL Server, Errors
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 »

Leave a comment
Issue time06:30:00 am, by Tom Green Email 4705 views
Categories: SQL Server, Errors
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 »

Leave a comment
Issue time09:25:00 am, by Tom Green Email 1973 views
Categories: SQL Server, Errors, Server Configuration
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 »

Leave a comment
Issue time10:53:00 am, by Tom Green Email 1656 views
Categories: SQL Server, Errors, Security
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 »

Leave a comment
October 2020
Sun Mon Tue Wed Thu Fri Sat
 << <   > >>
        1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31

Search

Email Subscription

Enter your email address:

Delivered by FeedBurner

Translate

Advertising









XML Feeds

DBA Blog

Latest posts

SSAS More...
SSRS More...
Server Configuration More...
Server Configuration More...
Errors More...
SQL Server More...
SSIS More...

Poll

Which database platform do you use?

View Results

Powered by b2evolution