There's probably a better way, but this should work:

select count(*)

frommaster.sys.databasesas DB

inner joinmaster.sys.master_filesas MF on MF.database_id = DB.database_id

where DB.name = 'Express_DB'

and MF.name = 'Express_Data'

and (MF. /131072.) >3.5

if @@rowcount > 0

EXEC...

This is an 18 month old thread. Not sure that necro-posting has much value in most cases.

Wasted my time reading it until I noticed.

Mish-Mash of Campy 10. That's my homemade Franken-bike

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...