Forum Replies Created

Viewing 15 posts - 1 through 15 (of 345 total)

  • RE: profiling a ssis package

    Awesome! That fixed it. Thanks again for the help.

  • RE: profiling a ssis package

    Ah. I see now. duh. I wrote this code a month or so ago. I will test. thanks.

  • RE: profiling a ssis package

    If this isn't the line I am suppose to add then what is?

    EXEC sp_trace_setevent @TraceID, 41, 10, @on

    It's option 10 which is what I added - RPC:Completed. And that...

  • RE: profiling a ssis package

    I have a simple ssis/bids package that connects to my server using the user's id/pwd. It then runs a simple SELECT GETDATE() against my server.

    I added the...

  • RE: profiling a ssis package

    I will try that. thanks.

  • RE: Ftp file

    The account you use for the command prompt isn't the same one used in the job. Sometimes cmd_shell hides the error message you are looking for. have you...

  • RE: profiling a ssis package

    sorry, should have been more clear. I'm doing the trace programmaticly. here is the code I use:

    EXEC @rc = sp_trace_create @TraceID output,...

  • RE: Ftp file

    do you have a proxy setup on this server for cmd_shell?

  • RE: Ftp file

    What is output from that job step? You will probably have to look at the job history to find out.

  • RE: Need alternative for below query

    Any of those table scans could be the issue. Are all tables indexed? I second the suggestion about having covering indexes.

  • RE: Ftp file

    Is the the output from a step or from a query window?

  • RE: http://www.strongehealthcare.com/xlr8-plus/

    How is this post related to sql server? spam?

  • RE: What is my server doing now?

    It turns out that using SSIS to a flat file solved my problem. There was something happening in the background in SQL server that was hung up. The...

  • RE: What Brand of Desktop is best these days?

    kevlray (1/6/2011)


    ...the SATA 3.0 specification, which offers 6Gbit/sec. throughput, and the Open NAND Flash Interface (ONFI) 2.1 specification, which provides sequential read speeds of up to 355MB/sec. and sequential write...

  • RE: What Brand of Desktop is best these days?

    I mainly play Civilization and other strategy games and play them against "the computer" vs online. I could see the temptation to turn AV off while playing a graphics-intensive...

Viewing 15 posts - 1 through 15 (of 345 total)