Viewing 15 posts - 3,826 through 3,840 (of 6,216 total)
So you're just letting the column be nullable?
Andy
July 10, 2002 at 10:43 am
Do you have nested triggers enabled? In the code you posted looks like you're assuming it will be one row per trigger, that's not always the case.
Andy
July 10, 2002 at 7:43 am
I think thats exactly right. Havent run through it all the way myself, usually use a sql login when I need a linked server for testing. I think BOL says...
July 10, 2002 at 7:29 am
Interesting, I'll try to remember to look tomorrow. I rarely run perfmon on the server itself.
Andy
July 9, 2002 at 10:09 pm
Could you post the code you're trying to run?
Andy
July 9, 2002 at 10:06 pm
What is the data type of the column, before the alter?
Andy
July 9, 2002 at 10:04 pm
Everything gets logged, but you can set the recovery mode to simple (SQL2K) or truncate on checkpoint in SQL 7. You still have to have a log big enough for...
July 9, 2002 at 9:58 pm
The best way to see what is stored where is to profile while you create/edit a maint plan. As far as I can tell the only place where the backup...
July 9, 2002 at 9:56 pm
The only bug I find is Q152134, which pertains to 6.0 & 6.5, I dont see any others.
Andy
July 9, 2002 at 9:46 pm
I agree that xcopy used to be more efficient for copying, would be interesting to test to see if still the case. Xcopy was also able to act as a...
July 9, 2002 at 9:35 pm
Beyond that Log Explorer by Lumigent offers a lot more...if you need more!
Andy
July 9, 2002 at 9:27 pm
You just type the text of the trigger in Query Analyzer and then run it, after that the trigger fires whenever modifications of the selected type occur. Doesnt matter that...
July 9, 2002 at 2:34 pm
Try this:
create trigger d_whatevertable on whatevertable for delete as
set nocount on
delete from tableb where idnum in (select idnum from deleted)
Andy
July 9, 2002 at 12:45 pm
If you have multiple recordsets in your DE you have to specify which one.
Andy
July 9, 2002 at 12:07 pm
I dont use it often. You have to bind the recordset to the datagrid, something like set grid.datasource=rs probably.
Andy
July 9, 2002 at 9:46 am
Viewing 15 posts - 3,826 through 3,840 (of 6,216 total)