Check if the file location path is right. it lloks like the ndf file is missing. OS error 32 corresponds to file not found error.

YOu try reinstalling the MDAC component and then try you should be seeing all the drivers for linked servers with the MDAC version newly installed.

From the client machine run prompt type cliconfg.exe and then follow what you did for the server config.

You can check the consistency of the backup using the restore verifyonly command to see if there is any backup file corruption.

Is the database being heavily used. Also you can check the properties of the database to see is they space is being reserved or is free if free then you...

This should be a problem with the client tools installation. also check for the registry permissions in the client machine.

You cant change the collation of the server once installed. you need to reinstall with new collation.

Since you saY THAT there are lot of databases. check if they are being heavily used. also chjeck for the RAM and other hardware performances.

I am not clear with the question as it raises doubt for me. You are asking a 2000 question in 2005 forums if i am not wrong.

you have the option...

did it go to the in recovery state after a service restart if so then your database is in recovery statte and ytou have to wait until it completes. this...

write a TSQL code to accomplish the job failure details your disk space and tlog space. Then i would suggest as given below.

1. create a .cmd file

2. place the cod...

Also if your LS is used in DR planning see to that its able to handle the load until you get back the primary server back.

Are you using MSDE if so have you changed your authentication mode from windows to mixed in SQL Server. Because by default its windows in MSDE 2000. Also if tis...

You can read the article ISOLATION LEVEL articles in the link given below

http://www.sql-articles.com/

If you want to send mails prefer using OLE procedures than using SQL MAIL. the script is available in this site.