Tip: Copying Objects from Enterprise Manager to Query Analyzer

Did you know that you can copy many T-SQL object definitions from Enterprise Manager onto the Windows Clipboard, then paste them into a text-aware utility such as Query Analyzer or Notepad? This copy-and-paste method is a convenient way to script multiple objects from Enterprise Manager, using as few keystrokes as possible. Try this experiment: Expand the Pubs database hierarchy in Enterprise Manager until you see the list of table objects in the right pane. Right-click one of the tables, such as discounts, and select the Copy menu option. Then, open Query Analyzer (or any text program such as Notepad) and paste the table object.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.