Stupid question, and I know this may sound insulting (it's not the intention), are you sure you're running checkDB on the right database?

What version of SQL 2000? (SELECT @@Version)

Then you want to stay away from the official conference hotels. They are not cheap. I'll probably be staying at either the 6th Ave Inn or the 7th Ave Inn...

Don't give people alter table permissions?

Is there perhaps an index rebuild that runs after whatever triggered that mail but before the checkDB?

Are you paying or is your company paying?

All the conference hotels are within walking distance of the conference centre. The closest is right across the road and the furthest is...

krypto69 (4/21/2009)

---

If I put it at the top of statement, it says 'completed' but when I go back in and look at the proc, the isolation level part I just...

Please post table definitions, your test data and desired output. Read this to see the best way to post this to get quick responses.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

airparkroad (4/21/2009)

---

I'm preparing for the 70-433 SQL SERVER 2008 Database Development.

I was digging through some of the 2005 material and went across this information.

http://www.microsoft.com/learning/mcp/mcitp/dbdev/default.mspx

The above site states that in order...

Cowboy DBA (4/21/2009)

---

They monitor performance so I need to get an at-the-time snapshot. I already use UNSAFE as they grab perfmon stats so I definitely take your point r. over...

Grant Fritchey (4/21/2009)

---

You will receive notification. I'm not sure if you can see that it was accepted on your profile or not. If I remember correctly from last year (and...

No errors there. Are there any messages in the log that relate to the database Common?

Do not play with threading in CLR. I believe it requires UNSAFE and, if you're not careful you could crash the entire SQL instance. If you play with threads in...

Have a look through the SQL error log. There will be more details there regarding the cause of...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic701350-338-1.aspx

Indexes created by constraints (like primary key) do not allow include columns.