The Transcender practice exams I have seen in the past used to contain the actual questions on the MS exams. There was a time when Transcender, or at least someone...

You can use an application role to limit permissions inside the database to an application, but that does not alleviate some type of login, and as Gail mentioned, it does...

Mirroring would move the connections automatically, though it does require a more regular connection between the systems, or a good log size managements strategy.

Clustering isn't likely what you need, though...

Stephen's suggestions is what I've done in the past for similar situations, though usually for me it's been diff char sizes that exploded things.

In SSIS, you can get a "bad"...

AFAIK, ssms.exe is the SSMS executable. Can you search for that?

Please show your query, and then work on explaining the logic a bit more. It will help if you use quotes to show actual text that should be replaced, and...

Brandie Tarvin (4/6/2011)

---

I heard Disney was doing G-Force and got all excited.

Then I found out it was about guinea...

Battle of the Planets/G-Force, I loved that. I'll have to show the kids. I got one kid to try StarBlazers and he really enjoyed the second or third season. I...

Doh! I do need some QA. I must have typo'd it while adding the image.

Here's the URL: http://www.schneier.com/blog/archives/2010/10/hacking_trial_b.html

I found this, from Bob Beauchamin, who I think is very knowledgeable on stuff like this: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=70053

Basically the XML updates are singletons, so you need two update statements as this...

GSquared (4/5/2011)

---

Just the other day, someone was telling me that, "If you'd lived through the Reagan years ...", without realizing I lived through "the Carter years" and have some slight...

Michael has some good questions. Replication, BTW, is not repetition or repeated rows. It also means something else in SQL Server.

I missed the sentence about duplicate values, and my apologies....

CirquedeSQLeil (4/4/2011)

---

I read the line leading into the commentary about Zune and it gave me pause. Steve alluded to SSC going to a subscription model where access to certain...

Randy Rabin (4/5/2011)

---

Steve,

Just to say up front that I've never used Connect so no first-hand experience. But, could it be that they've just closed the window for new functionality for...

Not an assumption, or it wasn't for me. I had 4 items closed with no comment. A week or so later...