Forum Replies Created

Viewing 7 posts - 1 through 7 (of 7 total)

  • RE: Corrupted Data Sources

    couldn't find anything to relevent, so it looks like a complete re-install, or should I just rebuild the registry. It will take a couple of days to back up all...

  • RE: Failure to fire trigger

    I have carried on this topic in a new thread as it seems to be a DTS problem

    It is in the DTS Topic group titled Corrupted Data Sources, or something...

  • RE: Failure to fire trigger

    Server :

    SQL Server 2000 - 8.00.384 (Intel X86) Standerd Edition on NT4 (Build 1381 : Service Pack 6)

    I don,t know how to get the client info, but they are running...

  • RE: Failure to fire trigger

    tried that, it goes through all the motions of savin etc, but just never appears. Also when I place a db source onto the worksheet, it will let me configure...

  • RE: Failure to fire trigger

    This is weird,

    I created a new trigger which just outputs a PRINT statement which I could monitor in SQL Profiler. works o-kay, which points to the actual Job or the...

  • RE: Failure to fire trigger

    Sorry : the trigger fires a DTS job, which reads a view I have created to get the very last record in the table and then appends it to an...

  • RE: Failure to fire trigger

    I think your youve hit on something there, about the job failing during execution. (this seems to be a common theme in triggers), I talk some of your previous advice...

Viewing 7 posts - 1 through 7 (of 7 total)