Issue time05:29:00 pm, by Email 1132821 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 51578 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 46681 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 time03:04:00 pm, by Email 46655 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 »

Issue time04:14:00 pm, by Email 45723 views
Categories: Errors, SQL Server
Problem After connecting to a SQL Server 2012 instance using SQL Server Management Studio 2008 or 2008 R2, and trying to display different objects (views, tables, etc) the following error is displayed: Index was outside the bounds of the array. (Micro… more »

Leave a comment
November 2018
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