just do a select from syscomments table to know which procedures use them and then replace those with the new email address. Also check the sysjobsteps table to find if...

You will not able able to generate scripts to insert or update data into your database with the Generate Script available with SQL Server. You will need to write out...

Yes you can't use triggers with system tables in 2000 only way is to use alerts but i have seen most times that does not work for some reason. If...

Check what is the recovery model of the databases. Also it wil be great if yo post the error message that youget.

Do you have any computed columns in the database. This kind of error occurs if there is one so and if you use maint plan for reindexing.

You can't place the dll's in any user folders they ust reside in SQL defined folder to take effect. read about creating extended procedure' in sql server.

Is the reporting services correctly configured. 404 indicates no page in IIS. check if the reports and reportserver virtual directory exist in your IIS where report server is installed.

You give modify privilege to the service account on the folder that traces yo activites. That should allow you to rename a given file.

There should be some tool to do the migration. Check in quest.com they have plenty of tools one might help you incase.

Post the error message please. But how did you have 2000 and 2005 as default instance which is not possible you should have 2000 as default and then 2 named...

he says that for an named instance in his server that he is able to connect using servername\instancenameXXXX where XXXX can be any alphanumeric characters. I tired to replicate the...

Then try to index your database in hours that you have little production overhead andyways you have to go ahead and do that someday may be a week end should...

Are you sure that the other databases tlog backup will complete within 30 secs else you will have the problem accompanying right.

You can truncate the log in the production server and take the backup and restore it but remember that truncte the log you will not be able to recover if...

I don't think so that there are any documented or undocumented procedures that can be used to read log files. The onl command that comes to my mind about reading...