Thanks for the quick reply, I will give your suggestion a try and let you know.

I have tried as best I can to provide everything that is in the Loop. If you need anything else, let me know.

Data Flow task –

Ole db source

Recordset...

We have two types of backups. 1) database, 2) server.

The database backup which what you described where it is backed up to a local drive. We then...

I will test this so we can use it in the future. I believe we have some production servers that don't have our data files where we would like...

But what about the error that comes up when the patch or hot fix is installed and can't find the resource or the distmdl files? This would not be...

As a resolution to this issue we uninstalled and reinstalled MSSQL 2005, placing the default datafiles in the directory we desired, since there seemed to be no real solution for...

Hi,

I was able to use the link to move the resource database and all of the other system databases except the distmdl. I believe the to delete, recreate and...

While it is true that SQL Server 2000 does not use the SQLAgentCmdExec account, we as a company still use the concept. Meaning that we create our own SQLAgentCmdExec...

I have experienced this is the past: resolution - check your password or the user name for their access. Also, check the error message and research the error #...