Typically the drivers for SQL 2000 are on each Windows PC. The control panel has data sources and ODBC and OLEDB drivers should work for you. You should not need...

That's an OS error indicating that it cannot get to the path, or it does not have permission to access the file.

Is that a path that is local to the...

What error are you having with ODBC?

Bru's method will allow you to change the authentication method. Be sure that you set a strong SA password if you enable SQL authentication...

As Bru mentioned, you should not have any tables in master. If you need to store data for your application, create a new database and store things there. Do not...

What I'd suggest is that you first check to see if you have Windows Event Log monitoring. Sysadmins often have this set up and many of the SQL errors are...

I thought that GRANT EXECUTE would give you permissions to all stored procs under a particular schema, but I'm not sure about insert and update.

If you want rights to all...

no turkey here, after a day of skiing we ended up with Wendy's for dinner before everything closed 😛

This should work. I was thinking that I couldn't put a database back in standby, but you can with the BACKUP command.

If you ensure that you are not getting...

The log formats are different, and can't restore between each other. I think that if you had a database in 56 mode that you could log ship between two versions...

Thanks for all the kind words. It really feels like a community on days like this.

I'll move to the SSIS forum.

Note that you might want to still pick up a beginner's C# book. The concepts of the language will help you debug packages. You...

If you look under the scripts section of this site, there are lots of Index Management scripts you can use.

I'll add one more question. How long did you notice that the SPID was executing?

How will you set the primary to restoring? you can't back up the tail log, set the database to restoring, and then restore a log from the secondary. You will...

There is a runtime for DTS packages in 2005/2008 that will allow you to run your old packages