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 ...

The importance of automating processes can’t be overestimated. Most things start out as a manual procedure until you work out exactly how things should happen, but many times they stay that way ...

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 ...

4. Perform more functional and scalable data transfers with the improved SQL Server Import and Export Wizard. Scalability features to support large numbers of tables and customizable data type ...

Is there a way to have the results of a stored proc get put into an Excel spreadsheet within the proc? <BR><BR>This is on SQL Server 2005.