why don't you put an identity column instead?it'll be done automatically.

Do you have access to the master database from that server? or a backup that could be restored?

Otherwise I think you're out of luck (unless you have the original mdf...

I always like this one... untill you remember that this can break applications if they use more than one database.

Is it possible to "close" all the database like when they...

You could always try to do an inner join with the soundex() function.

Something like this :

Select soundex('Paris Hilton'), soundex('Paris jr Hilton') where soundex('Paris Hilton') like soundex('Paris jr Hilton')

But I'm...

Sorry about the outburst... was remembering an old post from Joe Celko that went along those lines .

Anyways, I'm in this situation here...

I would hope so... but how would you explain the error then??

It's either corrupted data or conversion error.

I'm not dissing 'em...

Would you be happy if were to have open heart surgury and saw that the nurse was gonna perform the operation. On top of that she's...

you can't call an sp from a funtion.

You can't delete/update/insert into a user table either (can in table variable)

after the open statement :

Dim Er 'As Error

For Each Er In objsDB.Errors

MsgBox Er.Description...

Please do not cross post, we monitor all boards. This questions has been answered HERE

Select CrDate from master.dbo.SysDatabases where name = 'DbName'

What are you trying to do exactly in the server side process?

Can you show the before and after versions of the data?

no it won't, if you have a constraint that forbids duplicates, this is what will fail, not the foreign key.

The foreign key only makes sure that there's a match in...

No and I don't have .net installed here.

Err.. in what language did you need this already?

That's what I was about to write.

Nice job finding this yourself.