Friday, March 24, 2006

SQL 2005 Standard edition

As you can read in my previous post I went to the launch Event of VS 2005.
At this event we got some free products and among them was a license of SQL Server 2005 Standard edition.
Now, lately I was playing around a bit with dotnetnuke. Building custom modules and stuff. Great thing to play with btw.
And at one point I needed to export a table to a text file to be able to generate reference data for the deployment package of my first custom module.
So I fire up the export data task in SQL Server and it starts asking me a bunch of questions, such as source, target, delimiter, ect...
After all steps are completed I hit the execute button.
And BANG, error. It seems that my product version is insufficient to perform the task. wft?
You can't do exports to flat file from SQL Server 2005 Standard edition?
Ok I get that the standard edition is not the most complete of them all, but a simple export to a text file? I have to be missing something here....