select 'revoke select, update, delete, insert on ' + name + ' from user_defined_role ' from sysobjects where xtype = 'U'

It will generate statements to all your user tables and...

revoke select, update, delete, insert on yourtable from user_defined_role

I am wondering the unattended SQLCLI.iss installation doesn't install the MDAC 2.6 component. Check the setup log at c:\winnt directory.

Try to install MDAC 2.6 manually to one of th workstation...

If the refresh deesn't change the pending status and you have the opportunity to shutdown SQL Server, Go to the machine service to stop the SQL Server service and verify...

Interesting. Click refresh button to refresh the status.

From Cluster Administrator, try to initiate failure or talke offline to see whether you can change the Pending State. Are all other resources SQL Server depends online?

Never use EM to...

Try to run it. It just returns table schema but no data.

"Everything is fine apart from the fact that i get an error message

when creating a linked server from another SQL 7 cluster server to one of the

nodes in the SQL 2000...

Can you psot result of sp_columns T2?

Read this paper at http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/maintain/operate/opsguide/default.asp

Do you have enough space in the drive for your backup?

Check server application/system logs for related information during that time windows.

Control Panel --> SQL Server 2000 License

Don't forget the logins that are granted to access SQL Server from old domain.

Here is the link to change domain for clustered SQL Server instance.

http://support.microsoft.com/default.aspx?scid=kb;en-us;319016&Product=sql2k

For non-clustered installation, You need to change the service account if you run SQL Server servcies with domain...

Run sp_helpfile on your database will give you the logical file names your database have.

Following Gary's suggestion to restore the database.