After playing with it further, I discovered that, although I still can't get it to work, the code will execute error-free if I enclose everything in that weird little single...

Please pardon my ignorance, but how do you create an "alias for the instance?"

Thanks,

Kip

TRUNCATE TABLE [AHL_SQL7\WORKSPACE].MarketingCF.dbo.Mthly_LIF

GO

Server: Msg 117, Level 15, State 1, Line 1

The object name 'AHL_SQL7\WORKSPACE.MarketingCF.dbo.' contains more than the maximum number of prefixes. The maximum is 2.

Suggestions?