Set up a text file called "Test.SQL".  Paste your SQL syntax into that file.

Set up another text file called "Test.cmd"

Place an osql call inside "Test.cmd"...here is what the OSQL might...

Here is what I did a month ago when we swapped out boxes...

Set up new box using <oldservername>2 (we are going to name the new box the same as the...

Create Table 2 ran successfully for me.

I humbly ask you reconsider...

I ended up shrinking the transaction log for this database in order to force the transaction log to fill up entirely (as suggested by Steve Jones).

Once the transaction log was...

WITH TRUNCATEONLY...

I ran the following...

DBCC SHRINKFILE (RECOMMEND_Log2, EMPTYFILE )

ALTER DATABASE RECOMMEND REMOVE FILE RECOMMEND_Log2

GO

SQL Server returns the following...

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Server: Msg...