Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
SQL Server

Home >Search > Knowledge Base > SQL Server > Import & Export

What's New - What's Hot
How to move databases between computers that are running SQL Server     
Total Hits: 334  |  Today: 0Author: Microsoft      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article describes how to move Microsoft SQL Server user databases and most common SQL Server components between computers that are running SQL Server. The steps described in this article assume that you will not move the master, model, tempdb, or msdb system databases. The steps provide different options for you to transfer logins and the most common components that are contained in the master and msdb databases. For information about the specific items not transferred when you...

FIX: DMO BulkCopy Fails to Copy Data When Column Names Contain the Space Character     
Total Hits: 798  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Using the SQL Distributed Management Objects (DMO) BulkCopy object to
import data into a SQL Server table that contains a column with a space embedded in the column name may fail with no rows copied.


HOW TO: Import XML into SQL Server with the XML Bulk Load Component     
Total Hits: 6054  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Data that is expressed in XML can be loaded into a SQL Server 2000 database by using the XML Bulk Load component. This article outlines the steps that you need to follow to load XML data into a table that already exists in the database....

Disclaimer - Privacy
© 2002-2017