This will depend as Elliott has said. Compliance you are seeking will have an impact on which encryption you use. It is not uncommon to employ both database...

Scott,

Take Lutz' advice here. The task is many times simpler to use the update statement he suggested and perform this query in a set-based fashion. Do not use...

gilbert delarosa (3/12/2010)

---

Each of my clients has its own database with all of the same obects. I often have to query data for all clients for internal reports. I have...

http://msdn.microsoft.com/en-us/library/ms190202.aspx

http://www.amazon.com/Pro-Server-2005-High-Availability/dp/159059780X

http://www.amazon.com/Microsoft-Availability-Clustering-Database-Mirroring/dp/0071498133

Oh that would be too much fun. To culminate it, nobody would reveal it until the next day, buahahaha.

-5 pts should be a great one - make the question...

profiler

trace

sp_who2 (if they are running it currently)

those are a few options.

Also check out the article from yesterday (I have used this in the past to do the same sort of...

One option would be to enable a logon trigger and capture the logon information out to a table with a datestamp.

.

Alvin Ramard (3/12/2010)

---

I emailed you my question. Even though I had soemthing...

Grant Fritchey (3/12/2010)

---

CirquedeSQLeil (3/12/2010)

---

Grant Fritchey (3/12/2010)

---

And then the next day you get a call from your manager who explains exactly why you'll be doing whatever heinously stupid operation it is...

Grant Fritchey (3/12/2010)

---

And then the next day you get a call from your manager who explains exactly why you'll be doing whatever heinously stupid operation it is that the developer...

sing4you (3/12/2010)

---

CirquedeSQLeil (3/12/2010)

---

sing4you (3/12/2010)

---

We have yoga and t'ai chi classes here at work. Three lunch hours per week, I'm at one of those. I also get out and...

Scintillating.

GSquared (3/12/2010)

---

CirquedeSQLeil (3/12/2010)

---

GSquared (3/12/2010)

---

If we did the "Delusionally Thinks He's a DBA" contest, there would certainly be a lot of competition for that one.

But I think if we had a...

Paul White (3/12/2010)

---

CirquedeSQLeil (3/12/2010)

---

Paul White (3/12/2010)

---

Jason...CTRL +...

GSquared (3/12/2010)

---

If we did the "Delusionally Thinks He's a DBA" contest, there would certainly be a lot of competition for that one.

But I think if we had a "Please God...