Forum Replies Created

Viewing 9 posts - 16 through 24 (of 24 total)

  • RE: Transaction Log Reader

    There are a few different ways to go with this. Obviously the Lumigent solution, and I will agree with you on that one. It is kind of expensive for small...

  • RE: milliseconds datetime format in vb

    DB2 on the OS/390 - z/OS uses a timestamp that has 6 places behind the second. Some of the data I deal with on this system uses a unique timestamp...

  • RE: milliseconds datetime format in vb

    That looks pretty good. The one issue I have with it, and unfortunately I don't have a lot of time to devote at the moment, would be does it go...

  • RE: milliseconds datetime format in vb

    You are correct that the only solution to this is in the SQL. You will never be able to get milliseconds using VB 6(however VB.NET, from what I have read,...

  • RE: Log Truncation under Replication

    The Continuous switch is set on the log reader agent. But, correct me if I'm wrong, I want to have it set to continuous if I am looking for Real...

  • RE: Log Truncation under Replication

    Yes, it is. And as far as the log reader, that is one of the scripts I have set up for this database (to force it to completion).

    I was...

  • RE: cursor help

    This should take care of what you want. There should be a better way of doing this than what you are shooting for.

    Also, this code is set up in the...

  • RE: Setting up SQL Mail??

    CDONTs is a bit more stable than xp_sendmail.

    It is very easy to set up, however you will need to set up three stored procedures on each server (as opposed to...

  • RE: List of Stored Procedures

    Actually if you use the category != 2 instead of base_schema_ver != 16 you will get all of the user defined stored procedures in a database.

    Single Ex:

    select [name]

    ...

Viewing 9 posts - 16 through 24 (of 24 total)