I don't want to tackle everything (dont have the time) but for starters i would make sure that autoclose and autoshrink are not ticked on the the DB properties.  Autoclose can...

Go on then, i'll do it....

Can you give us a little more detail on what it is you're trying to accomplish, as everyone knows on this site cursors are very...

Hi Carl,

Are you refering to an orphaned connection caused by an extended stored procedure that terminated but left the connection open?

If so I do have a solution (other than stop/start)...

nice one aunt kathi

Sorry but no, we upgraded our sql cluster to SP4 a month ago (w2003 enterprise for IA64 and sql 2000 enterprise for IA64) without any problems.

I'll have a look around...

There sure are a lot of cynics out there

I can guarentee that of all the people showing on the leaderboard none of them...

As if I need to redeem myself , and seeing as it's our game it stands to reason that I do have insider knowledge

Lol, you know you love me really

Just imagine how much work my posting one little link has stopped you from doing, in...

That's a pretty good score, although i've been off the top 10 for ages now, i can't get anywhere near the ones that are there now

Nice one Steve,

I signed up for a couple of the beta exams but haven't been invited to take them yet (don't know if i will be), even so it's good...

Dont know if it will fully answer your question but here's a link i came across the other day

http://msdn2.microsoft.com/en-us/library/ms178067.aspx

I can't agree more, there's no way that those 2 words should ever appear in the same sentence

Oh, wait, how about...

"it's no good,...

Here's a link with a solution to your problem,

http://www.ssw.com.au/ssw/kb/KB.aspx?KBID=Q365270

Just to add that with SQL 2005 source control is built into the design (assuming that you have source safe/vault/etc).

If you're planning on upgrading in the near future then i'd...

To be honest i can't remember ever having to go back to an older DTS package, however, just to be safe you can open the latest version and use the...