Issue time04:14:00 pm, by tom.green Email 42279 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. (Microsoft.SqlServer.Smo)

 

 

Solution

The problem is generated due to an error in SQL Server Management Studio 2008 & 2008 R2.

 

Full story »


Leave a comment
Issue time05:43:00 pm, by tom.green Email 12108 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 the results, you will see the XML execution plan:

SELECT top 10 p.query_plan
   FROM sys.dm_exec_query_stats AS s
   CROSS APPLY sys.dm_exec_query_plan(s.plan_handle) AS p

Note that this happens only when using SQL Server 2008 R2 version of Management Studio, after applying SP1.

 

Solution


Method 1

You can save the XML as a .SQLPLAN file, open it using the Management Studio and you will see the graphical representation of the execution plan.


Method 2

This problem is solved in the next versions of SQL Server, so if you have somewhere else installed SQL Server 2012, you can replace the showplanxml.xsd file from the SQL Server 2008 R2 SP1 installation with a newer version of the file from the SQL Server 2012 installation.

 

Full story »


Leave a comment
Issue time12:43:00 pm, by tom.green Email 11308 views
Categories: Errors, SQL Server

Problem

When trying to restore a backup over an existing database, the following error appears:

 

RESTORE DATABASE is terminating abnormally. The tail of the log for the database "DATABASE_NAME" has not been backed up. 

Use BACKUP LOG WITH NORECOVERY to backup the log if it contains work you do not want to lose.

 

Solution

 Check if the database is in full recovery model. If it is, the message warns that if the database is restored, there are transactions that will be lost.

 

Full story »


Leave a comment
Issue time11:07:00 am, by tom.green Email 23288 views
Categories: Errors, Security, SQL Server

Problem

When trying to create a login the following error appears:

USE [master]
GO
CREATE LOGIN [Domain\LoginName] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
GO

 Msg 15025, Level 16, State 2, Line 1

The server principal ?Domain\LoginName? already exists.

 

Solution

First check if the login is already created:

select * from sys.server_principals where name LIKE '%Domain\LoginName%'

(0 row(s) affected)

 

In my situation the login wasn?t already created so the only thing left was to check if there was some other login created on this instance with the same SID.

 

Full story »


1 comment
Issue time05:47:00 pm, by tom.green Email 20396 views
Categories: SSIS, Errors

Problem

When running an SSIS package from a SQL Server job the following error appears:

?The task "Script Task" cannot run on installed (64-bit) of Integration Services. It requires Standard Edition (64-bit) or higher?

 

Solution

Usually this error appears when the SSIS service is not installed on the machine running the package. Although you have Workstation Components / Client Tools installed and you can create, debug and run packages using BIDS (Business Intelligence Development Studio), to execute the same packages from SQL Agent you need to have the SSIS service installed.

 

Full story »


Leave a comment
December 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