Am confused. Are ANY of these tips supposed to work with version 7.00?

I sure cant make them happen.

set current schema information_schema;select * from tables

Doesnt seem to work in MSsql SVR 7 either...

But Im a newbie :\)

Is support for multiple instances of same-named object a technical requirement for a contemporary DB - Yes

Do most implementations need it - No.

To borrow from a different debate on security...

Got this is SQLSVR 7 DTS jobs after our netadmin applied a W2K security patch to the server. Had to re-apply current SQLSVR SP to resolve.

After all else has failed and the status is still "loading" would it make sense to create and tune sp_resetstatus?

We started getting AV ERROR IN SQL SVR 7 using DTS. Our net admin had applied a security patch to w2k, It was fixed by applying SP3 to sqlsvr7.