Issue time05:29:00 pm, by tom.green Email 797578 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 49658 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 tom.green Email 43754 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 time04:14:00 pm, by tom.green Email 40886 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
Issue time03:04:00 pm, by tom.green Email 38202 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
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