Basically,

After your application has done what it needs to do the connection is not instantly dropped. The connection remains open in the application pool. As such, AWAITING COMMAND...

You could set up your own job that constantly monitors relevant jobs and checks to see how long they have been running for. If there's a particular job that...

Put it this way, if log backups only worked off the most recent full backup then log shipping would never work if you ever did a full backup of your...

That relates to SQL Server 2005. But as I stated, that only integrates SSMS with Visual Source Safe but not vice...

ALZDBA (4/18/2008)

---

- off course you cannot apply previous log-backups to the new full backup.

- every full backup starts a new recovery "cycle".

- For SQL2005 there is this new "copy_only" parameter...

Hi Mark,

The answer is yes, it's still possible to restore to a point in time when using the earlier backup. Naturally, you'd have to restore more log backups than...

Andras Belokosztolszki (4/18/2008)

---

Well, database evolution is sort of at the center of my interest, and I've been working on such a solution. On http://www.simple-talk.com/sql/database-administration/source-control-and-databases/ I describe some of the problems...

I wasn't sure that anything had changed between 2005...

Grant Fritchey (4/17/2008)

---

Huh, I'd assume a try catch even on a single row single table update. Even there you could run into deadlocks, whatever, that you want to handle within...

matthew (4/17/2008)

---

So you don't do a try - catch when only updating one table? What does your try-catch block look like when you do use one?

Also, do you use...

Imke Cronje (4/17/2008)

---

Hi Guys,

I have to write the following message in an autogenerated email:

Dear name surname,

First sentence here.

Second sentence here.

Regards

DBA

Does anyone know how I can go to the next...

matthew (4/17/2008)

---

Does anyone have a template for what they consider is the perfect update stored proc? Say for a fictitious customer table?

Would love to see how the experts do...

Matt Miller (4/16/2008)

Obviously this doesn't beat actually analysing the problem with some practical data and seeing what works best for you.

My biggest concern with this example is the inserts/updates/deletes and...

Amit Kumar Sunkuru (4/16/2008)

---

I checked the whole stuff on a different box which had more data.

Sys Time and SQL Server Time are in Sync.

I re checked the job History....

On my box the Event Time for the package starting is just a couple of seconds out from my job start time.

Did you check the package start time that you...