As a thumb rule , on a dedicated SQL server we allocate 75% of the total memory to SQL and the rest 25% would be taken by the OS.

Try connecting by specifying the port no of the named instance

e.g. gpdev-01\test1,<port no>

Have you renamed any of the referenced databases ?

You can script the job and check all the databases references to see if everything is ok.

what type of authentication are you using on the server, please check the authentication type when you are connecting to sql server from the application

can you let us know what errors are you getting when you turn the database mail on?

After much digging in found that sql server 2000 MSDE does not support hotfix 2175

The t-log size would definitely increase after the reindex operation and you have rightly mentioned that you can change the recovery model to bulk logged before the reindex operation and...

The thing is that i have to give some approx amount of free disk space to my storage guy, currently i have 30gb free space on the log drive, i...

Follow the below steps

1) go to the enterprise manager and right click the properties of the sql server

2) add -T3608 in the startup parameters , stop sql server and then...