.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

what the best way to create thousands of XML files using SQL 2008

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

We have to create thousands of XML files and the data for these XML files will come from SQL server 2008.
what is the best and easiest way to creat XML file using SQL Server 2008.?
should i use use sp_makewebtask stored procedure? is that available in SQL 2008 and SQLExpress 2008 ?
Shold i use OpenXML? How?
we are also using Entity Framerwork, so we have domain model available in Code. Should i use code and Entity Model to create XML instead of SQL  directly?

out of these three approches which one should i use?

View Complete Post

More Related Resource Links

How to create a SSIS package to import records form SQl Server 2008 tables to text files

I am a newbie to SSIS and would like to create a package to accomplish the task referenced in the above title. Will appreciate any links and pointers in the right direction.   Thanksakoranteng

Create WAP in VS 2008


Hi all, i plan to create a WAP site with VS 2008 by New 1 normal web application project, ist doable?

are the things i should take care about is:

- make sure the header of html is xhtml?

- no using session to pass info?


Besides, is all the C# code like that call database will work like normal asp.net?



how to upload files (5MB-50MB) into sql server 2008 by using filestream

Hi!i have some files, and i need to upload these files into sql server 2008 by using filestream.lets take table name as custfiles,              columns are fileid,filename,filepath,filesize.1.how to create table using filestream?2.how to insert file (record) into table from .net environment?3.how to retrive that file from .net environment?please provide related code....THANS FOR ANY HELP

Can't Create ODBC to Local SQL Server Express 2008

Hello. I have SQL Server Express 2008 SP1 LOCALLY on my Windows XP Professional SP3 box. I have databases already created in Access 2007 that I imported into SQL. Now I want to keep the front end Access forms for data entry but have them connect to the databases in SQL. What I can't seem to do is connect from Access to the SQL db's because I can't create the ODBC connection. When I try to connect, I get the following two 'Connection failed' errors: 1. SQLState: '08001' SQL Server Error: 10061 [Microsoft][SQL Server Native Client 10.0]TCP Provider: No connection could be made because the target machine actively refused it. 2. SQLState: 'HYT00' SQL Server Error: 0 [Microsoft][SQL Server Native Client 10.0]Login timeout expired Additionally, this information may help. 1. Windows firewall is turned off. 2. In SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for SQLEXPRESS, Shared Memory, Named Pipes and TCP/IP are all 'Enabled'. The order is Shared Memory (1), Named Pipes (2) and TCP/IP (3). 3. In SQL Server Configuration Manager > SQL Native Client 10.0 Configuration > Client Protocols, the above three are also 'Enabled'. The order is Shared Memory (1), Named Pipes (2) and TCP/IP (3). Double-clicking TCP/IP tells me that the default port is 1433. 4. Running "netstat -ano", I see no entries for [myIPaddress]:1433.

How to create a "search function" to find files and folders using C++ windows forms?

As mentioned above, how can I make a windows forms application that searches for files and folders specified by the user and display results in a ListBox? Thanks in advance another question: How can I make a textbox transparent? I would be really grateful if anybody told me what books are good to learn windows forms using C++? thanks again

Cannot create maintenance plan in SQL 2008 SP1

I receive the following error trying to create a maintenance plan in SQL 2008 SP1 on a Windows 2008/R2 server: The action you attempted to perform on a remote instance of SQL Server has failed because the action requires a SQL Server component that is not installed on the remote computer. To proceed, install Microsoft SQL Server Management Tools on the remote computer, and then try again. The components that installed are Database Engine Services, Reporting Services, Client Tools Connectivity, Management Tools Basic/Complete, and SQL Client Connectivity SDK.  I have another independent SQL 2008 SP1 server running on the same platform with the same features installed and I have no problem creating maintenance plans there.  However, it does have IIS as it was upgraded from a SQL 2005 server which required IIS for reporting services while SQL 2008 does not. I'm familiar with http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/06c80a78-a877-4a48-a032-b0aef78a598c but that doesn't seem to apply as this was a new SQL 2008 installation on a freshly installed OS.  I've seen several other postings of this on the web but they all appear specific to SQL 2005. What else could be missing? Thanks.

Unable to create Web Folders in Windows Server 2008 R2

Hi, We are unable to create web folder from a Windows Server 2008 R2 system as we do in Windows XP. The web url cannot be identified. The web url is an oracle repository application built in 32-bit OS and now we need this to be added in Windows Server 2008 R2 machine. Kindly help.  

Cannot Create Database Diagrams - SQL Server 2008 Management Studio

I cannot create a database diagram with my client-side SQL Server Management Studio.  I can do this if I am on the actual db server itself.  Please help.

(SQL Server 2008) Exporting entire databases to SQL CREATE/INSERT statements

