Happy to help out.  Youre very welcome.

You should log into the actual server in question as SA and see whats up.  Youll be able to see everything.  Verify its healthy and has all the databases and logins necessary...

I connect to a Postgres dataabse on Linux using a System DSN ODBC Connection "Data source" and I specify the IP if the server for "Provider String" AND  and "Location".  I use an IP because...

Have you set up a linked server?

Yes, Thank You!

Heres a SP I wrote that connects to a linked server.  It may be of some use as an example.

The fully qualified connection is: StaffQueue.MDADirectory_Test.dbo.StaffQueue

---------------------------------

CREATE PROCEDURE usp_InsertIntoStaffQueue

--Declare the variables used...

This is a longshot....

When I installed SP4 I had to grants rights to the tempDB for an applicationLogin that perviously didnt need explicid rights to the tempDB.  Maybe the tempDB has...

Way cool, I knew I was just crazy!

Some apps I've worked with create views of the base table and have each user a view to that table.  The users have rights defined and only access the views, never the base...

Look up "Maintaining Hierarchies" in BOL.  Also look into "Self Join" for a parent child relationship in a single table.

Task<-->Task is refered to as a "Self Join" if you want to look into it further look into "Hierarchies" as well.

I think you should let MSSQL2K generate the create database scripts for you.  If you try to do it yourself you might miss something important.  Its possible to do what the...

How many tables?

I was thinking in terms of using DTS to transfer and manage all the files created by the scripting process.

I guess you can use DTS to create a central repository for all these scripts.  Great article, Thanks!