Using INTO in a simple or bulk logged recovery model uses minimal logging, so depending on how much data your moving you shouldnt see that much of a transaction log...

The only way to bring the Execute Procedure screen back up is to right click the procedure and select the execute option.

Or as I have said above, you know what...

If you know what data you want to insert via the proc, just call the proc using the exec / execute clause

EXEC [IT].[Insert WorkRequest proc] @.... = '' ,...

Left 4 Dead

THis...

This will help as a starting point on SSRS Expressions -http://msdn.microsoft.com/en-us/library/ms157328.aspx

Managing Transaction Logs - http://www.sqlservercentral.com/articles/Administration/64582/

Why is my transaction Log full - http://www.sqlservercentral.com/articles/Transaction+Logs/72488/

Stairway to Transaction Log management - http://www.sqlservercentral.com/stairway/73776/

Recovery Models - http://msdn.microsoft.com/en-us/library/ms189275.aspx

Accidental DBA Guide - Chapter 8 - http://www.sqlservercentral.com/articles/books/76296/

SQL Server Backup...

You need to define what consitutes your base anchor and ensure that it has a full hierarchy tree underneath it, now Svr1 doesnt have a hierarchy link to Srv4 so...

CAKE!!!!!!!!!!!!!!

Then as you are doing regular maintenance 8 will probably be the better option.

If you read just on to the next paragraph it details what MAXDOP to use for upgrades,...

Transaction log's active portition of the log moved to an earlier point in the file, allowing to shrink more

Took a transaction log backup then shrank the file

Switched recovery to simple,...

Shrinking data files causes fragmentation in your indexes, so I would strongly recommend you go and check for index fragmentation.

If a database has grown to a size it is usually...

What version of AX are you running 2009? 2012? Have you recently done an upgrade? Do you run AX batch processing or any types of AX or database...

You cannot shrink past the marked active portion of the log.

If the portion of the log was released and another earlier portion of the log marked as active then you...

First off your selecting the whole of the table as your base point, so there should be a where clause in the CTE before the union WHERE PubSrv = 'Svr1'.

Then...