Since you're posting in the SQL Server 2008 forum, I'm assuming the legacy database has been ported over to this version. The solution below may also require the database Compatibility...

We could create a DDL trigger or a nightly job that replicates sys.databases to a dbo.DatabaseList table. Also, we don't really need a dbo.BackupList table and foreign key just to...

Gary Varga (4/15/2014)

---

Eric M Russell (4/15/2014)

---

I'm glad to hear that your nephew is the type who stays after hours to get the job done. He'll go far. Just think how...

I'm glad to hear that your nephew is the type who stays after hours to get the job done. He'll go far. Just think how useless a surgeon, attorney, or...

I wish Microsoft had called this latest release SQL Server 2012 R2. Now those of us not planning to use v2014 in the forseeable future look like fuddy-duddies.

I've got half a dozen retired PC boxes stacked in a corner under my desk on which I'm installing a Ubuntu / Hadoop cluster. My intention is to prove whether...

First, are we creating the [databases] table? There is no table by that name, but there...

If management allows an hour for lunch and places no restrictions on how early one can enter the office or how late one leaves, then there can always be time...

Going from v2000 to v2005 was obviously a leap forward in terms of how SQL Server database are implemented and coded. To a lesser extent v2008 had some compelling features...

Steve Jones - SSC Editor (4/11/2014)

---

Eric M Russell (4/11/2014)

---

Obviously the government, whether it be Congress or some agency dedicated to the task, can't come up with the standards; it has...

Steve Jones - SSC Editor (4/11/2014)

---

Eric M Russell (4/10/2014)

---

The standards would not have to be very technical. Dedicated sysadmin accounts, removal of service accounts from sysadmin role, seperation duties, application...

Gary Varga (4/11/2014)

---

john.riley-1111039 (4/11/2014)

---

There are many circumstances in life where we prepare for relatively unlikely events. We install sprinklers and fire extinguishers in buildings,

air bags in cars, pilots...

Gary Varga (4/10/2014)

---

Just define legal requirements to be best endeavours. I think that most sectors where it counts there are further standards, for example in the UK we have the...

OCTom (4/10/2014)

---

Hackers are not going to try to hack all severs. They look for the easiest path. This is one area where it's best to be the ugly duckling at...

I believe that SQL Server already has the required features to implement auditing (SQL Server Audit and extended events), granular controls (permissions), and seperation of duties (database and server roles)....