http://support.microsoft.com/kb/303257

check if the above kb article applies to your scenario.

A simple and more precise document on database nmirroring. I have read the white paper in microsoft foe the same. Appulads to Dave he has brought the more than that...

Regarding the user id/password part, if you rebuilt the server all logins will get dropped and recreated. Hence you will be losing the same. You have to recreate the user...

If you detach, reinstall and then reattach, then the database will retain the collation. I meant that you can create a database with a new collation other than the default...

I currently don't have one. But sure that this can be written and used in huge environments.

Did you run the consistency checker on the database and see if there is any errors that it resulted. your error is an outpt of CRC and this would be...

Remove your update stats and try only with the update statement.

You have microsoft BPA(Best Practices Analyzer) released for monitoring the seucrity related issues.

With SQL 2005 the registry path has changed. There in no path MSSQLServer and all details pertaining to the server and instance are located in Microsoft SQL Server itself and...

Did you try including a log file to track what is happening when the job executes. That will give you a clue where the problem lies. Include the log file...

Maximum size allowed in a row in a table is 8060 bytes exceedin this you will get a warning as what you have said. Yu can turn off this warning...

use sp_who2 active to find out the runnable transactions. else sp_who2 will give you a list of all transactions.

It can be handled this way. Write a DOS program to do the following

1. use OSQL -L to list the servers/machines running sql server and move the list to a...

Robert is right. ISQL is a 2000 utility hence use SQLCMD to export the data. Also you can use the GUI based import/export wizard to move your data to your...

Might be because when a server runs 2 instances of sql server the default instance uses the default port and named instance uses a dynamic port. Try to specify a...