Honestly I don't know of any other way to view blocking on a server. Not to say there isn't one, I just don't know it.

What you could...

If you set the trustworthy attribute on the database to ON then your user will have the permissions of it's associated login available to it. Be for-warned though that...

Sorry I'm a little bit late posting my answer to the "homework". Lot's of people had posted correct answers already so I didn't feel all that rushed to post...

I would tend to agree. Dynamic SQL is a very powerful tool. But it's just one tool of many and should only be used when it's appropriate and...

Excellent tool and one I've been looking at myself.

Just to add to the comments about using SA as the database owner. There is a somewhat obscure potential...

sknox (1/3/2013)

---

roger.plowman (1/3/2013)

---

This issue is yet another example of why SQL is one of the worst-designed languages of all time from a syntactic POV.

Would it have killed the designers to...

Nemeaux (1/3/2013)

---

Although the overall technical correctness of this article is good there is a glaring error in the narrative. There is no such thing as a "single quote" mark. There...

pop022 (1/3/2013)

---

I know the point you were trying to get across, but using sp_executesql is not needed to print the value of the variable. It could simply be written...

I looked at Quotename when I was writing this but honestly I'm still not sure exactly what it does. I tried it out...

BrainDonor (1/3/2013)

---

I have frequently had to script out Stored Procs that use dynamic SQL, and the joys of altering the number of quotes defies description.

Using the 'Generate Scripts' option within...

MG-148046 (1/3/2013)

---

johnbrown105 56149 (1/3/2013)

---

Michael R. OBrien Jr (1/2/2013)

---

I guess I have never been a fan of triple quoting, I usually use CHAR(39) I find it is a lot easier to...

Until you get a script that doesn't work because the author decided they were used to RUN as a batch separator and that's how they...

The particular instance I'm looking...

If your SQL Server Instance will not be accepting remote connections (connections not comming from...

ScottC91 (11/26/2012)

---

What is the difference between option 1 and option 2? If option one would cause the default to be selected because that column will be null why doesn't manually...