Wednesday, April 20, 2005

Extending Office 2003 with SQL Server

Extending Office 2003 for Enterprise Reporting and Analysis Extended Microsoft Office Excel 2003 functionality and use Web services to access discrete backend SQL Server databases.

SQL Server Express Utility SSEUtil is a tool that lets you easily interact with SQL Server:

• Connect to the main instance or user-instance of SQL Server.
• Attach, detach, and list the databases on the server.
• Upgrade database files to match the version of the server.
• Execute SQL statements via the console (similar to SQLCMD).
• Retrieve the version of SQL Server running.
• Enable and disable trace flags (for example, to trace SQL statements sent to the server by any client application)
• List the instances of SQL Server on the local machine or on remote machines.
• Checkpoint and shrink a database
• Measure the performance of executing specific queries.• Create and playback lists of SQL commands for the server to execute.
• Log all input and output.

No comments: