Your options are dackup file or tape, copy the physical files themselves and use sp_attach_db on the other server, or Export to other server (which takes longer). Suggestion is if...

Not yet, but I'll keep looking.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Just to give proper respect. I had to dig a bit on the web and this was the answer found at http://www.cryer.co.uk/brian/sqlserver/sqlsvrtroubleshooting.htm which may have come from another source but...

That's what I thought, problem is I find nothing else about it when I search the web. The only way to know for sure is rerun the items that were...

Since it is barking specifically about the error log then the path defined in SQLAgents properties might be wrong. This generally happens if the database has been moved since it...

Is this a new install or fairly old. Also does it use System Account for startup or a specified user account and password. If the later could someone have inadvertently...

Did you check the logs both SQL and Event Viewer in NT/2000 to see if any more details are available. I have gotten odd fatal errors in the past (mostly...

Check this article, I feel is probably your issue.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q217395

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Ok I posted an old code template I created to do exactly this, you will need to change some items to match with what they and it is building dynamically...

Alter the function to return 1 either way to see what happens. If still fails then remove the input and return 1 only. Backtrack thru it until it works to...

But I actually wonder what will happen with 7 to 2000 even though 7 has the same type option.

"Don't roll your eyes at me. I will tape them in place."...

Be carefull when you post, duplicate occurred.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Try ISNULL(mi,'') instead of just mi. This checks for NULL as the value and replaces with '' string.

"Don't roll your eyes at me. I will tape them in place." (Teacher...

Ok let's turn on the package logging or specify and Error File (which is close to the same) output for the DTS package to see if they will hint to...

I have not tried this as of yet but have run accross several statements from Microsoft to only replicate 7 to 7 and 2000 to 2000 but no details on...