CCM

SQL Server diagram export: to another database

SQL Servers allow the import or export of database diagrams to another database. All the information related to a database is stored in the dtproperties table. Therefore, to import or export a ...
Ars Technica

Using non-printable char in MSSQL bulk import format file as delimiter

I've received a new file to import in our database and the *censored* DBA are the other end got creative with the format. he decided to use 0x01 as field delimiters and 0x02,0x0a,0x10 as record ...
CIOL

How to import XML files to SQL Server?

SUNNYVALE, USA: Novixys Software, Inc. has released Exult for SQL Server v. 1.1, an easy to use Windows application that helps database administrators to import XML files into a Microsoft SQL Server ...
Ars Technica

Export user information from SQL Server for import into Active Directory.

The scenario is as follows. We have data inside of SQL. Mainly phone numbers. What we'd like to do is to export these and import them into Active Directory. The information in SQL will have email ...