TravisDBA (1/25/2013)

---

Argo was one of the better "edge of your seat films" I have seen in a while. It wasn't a big box office draw but man was it a...

Games of Thrones is definitely geeky cool - I especially love the opening credits and how they sometimes include new towns with all those miniature moving people and mechanisms.

Thanks to...

Jim P. (1/21/2013)

---

I've gotten in the habit with my manager of occasionally dropping this on her desk:

You have a choice:

Good

Fast

...

andy.brown (1/17/2013)

---

webrunner (1/17/2013)

---

I got this when I ran it against a server running Microsoft SQL Server 2005 - 9.00.4053.00:

Results:

(No column name)

0

Messages:

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near...

I got this when I ran it against a server running Microsoft SQL Server 2005 - 9.00.4053.00:

Results:

(No column name)

0

Messages:

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near ','.

Msg 102,...

I admit I didn't know this. Thanks for the knowledge.

- webrunner

Mvrx (1/9/2013)

---

I have seen that when there is a database, and the user has been created but login has not yet been created.

(Not sure if that also happens when...

I think the choice as phrased is ambiguous and should be accepted as correct:

"The Unique key allows NULL values as a value"

This is conventional English phrasing in which "allows NULL...

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

opc.three (12/27/2012)

---

In order to change the owner of a database you must have exclusive access to it. Restarting the SQL Server service will not help if the application immediately reconnects...

Thanks for your response.

I did check the error logs and didn't see anything associated with the blocking. But I tested running the index maintenance...

Thanks for your response.

Yes, it was a query from the application that uses the database,...

Thanks for this!

The author mentions: "There are a number of scripts out there to do this for SQL2000."

Could someone post a link to one of those scripts for SQL 2000?

Thanks...

IgorMi (11/13/2012)

---

Hi All,

My answer was just one sentence, having in mind that I just started a migration process. So it matters what kind of migration you have. For example the...

GilaMonster (11/13/2012)

---

Upgrading from 2000 is a much bigger deal than from 2005, just because of the differences in the versions.

Before you upgrade the 2000 server, run the following:

DBCC CheckDB

DBCC CheckCatalog

If...