Possibly...it depends on:

1. How often the data gets updated.
2. When the correct but deleted rows were captured in a backup. (Or if?)
3. What your backup retention strategy is.

I haven't been a big fan of MOM because my organization uses other products that fit the bill just as well, but I know MOM does things SMS doesn't, or...

I used to think the same thing, but learned that this isn't always the case. Sometimes, if we look at a tool and we like it, we can tell our...

Check the version on sqlservr.exe at the file system. That tells you the version of the engine. In rare cases versions can get out of synch, especially if there was a...

Aye, Remi, I am with you on this one. It's generally not a good idea and if the system is in any way sensitive and subject to SOX, SAS70, or...

If you're looking for ASP.NET, I've used http://www.4guysfromrolla.com/ in the past.

At the server level (OS), what security auditing do you have turned on? If you have Success and Failure specified on Audit account logon events and Audit logon events (in...

The fixed database role db_ddladmin allows for this. However, they must specify the owner when touching (creating or altering) the object (as Remi indicates in his post). Otherwise you'll get...

In Red Gate's defense, I received an email through the blogs interface from Simon Galbraith (Joint CEO of Red Gate), asking how to address some of the concerns I cited...

This is a case where you may need to look at another means such as transactional replication. The issues you cite are certainly show-stoppers for this type of read-only solution......

That is correct. Triggers on system tables are not supported and not guaranteed to work.

You can use the trace stored procedures and functions. It's actually what Profiler does.

sp_trace*

fn_trace*

As far...

Where would I start?

1) Get the SQL H2 tool for monitoring up.

2) Write the additional scripts for monitoring you may need.

3) Build backup/restore jobs which can take parameters so you...

It is nice to see SQL Server getting some positive press on the security side. SQL Slammer was big news because of its impact on non-related systems (and networks).

However,...

This works well, too. If, for some reason, you're on Windows 2000 still (not 2003 or XP), I believe sc is available for download from Microsoft as part of the...

All of them are. They are handling capital letters in languages other than English.