02/05/14
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 » Tags: opendatasource, openrowset
12/19/13
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 » Tags: ssas, the file exists
08/01/13
<p>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 filte… more » Tags: sql profiler
06/14/13
Problem
After a Sql Server restart, the service failed to start giving the following error messages:
Error: 26049, Severity: 16, State: 1.
Server local connection provider failed to listen on [ \\.\pipe\SQLLocal\MSSQLSERVER ]. Error: 0x5
Error: 1… more » Tags: error: 0x5, status code 0x1
04/11/13
Problem
When trying to browse the SSIS packages from Management Studio the following error can apera:
The SQL Server specified in Integration Services service configuration is not present or is not available. This might occur when there is no default… more » |
11:29:00 am, by 
