Issue time05:29:00 pm, by Email 1071664 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 51366 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 time03:18:00 pm, by Email 45474 views
Categories: SSAS, Errors
Problem When trying to restore a SSAS database cube from a backup file, the following error appears: The following system error occurred:  The file exists. (Microsoft SQL Server 2005 Analysis Services) Solution I encountered this error in two diff… more »

Leave a comment
Issue time03:04:00 pm, by Email 45387 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 45197 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
September 2018
Sun Mon Tue Wed Thu Fri Sat
 << <   > >>
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


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