Forum Replies Created

Viewing 15 posts - 2,251 through 2,265 (of 2,487 total)

  • RE: RDO's StillExecuting Property in ADO ?

    Have a look at the State property, that might be what you're after.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    Edited by -...

    --------------------
    Colt 45 - the original point and click interface

    August 28, 2003 at 7:05 am

    #471797

  • RE: DTS No longer working

    What's your access level on the laptop? I had something similar happen to me when the IT department took away my local admin privelages on a new notebook.

    Hope this helps

    Phill...

    --------------------
    Colt 45 - the original point and click interface

    August 28, 2003 at 6:56 am

    #471795

  • RE: @@LOCK_TIMEOUT

    Have a look at the TABLOCK option for BULK INSERT in Books Online

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

    August 28, 2003 at 6:53 am

    #471789

  • RE: Task Dependancy on Concurrent Tasks

    Set up 'On Success' workflow from step 2 to step 3 to step 4. Also add 'On Succes' from step 1 to step 4.

    Having two 'On Success' constraints on Step...

    --------------------
    Colt 45 - the original point and click interface

    August 28, 2003 at 6:49 am

    #471786

  • RE: DTS calling a VB exe -- unstable behavior

    You can setup the trace data to go into a table on the server. This reduces some of the overhead. Have a look at the xp_trace_... procedures in BOL.

    Hope this...

    --------------------
    Colt 45 - the original point and click interface

    August 28, 2003 at 6:37 am

    #471783

  • RE: Results need to be Fields

    You'd probably have to put the results into a temp table and then do something like the old MS Acess crosstab query.

    I think I saw a script that does something...

    --------------------
    Colt 45 - the original point and click interface

    August 28, 2003 at 6:35 am

    #471781

  • RE: Using DTS in an off the shelf application

    Before you get too heavily tied into using DTS as part of your application, take a look at the following.

    http://www.timeline.com/021903PR.htm

    http://www.timeline.com/PatentMemo.pdf

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click...

    --------------------
    Colt 45 - the original point and click interface

    August 28, 2003 at 6:16 am

    #471778

  • RE: Loading Databases SQL 7.0

    quote:

    The Database was in 'loading' mode, looking via Enterprise Manager, and wasn't changing its status for over an hour!

    --------------------
    Colt 45 - the original point and click interface

    August 28, 2003 at 5:23 am

    #471771

  • RE: SQL error 2501: help

    Have a look at the following KB article,

    http://support.microsoft.com/default.aspx?scid=kb;en-us;288745

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

    August 27, 2003 at 6:26 pm

    #471724

  • RE: C: drive full after install

    Do you want to move the distribution database or the Snapshot folder?

    To move the distribution database see the following KB article,

    http://support.microsoft.com/default.aspx?scid=kb;en-us;224071

    To send the snapshots to a different folder you'll need...

    --------------------
    Colt 45 - the original point and click interface

    August 27, 2003 at 6:23 pm

    #471723

  • RE: BCP Utility

    Have you tried using a format file? Easiest way to create a format file is to BCP out from the destination table without providing any parameters. It will then prompt...

    --------------------
    Colt 45 - the original point and click interface

    August 27, 2003 at 6:10 pm

    #471722

  • RE: Example of a linked server to AS400 ODBC

    Don't know if this will be of any help, but this is how we link in our Progress database which resides on a UNIX server.

    

    EXEC dbo.sp_addlinkedserver...

    --------------------
    Colt 45 - the original point and click interface

    August 27, 2003 at 6:04 pm

    #471719

  • RE: Results need to be Fields

    How about,

    select day(callwhen) as day

    from billable_transactions

    group by day(callwhen)

    UNION

    select count(callwhen)

    from billable_transactions

    group by day(callwhen)

    order by day(callwhen)

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

    August 27, 2003 at 5:57 pm

    #471718

  • RE: DTS calling a VB exe -- unstable behavior

    Are you able to make modifications to the VB exe's? If so, one thing I've found handy is to have all database actions and results that the EXE logged to...

    --------------------
    Colt 45 - the original point and click interface

    August 27, 2003 at 5:53 pm

    #471717

  • RE: MSX server

    You could try sp_msx_defect. Look it up in BOL.

    Just make sure your jobs don't get gunned down by the reds as they climb over the wall

    Hope...

    --------------------
    Colt 45 - the original point and click interface

    August 27, 2003 at 5:49 pm

    #471716

    • Viewing 15 posts - 2,251 through 2,265 (of 2,487 total)