Issue time05:29:00 pm, by Email 1258854 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 »

Issue time12:25:00 pm, by Email 52023 views
Categories: Performance & Tunning, SQL Server
To specify multiple values for LIKE or NOT LIKE column filter you must simply press enter after you have typed the first value. Another textbox will be automatically shown under the first one, giving you the possibility to insert multiple filters based… more »

Leave a comment
Issue time05:58:00 pm, by Email 49670 views
Categories: Errors, SQL Server
When you try to revoke the rights of a login on a database the following error can appear: Cannot drop the user 'dbo'     Solution This happens because the dbo user is mapped to that particular login.      You need to change the database own… more »

Issue time01:47:00 pm, by Email 48576 views
Categories: SSIS, Errors
Problem When executing an SSIS package, the following error appears: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED.  The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occ… more »

1 comment
Issue time03:04:00 pm, by Email 47830 views
Categories: Errors, Server Configuration
When trying to install SQL Server 2008R2 SP1 the following error can appear:   A Failure was detected for a previous installation, patch, or repair For instance ?MSSQLSERVER? during configuration for features [SQL_Engine_Core_Shared, SQL_POWERShel… more »

March 2019
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


Email Subscription

Enter your email address:



XML Feeds

DBA Blog

Latest posts

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


Which database platform do you use?

View Results

Powered by b2evolution