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

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

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...

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...

I will try that. thanks.

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...

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,...

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

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

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

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

How is this post related to sql server? spam?

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...

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...

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...