In SQL Server 2000, I can right-click a table name and select Copy from the pop-up menu, but I can't paste. What's the Paste command actually doing?
Follow along with this example: Open Enterprise Manager and right-click to select the authors table from the Pubs database. Select Copy, then open Query Analyzer and choose Paste from the Edit menu. You've just pasted into Query Analyzer the Data Definition Language (DDL) code that creates the authors table. The Copy command doesn't affect data; it generates a DDL script and moves the results to your Clipboard. You can then paste the DDL script into a program that accepts Query Analyzer or Notepad text from the Clipboard.