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...

Not a problem

Just remember when you do go to production with this that you either give the Secondary's agent account the rights to access a $ share, so local admin,...

that's what I thought but the data isn't padded in the db with extra spaces, that was my first check, it must be something in bids which is doing it

The DB is in...

nothing jumps out at me, I do a checkdb once a month using

EXEC sp_MSforeachdb 'USE [?]; DBCC CHECKDB'

it then reads the error log and spits any errors into an email

takes...

thats the network path so the secondary can pick up the logs

as its the same box, put \\hostname\d$\sql\backups

or make the backups folder a shared folder eg \\hostname\backups