UPDATE updatetble1 SET updatecol1 = sourcecol2 FROM updatetble1  JOIN sourcetbl2 ON updatetble1.rowid = sourcetbl2.rowid

Set based operations, from my experience, are always much more efficient than row based operations using loops of any kind.  I would recommend not using cursors period.  Any other row...

I've done it both ways, adding a prefix/suffix in the DB name and using passwords.  I prefer using passwords because of what Jo P. points out.  He also makes another great...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=250647

You may try the 'Execute Process' task in DTS.  This should allow you to call a .bat file.

'...how do i use a wildcard for a column in another table'

I assume that you are trying to compare AgsSite.Descriptor values to the values in tblScootlist.strMajorRoad?  If this is...

I have seen application that use ODBC gather the username/password during runtime and pass them into the connect string along with the DSN. 

You may want to explore using the...

If you are using the standard ODBC driver for SQL Server, SQLSRV32.DLL, it does not save the password within the DSN.  Even if you go into your DSN from the...

See osql in BOL:

If neither the -U or -P options are used, SQL Server 2000 attempts to connect using Windows Authentication Mode. Authentication is based on the Microsoft Windows...

Add the -E switch to your osql command.  Does this help?

Please disregard my question.......Windows XP sp2 firewall was blocking the necessary ports.

Can you give an example of how one of your fields would appear with the tags?

select origfillfactor from sysindexes where name = INDEXNAME

This should grab the first row it runs accross based on the EmpID:

INSERT INTO EmployeeTable (Columns) SELECT Top 1 FROM StagingDatabase..StagingTable WHERE .......

Is that all of the tables in the database?  If so and depending on how much data is in each table, you may consider rebuilding your database from scratch.  Do...