You don’t have this option in SQL 7.0. However if your OS is 2K then you can use AWE option on OS to leave SQL Server more memory.

Hi Joe, I sent my resume to you with my contact details. Feel free to call my cell number if you would like to talk to me more

Thanks

P Vaddi

The process running may need a lock to complete the transaction. If you are experience the deadlock or blocking you need to change the coding part of the program or...

Check the startup account has enough privileges or change the account with known id. If it doesn’t work try to start with the single user mode from the command prompt

...

Take the backup on SQL 7.0 and restore it on SQL 2000. Make sure the drive letters matching. Depending on how the webapps connecting your server either by the server...

You don’t need to check the errors explicitly. There is an option in the Database Maintenance plan, “Perform these checks before doing the backup”, if you select this option it...

I did see errors like this in 7.0. Most of the times by switching your client protocol from named piped to TCP/IP should correct this

You can't rename the Instance. You must uninstall and re-install

CROSS POST

So far I worked in Telecommunication, Retail/Wholesale Energy and Gas and Call center. I don’t have any problem switching between the different environments. The only thing is we must remember...

If your current prod server is clustered, it is good to move to 2000. Also if the users doing any bulk insert operations, you must make them as DBO/DDL Admins/Sysadmins...

SQL Server does not offer a decrypt function, You can only use PWDCOMPARE to compare a plaintext password to an encrypted value

Your master database creation date is your SQL server installation date

You cannot restore a database if there is any active connection to the database.

I would guess you have only the system databases (master, model, tempdb, msdb) also you may have configured to hide the sys databases. So it cant show any of the...