Viewing 15 posts - 13,336 through 13,350 (of 18,923 total)
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
September 12, 2005 at 2:49 pm
You can't add a constraint on a non-existing column???
Also have you tried "drop column clainraw"
September 12, 2005 at 2:13 pm
Back to square one. What do you want to do and why?
September 12, 2005 at 1:55 pm
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. ...
September 12, 2005 at 1:42 pm
the add constraint part is not complete.. you need to define the constraint in details. Check bols for the correct syntax.
September 12, 2005 at 1:32 pm
OK... can't give you any. But I doubt you'll get something very usefull from other members as each server/query is unique.
September 12, 2005 at 12:56 pm
Run the queries and see for yourself... we can't remote perf-tune your pc from this board.
September 12, 2005 at 12:42 pm
I don't understand what you need as a result... can you rephrase that?
September 12, 2005 at 12:23 pm
Why not save the results of the query in a reporting table... or send an e-mail with the results of the query??
September 12, 2005 at 12:10 pm
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.
September 12, 2005 at 11:34 am
Shouldn't you make sure that it is BEFORE you write the code and send it to production??
September 12, 2005 at 11:26 am
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...
September 12, 2005 at 10:17 am
Can we see the code of the update trigger?
September 12, 2005 at 9:16 am
Viewing 15 posts - 13,336 through 13,350 (of 18,923 total)