Grant - you've hit the nail on the head !!!!

I changed the 'SET Commnet = Cast(Cast(237 As Varchar(10)) As Ntext)

in the slow performing query to just 'SET Comment =...

Grant, the queries are as follows:

-- QUERY 1 TAKES OVER 30 SECONDS AND CAUSES TIME OUTS --

UPDATE [SERVER02].DATABASEA.dbo.TABLEA

SET Comment = Cast(cast(237 AS varchar(10)) AS Ntext)

WHERE UserID = '6FE30BDA-A38B-4DOD-B10F-DC0D324E7883'

--QUERY 2...

Thank you Grant I will certainly do that.

I have your boook on query tuning distilled...Can you advise me on a 'REMOTE SCAN' i am seeing on a linked server. I...

Thank you Gail. Very useful. I dont think i've read about this - unless i've totally missed it. 🙂

Gail - Im sorry - How do i get the data from the default trace ? Are you talking about a profiler trace because i havent been running one ?

So if the datafile auto grew it would have showed up in the sql logs ?

Howard - Is there a similar way to see if teh datafile grew at the same time ?

Thanks very much Howard - that is a really useful script. I have just checked the log backups using this info and everything looks good ie no really big transaction...

Hi

The login has full sys admin rights - its the main account we use to create jobs.

OK Phil will do. I've got a week or 2 to implement this so what this space. Thanks

pj:-)

Phil thats fantastic. Thanks for you advice - it sounds like something as newbie to SSIS i should be able to handle - at least i know now it can...

Thanks Phil - that sounds great.

I have just had some more info from one of the developers who is settign this up and feel my original question may need a...

No I definately wont drop the account I will just disable and rename it i think is the best practice.

Is there a way to see if the sa account is...

Thanks everybody for all the tips.

I finally came up with the following approach using a cursor to loop through the database. I first checked the tables the code returned using...

Thanks Lowell.

I'll look into that technique:-)