SELECT O.XType

, O.name

FROM dbo.SysObjects O

WHERE ID IN (SELECT TOP 90 PERCENT ID FROM dbo.SysObjects O2 WHERE O2.XType = O.XType order by O2.Name)

ORDER BY O.XType, O.Name

You can't add a constraint on a non-existing column???

Also have you tried "drop column clainraw"

Back to square one. What do you want to do and why?

Do it again in EM. But before saving it, click on the script button to see how EM does it. Then you'll know what to search for. ...

the add constraint part is not complete.. you need to define the constraint in details. Check bols for the correct syntax.

OK... can't give you any. But I doubt you'll get something very usefull from other members as each server/query is unique.

Run the queries and see for yourself... we can't remote perf-tune your pc from this board.

I don't understand what you need as a result... can you rephrase that?

Why not save the results of the query in a reporting table... or send an e-mail with the results of the query??

Why would you want to do that?

Not that was not the problem... In my case the where was simply ignored. I had a where len() < 1000 and the string built up to 8K anyways.

HTH.

Shouldn't you make sure that it is BEFORE you write the code and send it to production??

You need to use triggers to do this. Create an audit table for each table you need to audit. Then create the trigger to insert into those tables...

Can we see the code of the update trigger?