Do you want to configure once and then distribute ?

The Client Network configuration is in the registry at

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo

"on 2K boxes" on SQL Server 2000 ?

"I'm referring mainly to best practices on straight import/exports over the wire, but I'd also like some on migrations."

For export/import (DTS ?), an...

"Well, the solution is pretty straightforward - You can't do it."

SP should be used to interface with the client.

If you architect where sp are input-output modules and have sp calling...

David Jackson posted a URL regarding the inconsistent actions by SQL Server for errors.

From the Microsoft site: "In some situations, error handling in a Transact-SQL batch or a stored procedure...

"could you expound on the tempdb bug please"

When you change the file growth value for the tempdb database file to a percentage, the file growth is in KB not...

Why do you think that changing the filegrowth specification requires the database to be in single user mode ?

Single user mode is only required when changing the collation.

P.S.

Do not change...

"Is there a way I can get the instance up long enough to add the account back? "

No

If you can easily reproduce the logins and can reattached the user databases,...

For this type of problem, the solution requires a table of numbers from zero to some large value. See

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-numbers-table.html

create table Events

(EventTsdatetimenot null

, EventMeasureintnot null

, constraint Events_P primary key...

An additional possibilites is to make the owner of the table the database user associated with the application login. See sp_changeobjectowner for how to change the owner of an...

The where clause includes "AND sysu.issqlrole = 1" , which means only to include roles but, by convention, roles will have a uid of greater than 16384, so when both...

A few questions:

"The DTS package executes when run adhoc but the DTS job fails."

When you run the DTS package adhoc (outside of a job), are you logged into...

Some components to check:

Local and Global Security Policies (lock pages in memory, etc).

Local windows accounts.

Local windows security groups and group membership.

Windows Services with start-up type and security.

Directory structures, shares and...

Be carefull when using the sysinternals handle executable as part of a SQL Server Job. For more details see:

http://forum.sysinternals.com/forum_posts.asp?TID=9912&KW=sql+server&PID=43231#43231

Formum post but noone has replied:

SQL Server 2000 has an Agent...

"I personally don't see a need for it either. However, the windows OS server team is pushing for it. I guess it can make their life easier. ...

See Erland Sommarskog's article on this subject at

http://www.sommarskog.se/arrays-in-sql.html