why not just use BCP to import the data?

You might also want to check out this app I wrote on codeplex.  it's a console app that will script out the entire db, separate file for each object.

http://www.codeplex.com/scriptdb

so, Jeff, you are still on 2000 - were you aware that the 2008 CTP is out already?

Perhaps you'll end up skipping 2005 altogether!

https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5395

if you have databases you need to migrate, you might want to check out the upgrade advisor - it's on the 2005 installation CD I believe.

also it's here: http://www.microsoft.com/downloads/details.aspx?FamilyID=1470e86b-7e05-4322-a677-95ab44f12d75&displaylang=en

I think what is meant by "T-SQL is declarative" is that in most cases, all you specify is what you want, and the optimizer will figure out, via cost-based algorithms, the...

your problem is that you are overloading one column to mean different things depending on the value in another column.  this is a bad design. 

the easiest way to output structured XML in 2005 is the FOR XML PATH syntax.  have a look at that in BOL.

how do you determine which procs are "select" procs?  if they are named in a certain way you could do this:

select 'GRANT EXEC ON ' + quotename(name) + ' TO...

see this thread:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=301624

what's the DDL you are issuing to create the login? 

what does your connection string look like?

exec sp_spaceused MyTable

yes, it's possible to have both sets of tools installed on the same client.

note that you can use SSMS to manage both 2000 and 2005 servers, so no reason not to upgrade your client tools Jeff.

here's...

for detail on each database, you might want to check out SqlSpec, a shareware app I wrote.  It's at the link in my sig.