Good question. I didn't knew about SOAP so answered correctly. Didn't had idea or clue about it. So happy to gain 1 point plus the information I got. 🙂

Haiao, I experienced one such issue as well with one of my friend's client. There the issue was very basic. All the DBs were configured with Full recovery but the...

Sej, Though it's little old post but did you got it rectified ? As the SQL masters told, the error message clearly shows that there is no user created in...

Hi Gurjer48,

Just open google, type normalization and hit enter and you'll have thousand links to know about Normalization. You can search out here in sqlservercentral as well. 🙂

You might want to compare the time difference while doing dome operation on your webpage and running the underlying query on sql server to check if there is some issue...

Thanks. Good question.

Pretty easy.

I'm glad that fortunately I checked table's definition and while going through trigger definition got the clue. Than it was easy for me to pick right answer. 🙂

Good easy question. 🙂

The options were not well defined but the question's intentions were good.

Very good question. I like these kind of confusing codes and parsing in my mind. Though it gave some pain (in my head) solving this but was correct with the...

Christian Buettner-167247 (4/3/2013)

---

Von Microsoft am 29.12.2009 um 12:11 bereitgestellt

I am resolving the corresonding SQL11 bug as "by design". Here is the explanation: The semicolon between END TRY and BEGIN CATCH...

Bob Cullen-434885 (4/2/2013)

---

I selected the syntax error option but not for the reason stated. The question states SQL 2005 and higher, but THROW evidently makes its appearance with SQL 2012,...

Easy one. Knowledge brushing question. 🙂

I got it correct. However assuming some other logic but anyways got corrected by the explanation and got one point (to my bonus) 🙂