I use Query Analyser(Extensively), EM(Extensively), Performance Monitor, DBArtisan (Extensively) and ERwin.

Murali.

You can take the Backup of the Database and RESTORE onto the new server as well....

Murali.

Exactly... CHECKDB should be able to fix minor errors....

Patrick,

I have sent the file.

Regards,

Murali.

Patrick,

I have downloaded this file. But when I tried to open this file, its asking for a password. Do you still want to receive this in the email?!

Regards,

Murali.

Balbir,

You might also want to check the status of the job, of its sleeping or runnable. Otherwise you might endup killing a job, which is running for long time.

Are you...

sp_addalias will perfectly suit your requirement. I am managing all my DEV Servers with this for a long time without any issues. In DEV all the developers will be aliased...

Bill,

You can try outputting to a text file from the JOB. That might give more info.

Hope this Helps!!!

Thank You.

You might want to check the Client Configuration tools in SQL Server Folder.

Hope this Helps!!!!

Regards,

Murali Damera.

DBCC DBREINDEX is for a single table in any database.

But where as SQLMAINT.exe is used to indexing the same for all the tables in a given database.

Regards,

Murali Daemra.

I am also having problems that backups running longer on one of my server (SQL 6.5), whch has 2 processors. Could you please let me know how to add more...

Hi,

We had issues installing this remotely. We have logged in onto the server locally thru SMS, then we have installed the SP. Remember to check whether your ID (used to...

You would need to Shutdown the SQL Server, Agent and DTC. Also use srvmgr \\servername from command prompt, to check if any is using any files from this server.

Hope this...