Welcome to the club !

You can buy a product like Idera's Compliance Manager. It can be set up to send alerts for all different types of operations.

I do the trigger part like this. Not sure about the email.

CREATE trigger [dbo].[update_trigger] on [dbo].[MyTable] for UPDATE

as

if

UPDATE

(Field1) or

update

(Field2)

begin

insert into...

cwedgwood50, What functionality are you looking for that the built in SQL script generator function doesn't do ??

Could she restore Master to a test box, and extract just the 1 row for that login ?

Even more space would be better. There are always situations that come up during upgrades, year end processing, big data fixes etc that will require extra backups to be taken...

ALZDBA (3/27/2008)

---

I assume someone dropped the database using Management Studio.

It has a default do delete all backup info as well.

AFAIK, you still need to delete the backup files manualy.

So have...

Thanks .... that fixed it. Although I'm spoiled with Compliance Manager on...

Hmmmm.........I only have 1 log.trc file in an unused folder, last modified on 8/2007

If the database AND the backups are deleted, it doesn't sound like an accident. Are you sure it was backed up at all ? If you've only been...

After reinstalling SQL, the system databases will have the new collation, but msdb will be empty (no jobs or DTS). If msdb is restored from a backup, then it will...

And the 4 "foreach" links at the bottom of the page are dead.

Jonnie Pettersson (3/19/2008)

---

Ian and PSA

I think you are missing the point here...or am I 🙂

If your database and temDB collation differ you have to either rebuild the masterDB or create...

If you just want to make the code work, then you can use the COLLATE function to get them in sync like so:

select * from TableA A

join TableB B on...

GermanDBA (12/18/2007)

---

Hi Homebrew,

Sorry, I think you misunderstood.... sarcasm is not an easy thing to display when writing on a message board.

I only meant that I made the mistake of not...