By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
In Enterprise Manager, right click on the database and click on "All Tasks" then Generate SQL Script. If the "Show All" button is available click on it, then check the "Script all objects" check box. Click the "Formatting" tab and select the options that you require. Then click on the "Options" tab and check all eight checkmarks. Click "OK" and name the file.
In the SQL Server Management Studio, right click on the database. Click on "Tasks" and click "Generate Scripts." A wizard will open to walk you through the process of scripting out the database. At the end of the wizard you can save the script to a file, to the clipboard, or to a new query window.
Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning
Related Q&A from Denny Cherry
Troubleshoot long running stored procedures with SQL Server Profiler by adding events to find the command with high run time.continue reading
To avoid performance problems when running multiple instances of SQL Server 2005 with Exchange on Windows SBS, refer to these expert best practices.continue reading
Learn how to troubleshoot SQL Server 2005 temporary table performance problems when a stored procedure execution time is slower than usual.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.