I don't think there is a lookup table that you can query directly on SQL Server.

the description of the levels is actually in BOL

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlerrm9/html/3e7f5925-6edd-42e1-bf17-f7deb03993a7.htm

I know this is not good news...

I have always done *many* unanticipated activities for the benefit of the company I work for but it has always been as temporary basis. This situation should never be unbalanced...

Paul Stasny (9/26/2007)

---

Greetings,

I'm a little new to this and could use some help

I have a database where several tables have a column called FilterNumber (about 35 Tables). Not all tables...

Here is an example:

http://www.simple-talk.com/sql/learn-sql-server/pop-rivetts-sql-server-faq/

2005 solved that problem ...

wow I have never thought of that......

Brian Fischer (9/25/2007)

---

Hi, I'm a noob just wanting to know how to determine how many transactions a day I have going in and out of my database. I know that's...

it is a bad Idea to MIX old syntax with ANSI joins.

Have a look at sp_executesql

Mark Shvarts (9/26/2007)

---

Hi Noel,

While your solution looks interesting, I copied it but I still get only one result set, while I need both.

If I try to add select *...

There is a BEGINNERS section for these kind of questions.

Looks Like a bug in SSC code 😀

http://www.databasejournal.com/features/mssql/article.php/3331881

I don't know what happen use Copy + Paste of the above in your browser

http://www.databasejournal.com/features/mssql/article.php/3331881

Jeff Moden (9/26/2007)

---

Yes, it can be done pretty easily...

When you open the table in EM, instead of selecting all rows, tell it to select the TOP 1. Makes the...