Yes and no. You have the right idea, but the problem is that UserA is inside SQL Server. When you execute the CLR, you should still be inside SQL Server,...

Excellent list of...

You can, but I wouldn't. Is there some reason you wouldn't want to use something like KeePass/Password Safe?

Thanks for the repost. I'll check those out.

We did a few things at various companies.

At one, once a year we sent a team offsite (random admins/DBAs/Devs) and gave them backup tapes, media for software, and a blank...

Do you have login triggers?

Chris is correct. First you need security and stopgap controls. After that, there are lots of ways to track things. Here is a series I wrote on what worked for...

You should be able to log ship to a higher version. Backup/restore definitely should work back a version or two (http://msdn.microsoft.com/en-us/library/ms186858.aspx). It's just a restore, though if you switch over,...

Set the default during setup or later in the server properties. Master comes from the startup parameter. Everything else comes from stored values in master.

Jason is correct. Rebuilding on the primary will rebuild on the secondary.

There's no magic in log shipping. It backs up the transaction log and restores it. You can configure log...

No good way, but one thing I've done is have a job store the current version in a table in each db. That way if I restore a db in...

Gail means use a one way hash. So when someone enters a password, you store it like this:

insert SystemPasswords select 'Steve', pwdencrypt( 'MyPassword')

Then when someone logs into the system, you...

GilaMonster (9/22/2011)

---

I know the feeling....

Hmm, I might debug this by having the procedure run one of those steps and see if it works. It sounds almost like you have some delegation or impersonation issue,...

djackson 22568 (9/21/2011)

---

Yes it does take each person making a small effort. My point is that while that goal is laudable, I don't believe it is realistic. That...