I`ll give the COALESCE a pop then.

Cheers,

Andy.

It happens from VB and QA.

The weird thing is, is that the SP works, it updates the data as expected but then gets the exception violation??

Andy.

Oracle doesn`t have databases. Do you mean 2 Oracle instances? Or database objects under different owner names?

Andy.

Have alleviated the problem a bit, increased the RAM the server ca use to nearly a GIG. Application seesm to run faster. Have a feeling the locks are...

How much mem would you think? The server already has one gig??

You`d think that`d be way powerful enough for just 2/3users!!!!

I don`t know whats going on??

Andy.

The app`s fine, calling the SP`s in exacly the same way as normal...!

Andy.

I also tried;

WHERE CAST(auto_id as VarCHar(36) = @auto_id

Gets the same exception violation AFTER writing the data back ok. I don`t really want to ignore the error in the Application,...

Sorry antares, I got rid of the Braces, and now it works fine??

Any other ideas?

Andy.

Gets the error I was originally getting when I didn`t put the UniqueID in a Variable. This is;

Syntax error converting from a character string to uniqueidentifier.

The case function must...

This is true, thats why I wasn`t too bothered. Can`t schedule anything but I`ll just do it thru a TSQL Job scheduled on a v7 Server.

Cheers guys.

Andy.

No it`s on a WINNT 4.0 box with SP6a.

Do you recommend running sp_resetstatus?? All the device files etc seem there and ok? It`s pretty weird how it should...

Have you tried using ODBC Passthrough Queries instead?

Andy.

The old log file seems to be corrupt. I tried using that SP to attach the MDF file alone as it says on the MS site that it will...

Tried that.

It won`t let me attach the old MDF file after renaming the corrupted LDF file.

Andy.

Bad news.

Tried a database restore but it bombs out about 6% thru. Some problems with the log file at a certain point. Tried detaching it, and then reattaching...