You can use SSIS to easily export to XML...

If that won't help, try using Import / Export Wizard in SSMS

No you cannot

Thanks for your reply!

I need to generate the xml file once or twice a day. I prefer to try using C# to do this task.

Can you please guide me...

Yes I know what you mean 🙂 but you can always post a question on this site if you have some doubt 🙂 ... in the end i proceed as...

I started my first job ever as a BI developer..We use SQL Server 2005 and Business objects and I am also a 1 man team 🙂 But i tell you...

🙂 very good one indeed!!

From Sql Server, use the Import export wizard to accomplish that in the easiest way...

Thanks a lot Gila,,,Sounds like a pretty good strategy to me...

Do you have any suggestions how to achieve the result? how to reformat the year 0121 ?

I cannot do this as i must use the date in question for querying in reports etc

I bet that answers your question 😎

Have you tried analysing the Query in Database Engine Tuning Advisor?

You might consider switching the database to simple recovery model if possible.....

Make sure to enter the path correctly and avoiding any spaces. if necessary rename the mdf file

Thank You and I thin k your reply would do it 🙂