Scott,Have you considered putting some kind of tracer in the beginning of the trigger, before the exec statement, just to make sure that the trigger is not firing? You could insert a row into a log table, issue xp_logevent to put a message into the Windows Application Event Log.*Let us know if that helps, and […]
2004-02-13
Can anyone suggest to me, where i can buy SQL Server 2000 training notes from basics to administration? We intend to start a training center and i am looking for a reliable company to obtain these training notes
2004-01-12
Late night Wed to early morning Thur I removed replication, dropped the primary key on this table, set database to single user mode, ran DBCC CHECKTABLE('tblCorrupt',REPAIR_ALLOW_DATA_LOSS), added clustered index (which I removed Wednesday morning due to corruption), then added primary key, reset database to allow all users to enter, and redid replication. We had a […]
2003-12-19
2003-12-10
FETCH NEXT FROM TRs INTO @HistoryID, @TRno, @Date, @Worklog, @User, @LTIActive, @LTICode If @LTIActive = -1 Begin Set @Status = 'Long Term Issue' Set @LTIField = 'Long Term Issue Code !536871060!: ' + @LTICode End Else Begin Set @Status = 'In Progress' Set @LTIField = ' Long Term Issue Code !536871060!: ' End WHILE @@FETCH_STATUS […]
2003-12-10
1) What is the error message in the history for each. 2) What account is SQL Server Agent set to run under? 3) Is there anything special that these have in common that the others do not? (Such as they access a share on the same remote machine, or they use a particular com object […]
2003-07-17
Have now applied Windows NT4 SP6a and still no change. Will try SQL Server 7 SP 4 and see if that makes any difference but any other assistance would be much appreciated. Grant
2003-06-19
1 reads
Hello Crispin, how did you the picture in the post... ...just out of curiosity (ROTFL) Cheers, Frank
2003-06-11
Access, I believe simply represents the FALSE boolean value (both in data storage and in VBA script) as -1. Both systems actually just look for the absense of zero, not the existence of 1 or -1. I suppose technically it could be -1, 1, or 5 for that matter since internally, it's looking to see […]
2003-05-23
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers