I meant to quote that running sp_delete_backuphistory was a mistake ..... So I was mistaken about mistakes ..... ooops....:blush:

I don't know of any. We used to have a big problem so I cobbled together a process that runs every minute to look for blocking & then sends me...

Bru Medishetty (10/30/2009)

---

I agree that is...

Ian Scarlett (10/30/2009)

---

That's probably because run_date is actually held as an integer in sysjobhistory, not a datetime.

Have a look at the advice you've been given on some of the other...

SQL Server Agent -> Properties -> History

Erich Brinker (10/30/2009)

---

I would try tuning his query instead of automating a process to kill it. If he is a bigshot as you say, he is likely to get...

That's useful information. Why do you want to delete it ? Most of the time the question is about getting more history info, not less.

ebenraja (10/30/2009)

---

Guys,

Thanks a lot for all your response. I have actually missed to inform that my set up is an SQL2000 Enterprise edition so i am left out with using...

What type of queries ? Update ? "select" only ? Hitting production ? Is there blocking ? Can you tune the queries ? Set up a...

If you switch to simple recovery, when you switch back to FULL recovery, you must take a new full backup to restablish your log chain to allow point-in-time recovery going...

Paritosh-412771 (10/29/2009)

---

Hi homebrew01

Well thnkx for this script.

But my problem is that how can I found out the backup is happening on the SQL Server is happening through third party tool...

David Benoit (10/28/2009)

---

1. Yes, you can select a specific list of columns when you create the publication.

2. I'm not sure but why wouldn't you make the tables identical on...

You may also have people who know the SA password.

Here's a script I got from somewhere that gives you a lot more info as well. Look at the sysadmin column...

select DownloadCount

from File

Where FileCode = @FileCodesql

I'm not sure if you mean actively running processes, or backup history. I use this to get a variety of backup history information. it might help you to modify it...