I can't thank you enough!!! You saved our production run from being late! I ran this on SQL Server 7 sp 4 and it worked like a charm.

...

Thanks, Steve! Your suggestion is less kludgy than what I'm doing now. I'm scripting the database, re-engineering it in ERwin, comparing to the data model in ERwin, generating...

Thanks, but that would mean that I'd have to change to mixed mode. For security reasons, our company standards require that we use Windows authentication.

What other data modeling tools...

Please see the following Microsoft article:

http://support.microsoft.com/?kbid=318819

This article describes DTS packages that, when run as an Agent job, fail or stop responding when using DLLs or third party drivers...