If you see available memory consistantly around 5MB and only 700MB be used of 1GB, Go contact your hardware vendor to see any diagnosis tools to help you.

Try sp_attach_db to attach the databases back after SQL Server reinstalled. I may not work if databases were not properly shutted down.

Transform your script2 into a stored procedure and execute it from script1.

SQL Server errorlogs have TCP port number used by SQL Server in folder \mssql\log

Unfortunately, You can't.

It seems you are right the account exclusivly used to start SQL Server doesn't have to be in SQL Server login. If you remove/deny 'BUILTIN\Administrators' from SQL Server login, full-text...

quote:

---

However, only 5M of RAM is still available.

---

Can you explain more why do you...

Which authentication method Did you register your SQL Server in EM? Try login QA with SQL Server Authentication.

Performance monitor --> process counters.

Possible. Any other applications also run in the same machine?

From BOL.

"Requirements for Domain User Account

All domain user accounts must have permission to:

Access and change the SQL Server directory (\Program Files\Microsoft SQL Server\Mssql).

Access and change the .mdf, .ndf, and...

Agreed with Michelle. You may double check the security tab in server property to make sure both Windows and SQL Serevr option be choosed.

Any error messages in your SQL Server...

Firstly, Have you run dbcc dbreindex and statistics update to your new database?

Waht is database Compatibility Level? Upgrading existing systems with existing applications at SQL Server 7.0 ompatibility level may...