Well, I managed to get around the problem with help from Roger Doherty from the following link: http://blogs.msdn.com/rdoherty/archive/2005/03/16/396956.aspx

Didn't realise you could change the input/output of the task in...

GSquared (11/24/2008)

---

I would create a trace on the database, see what's connecting to it (if anything) and track that for a while. If no activity except you checking in...

Thanks for the response Hanshi. I did wonder if I was looking for a 'catch-all' when in fact there isn't any. I'm suprised that SQL doesn't keep an archive of...

When you try to shrink the log/DB...

Many thanks Paul & Markus.

I have now noticed that like you say the SP2 on the devserver2 is RTM and was mislead by the fact it said (Service Pack 2)...

It is supported? Because I have the following version of SQL:

Microsoft SQL Server 2005 - 9.00.1399.06 (X64) Oct...

Looks like your question has already been answered, but I've found out over the past few months personally that SSIS is not cluster aware. Also if you are looking to...

Thanks a lot VG.

I'm going to try this now. My biggest concern is the SQL Task at the beginning which is grabbing the Maximum ID is not storing the result...

Thanks David & Ian. Yes, the question was mostly answered but you have both given me peace of mind in what you have said.

Yes, the memory is set to dynamic...

Anyone else able to help with this?

Thanks

Age2uN (10/21/2008)

---

Limiting the Max-Memory for SQL Server to physical memory of the box minus 1.7 GB has proven

quite a good value whenever there are other apps running on the...