There are too many things that could affect this.  I would advise that you see if this is a trend before assuming anything dire.  If the backups are still sluggish...

Insert the results into a temp table with an added IDENTITY (INT, 1, 1), in the order you want them displayed.  Then use an UPDATE to do the magic, something...

I think you're getting your PRINT output, but Access is losing it for you.

You could create a work table and instead of using PRINT, use an INSERT into that work...

Analyze This!

Cannery Row

The Fifth Column

Key Largo

Checkpoint

The Execution

The Temp

One thing you might consider, if you don't have to worry about ongoing transactions "while U wait", is a variation of Mike's suggestion.  Use BCP with the QUERYOUT option to...

I'll be interested to see what others have to say on this one.  To the best of my knowledge (which has holes that I find dismaying at times), you cannot...

> The trigger will only fire if there are rows affected so checking for rows affected is unnecessary.

How do you do that?

> Man. you rock. that seems to be working pretty well.

Glad I could help.

> Is there a way to speed that up to create new TX tables and triggers?

That's...

Seems like a slightly odd request, but here goes:

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

CREATE TABLE #prds

  (prd_id CHAR (2) NOT NULL)

INSERT INTO...

I suggest you familiarize yourself with what BOL has to say about CREATE TRIGGER, SELECT INTO, and other related stuff, and also follow any available links to familiarize yourself both...

I don't think you want the JOIN.

SELECT DISTINCT col_Fname

FROM   tbl_Reports

WHERE col_Fname NOT IN (SELECT col_Fname

                        FROM tbl_Employees)

 

An earlier post pointed out the missing end-parens.

Also, it looks to me like the WHERE clause in the nested "IN (SELECT" etc. is missing criteria.  I.e., what is this supposed...

Just a thought... Check out the permissions of the server login who owns the SQLSERVERAGENT service.  If your login has permissions to run the commands and the service owner does...

Questions like that are, in my experience, a Catch-22.  If the non-technical person can understand them, they aren't technical descriptions.  If the descriptions are accurate, the non-techie will not understand...

There was a study done recently that found that incompetent people are quite often unaware of their incompetence -- they simply don't know what they don't know.  In fact, perversely,...