Viewing 15 posts - 39,076 through 39,090 (of 39,754 total)
This is dangerous to do in a trigger. The insert will not complete until the write does and that could be an issue from the OS.
From a trigger, you could...
December 3, 2001 at 4:05 pm
Can you just post all the column names? or generate a script for the creation of the table.
Steve Jones
December 3, 2001 at 3:58 pm
December 3, 2001 at 1:50 pm
December 3, 2001 at 10:37 am
I agree. EM usually works, but if you need something specific like point in time, you'd be better off with QA.
Steve Jones
December 3, 2001 at 10:33 am
Thanks for the update. Yes, terminal services causes some problems, becuase it is not the "console", but a virtual console that does not get all console messages.
Steve Jones
December 3, 2001 at 10:30 am
Another alternative. In sysindexes, the # of rows is stored. Accurate for clustered indexes. You can guessimate (or calculate if there are no varchar columns) the size of the table...
December 3, 2001 at 10:29 am
Good luck and you are welcome. Hope it helps. Personally, I'd avoid triggers if the system is loaded. Actually, I'd rather have something run every minute and snag the latest...
December 3, 2001 at 10:26 am
You'd want the textdata data column, but the T-SQL event stmt starting or completed. These will include other items, but you can filter the result with textdata like 'SELECT%' or...
December 3, 2001 at 10:22 am
Not being too familiar with PL/SQL, can you give an example? I've heard it is a more powerful languange, but not any specifics.
Steve Jones
December 3, 2001 at 10:12 am
I will admit that the GUI is easier to use, but that is often the problem. People mistake ease for right or the best way.
If you use the scripts from...
December 3, 2001 at 10:05 am
You should be able to run Nigel's code without an issue. I agree with Nigel and hate to use cursors, but if I have to, I'd rather decide how it...
November 30, 2001 at 8:54 pm
Is everything exactly the same? There is an ADO bug that causes text problems if the text fields are not at the end of the table.
Steve Jones
November 30, 2001 at 8:45 pm
November 30, 2001 at 8:44 pm
I noticed this too. I think this is an MS bug with the system. It seems that it will only restart SQLAgnet if then service fails for some reason, not...
November 30, 2001 at 1:18 pm
Viewing 15 posts - 39,076 through 39,090 (of 39,754 total)