Issue time05:29:00 pm, by tom.green Email 1193862 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 time12:25:00 pm, by tom.green Email 51762 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 tom.green Email 48340 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 »

5 comments
Issue time03:04:00 pm, by tom.green Email 47234 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 »

13 comments
Issue time01:47:00 pm, by tom.green Email 46743 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
January 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 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