Oh well. Consider this forum post...resolved.

Through the GUI, the TSQL is:

EXEC sys.sp_configure N'remote proc trans', N'1'

GO

RECONFIGURE WITH OVERRIDE

GO

I noticed "WITH OVERRIDE"...

I guess I don't fully understand the difference between the two and why it would...

David, your first link helped. In reference to a post in the blog:

While I don't understand the difference between running the above script...

I thought it would be helpful to point these few things out:

- The distribution database exists on another server

- The server I'm creating the publication on is set up as...

Has anyone any additional advice on this?

Appreciate it Dev, but I've tried that already. In fact, I've completely disabled Distribution/Publication on the server, dropped all subscriptions and started over from scratch...I still get the same...

1. Can you post your Cmd code?

2. Does it work properly when you run it via a command window?

Not sure if you resolved this issue or not, but I had the same issue on only one server in our company, it was resolved by the advice offered on...

Wow, I can't believe took over 30 mins going through google (NOTHING came up on any microsoft sites..) but finally found this - in case anyone is interested:

http://www.sqllion.com/2011/11/job-running-status-report-in-ssrs/

0 - Completed...

Another note to aid in what has been already offered above...when thinking about running reports off the standby db's (logshipped) you need to remember that you cannot create indexes there....

Difficult to tell with out a StartTime reference as well but those are some seriously long durations. Looks to me that a LOT of SSIS jobs are running between...

Did you find anything?

This is a 2008 forum...so you should post things like this to http://www.sqlservercentral.com/Forums/Group406.aspx

When you create the table, make sure you have:

USE YOURDB

GO

Depending on how you opened the query window, by...

Thought it won't help your see local storage, If you are usintg SQL 2008...

Have you checked your SQL Logs? Have you checked the default trace file (should be in the log folder of your default SQL installation folder) to see if there's...