Skip to: Site menu | Main content

Email Facebook LinkedIn Twitter Google

Blog...

Copy Table Schema with SQL Server Management Studio

Posted At : December 28, 2009 6:05 PM | Posted By : Jason Holden
Related Categories: SQL Server

Quick way to copy the table schema using SQL Server Management Studio:

  1. Right-Click table to copy
  2. Script table as
  3. CREATE To
  4. New Query Editor Window
  5. Find & Replace all instances of the table you are copying with the table you wish to create

NOTE: Pay attention to any Primary Key and Foreign Key indexes listed in the SQL script. They may require updating as well.

Comments (0) | Print | Send | del.icio.us | Digg It! | Linking Blogs
239 Views

SQL Server 2008 Active Connections

Posted At : June 17, 2009 3:29 PM | Posted By : Jason Holden
Related Categories: SQL Server

Went digging around for ways to view the active connections in Microsoft SQL 2008. To my surprise Microsoft moved the Activity Monitor. Apparently they did this way back in SQL 2005. I skipped 2005 so I missed that. To view the open connection:

  1. Open Management Studio.
  2. On the standard toolbar is a little graph icon. That is the Activity Monitor (CTRL + ALT + A).
  3. Click on Processes

Simple as that!

Comments (0) | Print | Send | del.icio.us | Digg It! | Linking Blogs
1445 Views
BlogCFC was created by Raymond Camden. This blog is running version 5.9.1.001.