I tried executing the script from the command line utility and it works well:-)

I have a question about import and export wizard.Does it copies all the objects in the...

Ken Simmons-546488 (5/5/2009)

---

You can't directly restore a 2008 database to 2005, but you can use the generate scripts wizard to restore a 2008 database on 2005. Here is an...

The above error unfortunately does not give too much information.Can you please elaborate a little.I hope that the server name entered in the connection string is valid.

http://www.microsoft.com/downloads/details.aspx?FamilyId=D9CB21FE-32E9-4D34-A381-6F9231D84F1E&displaylang=en#filelist

Try if you find something.I always swap between the two drivers (MSDAORA and ORAOledb)and one of them always helped me in many cases:-)

I often run into issues with linked servers.Sometimes a new error appears before me even when the query looks fine.Here are a few things I try before blaming my query:

1)...

Looks like a familiar one.One of the reasons can be that this backup was taken from a higher version and it can be restored to a version equal or greater...

How about copying the data first from 2008 version to 2005 version and then to 2000 version?

In your case re-installing the sql server tool componenets should help.It will ahrdly take an hour

Jportelas (1/21/2009)

---

Hi there:

I have the same problem, I see the "there was a problem retrieving...

It can be fixed by re-registering a dll file

From the command prompt please navigate to:

C:\Program Files\Common Files\System\Ole DB folder

then type:- regsvr32.dll

You will receive a message that the dll has been...