Categories: SQL Server, Constraints, Database Maintenance, Database Recovery, Errors, Indexes, Performance & Tunning, Security, Server Configuration, T-SQL

Issue time05:29:00 pm, by tom.green Email 797577 views
Categories: Errors, Security, SQL Server
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 »

4 comments
Issue time05:01:00 pm, by tom.green Email 25750 views
Categories: Errors, SQL Server
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 time12:29:00 pm, by tom.green Email 18370 views
Categories: Errors, SQL Server
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 time12:44:00 pm, by tom.green Email 17372 views
Categories: SQL Server, T-SQL
Considering the following tables (table_1 with IDENTITY column): IF (object_id('table_1') IS NOT Null) drop table table_1 CREATE TABLE table_1 ( Id bigint IDENTITY(1,1) NOT NULL, Col1 nvarchar(4000) NOT NULL Col2 nvarchar(4… more »

Leave a comment
Issue time12:07:00 pm, by tom.green Email 7999 views
Categories: Performance & Tunning, Indexes, SQL Server
Problem Displaying the Estimated Execution Plan of a query takes a long time to complete.   Solution Although, the query is pretty complex, displaying the execution plan should not take more than few seconds. In my case it took over 20 minutes to h… more »

Leave a comment
August 2017
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:

Translate

Advertising











XML Feeds

DBA Blog

Latest posts

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

Poll

Which database platform do you use?

View Results

Powered by b2evolution