You're welcome. Just keep in mind that that information is based on the release of R2. Microsoft can change that as well as implement licensing procedures for the...

Nice solution by ColdCoffee. This will work for your needs.

Jason Shadonix (4/12/2010)

---

Lynn Pettis (4/12/2010)

---

CirquedeSQLeil (4/12/2010)

---

Where is that one?...

Thanks Lynn.

I have to agree with the others in that thread - I don't see the relevance to a Masters Degree and I don't see why the person would need...

I also have to wonder, why is this "Masters" exam using SQL 2000 as the material for examination? If we provided answers relevant to SQL 2005, they won't work...

Jeff Moden (4/12/2010)

---

This is precisely why I don't trust people with letters after their names. Tell your friend to do his/her own work and to earn the degree instead...

I have a couple of queries that I use for that kind of information. Please forgive the usage of deprecated objects in these scripts. I need to update...

Where is that one? I think it might...

It comes from how the cursor is deallocated. Are you explicitly deallocating a cursor or just allowing the server to deallocate it without a specific command to deallocate.

There is...

Steve Jones - Editor (4/12/2010)

---

Tammy,

We aren't typically annoyed by beginner questions. Even silly ones, but what does get to be "worse" in our minds is the people that don't make...

TAMMYAUDETTE (4/12/2010)

---

Do my questions fall within what you would characterize as "worse" than ususal, I'd say "Probably". But its sink or swim for me in this job and I've...

Can't disagree about the mature technology - but my children always have their engines revved from pre-dawn to post...

Either of those articles would be a good place to start.

Ah yes the circle of life. Raise children from diapers to successful adults. Then they turn around and raise you from successful adult to diapers.

Not a day I...

GSquared (4/12/2010)

---

CirquedeSQLeil (4/12/2010)

---

The ability to raise kids is akin to the ability to write high performing tsql - thus the Thread is an excellent source for how to raise your...