why do you have a table with a "single field" - what purpose does it serve ?!

Besides - how do you expect to display the values of a single column...

Something else I didn't know about but found in ken henderson's book:

"You can't assign a cursor variable with a SELECT statement - only with SET.."

Also, to make the code...

If you say so I've got to believe you - "stood up and made a fist".. ..recently returned from a cross country with spouse mayhap?!?!

As for someone getting miffed about...

Gosh homebrew01 - this guy must travel at the speed of light...he was here haranguing us just this morning...

IT'S FRIDAY MANIA...

This would be funny if it could still be seen...however, delaware no longer has a "pin point"....

but i did have a blast going through the faq of "mailinator" - thx....

shiver me timbers matey - day's almost upon us...must heave to and forget my landlubber ways..

what error msg are you getting ?!

Dennis - you don't say what syntax you're using - but here's an example from BOL to attach a single file...

EXEC sp_attach_single_file_db @dbname = 'pubs',

@physname...

As a test - could you restore to a "test db" on the same machine and see what it does...?!?!

Here're other possiblities...source - googled site...

 This error means that one or more fields you are inserting/updating contain an invalid value. Some of the possible scenarios are:

1. A string...

....if Utah were to keep Salt Lake City and Provo, move them closer to each other, and then return the rest of the state to the federal government......in a Mormon...

Grant the users Execute permission and see if that does it...it would also be good practice to use the fully qualified name starting with the db name...

here's all the "permissions...

whatever works I guess! Thanks for posting this - I'm sure it'll come in handy to someone else looking for serendipitous solutions!

sc - sorry to've assumed that everyone knows what BOL is - it's books online - comes with SQL Server - if you don't have it - you could probably...

Hi sc - you could do something like this...example for pubs database...The LIKE will give you all rows that have the @userInput value in them - the '%' being wildcards...