Hi All, I'm looking for a way to export SQL Server 2008 (Express or otherwise) databases to CREATE/INSERT statements.  I've seen a million threads (give or take) with instructions for creating large (often illegible) TSQL scripts for the task.  However, I'm hoping that this isn't the only way by which to do it.  I have need to regularly back up the data from existing MS SQL Server DBs (which are used by some of our standard apps) to various other MySQL and PostgreSQL databases (which are used by PHP and Rails web front ends).  I need to export them from MS SQL Server 2008 to a general format (i.e. INSERT statements) and perform regex edits on the file as necessary. FYI, I've written a few applications that connect to the various DBs over ODBC, etc. and transfer the data row by row.  You can image how painful this process is... I realize that there are many tools that do this.  However, most of them approach the issue from the standpoint of migration, and not that of regularly scheduled backups.  Also, this tool will need to eventually be distributed so having to purchase a license for the migration app for each person/group simply isn't feasible. Anyway, if you guys have a quality, straightforward solution to this issue, it would certainly be appreciated. Best.

Is it possible to create WSP files within Designer 2010?

I'm just getting to grips with Designer 2010 and was wondering if I edited a CSS, Pagelayout or Masterpage (for example), how easy it would be to package them up into a WSP file? Would it be easy to export the changes within Designer into VS2010? Can you import the changes into VS2010? Or would I have to do it the hard way and copy each file and drop them into a WSP project in VS2010 and then build and deploy? Just getting my head around which would be more automated - if at all. Cheers.   Keith.

how to make working WPF 2010 program make changes to SQL Server 2008 Express files

(1) I have a working WPF 2010 program that manipulates a table in SQL Server 2008 Express (2) the program does delete, update, select and insert correctly however in its own project file folder logbooklmk.mdf   logbooklmk_log.ldf (3) I want the actual SQL Server 2008 express files to be changed yes I know the issue is sharing and the copy option only applies to the local project files. I found this out by trying always copy, never copy and copy if newer. I probably have to change the .xsd folder to refer to the actual SQL Server 2008 Express file. Tried that once and it failed. Something about sharing not allowed.

please help me to create database in sql server 2008

hi,    i am new to asp.net. i like to learn asp.net and c#. when i try to connect to sql server, it asks server name. i don't know server name and it asks database name also. how to create database and where can i access like phpmyadmin. in phpmyadmin i can create database and tables. i am new to this. please help me.thanks.  

Installing SQL Server 2008 R2 Enterprise on Windows 7 - Setup Suport Files

The problem is when i try to install a new instance of SQL Server 2008 R2 Enterprise the wizard stops working when is trying to install Setup Support Files, and nothing happens. I cannot add the entire log file of the instalation, so i leave only the last lines. : ---------------------------------------------------------------------- 2010-09-10 11:46:24 Slp: Skipping Action: FinishPage 2010-09-10 11:46:24 Slp: Action is being skipped due to the following restrictions: 2010-09-10 11:46:24 Slp: Condition "Is the user's scenario set to EditionUpgrade" did not pass as it returned false and true was expected. 2010-09-10 11:46:24 Slp: ---------------------------------------------------------------------- 2010-09-10 11:46:24 Slp: Skipping property RequireMode of class: StopAction 2010-09-10 11:46:24 Slp: Input of property will not be set due to the following failed restriction(s): 2010-09-10 11:46:24 Slp: Condition "Is the user's scenario set to ComponentUpdate" did not pass as it returned true and false was expected. Can you help me?    

Installing SQL Server 2008 R2 Standard on Windows 7 - Setup Suport Files not start

    I try the SQL 2008 R2 Standard version, and know it works, on a clean machine with Windows 7. But in another machine a user has uninstall the old version of the SQL and after the step of install the Setup Support Files nothing happens. I had copy the log files that are on C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log I think that something on the uninstall of the old verion went wrong and this version cannot be installed. Can you help me?   Summary_Component UPdate Overall summary: Final result: Passed Exit code (Decimal): 0 Exit message: Passed Start time: 2010-09-14 15:22:09 End time: 2010-09-14 15:23:33 Requested action: ComponentUpdate Machine Properties: Machine name: PC1 Machine processor count: 2 OS version: Windows 7 OS service pack: OS region: United States OS language: Português OS architecture: x64 Process architecture: 64 Bit OS clustered: No Package properties: Description: SQL Server Database Services 2008 R2 ProductName: SQL Server 2008 R2 Type: RTM Version: 10 SPLevel: 0 Installation location: E:\x64\setup\ Installation edition: STANDARD User Input Settings: ACTION: ComponentUpdate CONFIGURATIONFILE: ENU: True FARMACCOUNT: <empty> FARMADMINPORT: 0 FARMPASSWORD: ***** HELP: False IACCEPTSQLSERVERLICENSETERMS: False INDICATEPROGRESS: False PASSPHRASE: ***** PID: ***** QUIET: False QUIETSIMPLE: False UIMODE: No

How does one create context-sensitive custom help files?

We are an ISV and would like to know how to add a feature to our solution that uses the existing help functionality to display help based on the user type and context of that user type in the system.  I have been searching to no avail, if there is a How-To article somewhere I'd love a link! Thanks, -Torrance R. MillerIntegrating the future into today

How to create Range bar chart i n SSRS 2008

  Hi How to create Range bar chart i n SSRS 2008 amit
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend