Dont know if deny would be a good idea, rather than just removing the permissions.

Andy

Especially for applications I like to test on a clean machine logged is a real user. Too many times something runs fine on a developer machine but not production, due...

My suggestion would be to migrate to SQL2K first using the compatibility mode. Then as quickly as possible work to get OUT of compatibility mode. Whether schema changes will be...

Might be a good idea to just double check the job for the snapshot too, see if it does contain that parameter.

Andy

Like anything else, .Net will require some adjustments. Here the plan will be that any server side gets done in VB.Net simply because that's what I have the most experience...

Maybe via an error?

Andy

Sp_change_users_login existed in SQL 7 as well. Its just a matter of getting the ID's to match between logins and users. Couple articles posted on the site about it (one...

I think that is true about index vs constraint. Just works out that some constraints are implemented with indexes. As far as the object browser if you happened to look...

Why would you need to drop roles and users?

Andy

I work at a small company and have domain admin rights and physical access as well. If I were to leave that might change with the next DBA - would...

Easiest way is to detach/copy/attach - basically what the copy wizard does. Attaching a 7.0 mdf to SQL2K automatically upgrades the data structures.

Andy

Just use executeimmediate and pass the spid.

Andy

I dont think so, but honestly have not really tried. Sounds like fun!

Andy

From BOL, this about the key object:

SQL Server tables can contain key constraints. The constraints apply declarative referential integrity to the data contained in the table. Keys can be primary...

The server object has an enumprocesses method that returns a queryresult. Probably easier to just query sysprocesses directly via ADO then issue kill for anything still connected.

Andy