Scott - sounds like you have a different problem now than what you originally posted...

this site should help you...http://dbforums.com/t441213.html

Remi - I just placed a (huge) bet with myself that you will carry your laptop with you next week (& the week after that)!!

Do I win ?!

what do you get if you do a count(*) of your candidatemst table and a select distinct(candiid) from your resumelist table ?!

what are the ddls of the 2 tables ?!

Philip's solution is much better - this way there won't be a need to have 2 columns!

Explicitly specify the database name:

Grant Select ON DATABASENAME.[INFORMATION_SCHEMA].[COLUMN_DOMAIN_USAGE] to [public]

If you absolutely HAVE TO HAVE an autonumbering text based field, one way you could do it is by having your IDENTITY column and then adding a computed column (textID)...

Hey Mike - Thanks for the post!

btw - is Nature not walking by this morning ?! <:-)

vive la femme! <:-)

You could also check EM under "Management" - "Current Activity" to see if there are any processes running against the database that you want to restore. (Locks/Object)

Mike - there's an echo in here - I said something along the exact same lines in "Anything that is not SQL" yesterday - would you pl. be kind enough...

Bien Venue Remi - I knew you couldn't keep away! If I were rich I'd bet all my money on this one fact!

<;-)

At any rate, the answer to your question...

All is clear now...

"master sysobjects contains the objects of ... well master

local db sysobjects contains the objects of ... well local db sysobjects

One sysobject per database"

....but temp tables are listed...

Bill - what did finally work for you ?! And was your & Melissa's posts the same - meaning are you working together or were they different posts that got...

Amen!

<:-)

Happy Viewing! Make sure you get some lime with that Corona! The long weekend coming up should also be restorative...!!!