Problems with Export Data Wizard

[rf222]

I can not export the data. The wizard stops during execution of "Opening XML file...". After applying SP 1, it does not allow me to even execute the Export Data Wizard...

Why is this new SQL Server 2005 so buggy? It used to work fine in SQL 2000.

 

[mrdenny]

What are you trying to export.

What SP1 did you apply? If you applied the SQL 2005 SP1 CTP, that's a beta and is known to have bugs (which is why it's still in meta).

How are you trying to export it?

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[rf222]

I do not think it is CTP version, I just downloaded it from MS site two days ago. It says updated 3/17/06. How can I tell?

I right click database and select Tools/Export Data.

 

[mrdenny]

According to Microsoft's site the CTP was just updated today.

http://www.microsoft.com/downloads/...DD-DA9B-4AD0-9A8A-F193AE8410AD&displaylang=en

This means that you've got a CTP installed. Hence the bugs.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[rf222]

Thanks a lot, however I was reffering to regular SQL 2005 SP1, not SQL 2005 Express SP1. I will download this one anyway, since I also want to have SQL Express 2005 on my machine.

 

[rf222]

It says "Date Published: 3/20/2006". Seems it is the same wha I have. How can I tell the difference?

 

[mrdenny]

My bad. Here's the non-express one

http://www.microsoft.com/downloads/...74-1C29-49FE-8221-C94F2B52F6C6&displaylang=en

It's also still CTP. They will go TRM on the same day (or at least they should).

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com