Categories: SQL Server, Constraints, Database Maintenance, Database Recovery, Errors, Indexes, Performance & Tunning, Security, Server Configuration, T-SQL

Issue time09:25:00 am, by Tom Green Email 2421 views
Categories: SQL Server, Errors, Server Configuration
Problem When trying to install or uninstall SQL Server services, the setup process fails with the following message: Rule "Restart Computer" failed. A computer restart is required. You must restart this computer before installing SQL Server. Thi… more »

Leave a comment
Issue time10:53:00 am, by Tom Green Email 2029 views
Categories: SQL Server, Errors, Security
The following error is received when a user that is not sysadmin is trying to execute the xp_cmdshell stored procedure: exec xp_cmdshell 'dir c:' Msg 229, Level 14, State 5, Procedure xp_cmdshell, Line 1 The EXECUTE permission was denied on the o… more »

Leave a comment
Issue time07:01:00 am, by Tom Green Email 2188 views
Categories: SQL Server, Errors
Problem The following error appears when trying export data from SQL Server to a network share with BCP utility:   xp_cmdshell 'BCP "SELECT COLUMN_1, COLUMN_2, .. COLUMN_N FROM TABLE_NAME"   QueryOut \\SERVER_NAME\SHARED_FOLDER\FILE_NAME.TXT -c /… more »

Leave a comment
Issue time10:20:00 am, by Tom Green Email 5986 views
Categories: SQL Server, Errors
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 time11:51:00 am, by Tom Green Email 1773 views
Categories: SQL Server
Problem When trying to see the execution plan from SQL Server 2008 R2 SP1 version of Management Studio, the plan is displayed in XML instead of graphical format. For example, using the below DMVs, when trying to see the execution plan by clicking on t… more »

Leave a comment
March 2024
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:

Delivered by FeedBurner

Translate

Advertising









XML Feeds

DBA Blog

Latest posts

SSAS More...
SSRS More...
Server Configuration More...
Server Configuration More...
Errors More...
SQL Server More...
SSIS More...

Poll

Which database platform do you use?

View Results

Powered by b2evolution