answered my own point

you cannot impersonate NT AUTHORITY

http://msdn.microsoft.com/en-us/library/ms181362.aspx

name must be a singleton account, and cannot be a group, role, certificate, key, or built-in account, such as NT AUTHORITY\LocalService, NT AUTHORITY\NetworkService,...

from my understanding you CANNOT login as the SYSTEM account as this is the computer itself and you cannot login as a computer

you could try impersonation but I am not...

is the windows cluster service started, without that you dont have a cluster and no cluster resources will start

Thanks Gail

I will remove the recompile from the proc, thats another thing I have learned today.

Think that has come from the company not having a DBA until two months ago when I started and myself for not completly understanding dynamic sql and execution plans, I...

I have dropped the primary key constraint which I created after investigating the table around an hour ago and then readded the primary key both execution plans are uploaded.

Have to...

USE [Netcars]

GO

/****** Object: StoredProcedure [search].[VehicleSimpleDynamic] Script Date: 11/11/2011 10:03:21 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [search].[VehicleSimpleDynamic](@CapManId int = NULL, @CapRangeId int = NULL, @MinPrice money =...

Sorry Gail, I just edited the above post, I thought I had changed the object in the error log extract to LogTimes

LogTimes and LogSearchTimes are the same object

there is no trigger and the table was a heap until I noticed that there was no clustered index, which I created around 20 minutes ago on the ID column...

Sure

http://www.sqlservercentral.com/Forums/Topic1203984-391-1.aspx

Thanks Guys, I thought an easy question was in order after the past few questions, especially good that its been published on a Friday, good way to wind down the...

I have a situation at the moment with deadlocks which have just started happening with a very minor change to a stored proc.

Inside the proc, the first thing it does...

Thanks Lowell, that seems to be working as the BAK file has been created and no error message.

Must be something in using the NET USE command and providing the user...

didnt think about xp_cmdshell,

will enable it and try the backup

by reading the data sheet, there is a minimum 4 core licenses per physical processor, so if you have 4 cores per socket you break even, but if you only...