The source code is attached to the article as a zip file now.

It's not corrupt. Likely you have permissions that are conflicting, and there are DENYs that override the GRANTs.

Make a new login, give it permissions to a specific object, INSERT to...

Jeff,

I'm not sure what my passion is. It's a question I ask myself constantly, but so far nothing has struck me.

About 8 or 9 years ago my wife and I...

I've warned my wife a few times that a full time horse job may not be as much fun as it is now. She's keeping it in mind, and making...

With SQL Authentication, you now must add a "login" to the server and a "user" to the database you are accessing. go to the security folder under your server (databases,...

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.