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

Ugh, webinar done on DR this am. I hate these online things. No feedback from the audience makes me slightly insane.

you've really got to format your errors and code and separate them out, as well as ask a question in a professional manner if you want help.

I think you have...