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 ...
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.
SQL Server 2008 R2, which ships this month, allows end users to tap into the powerful business intelligence features of SQL Server via tight integration with popular Microsoft applications like Excel.