Create table structure from another table in sql server 2008

Top sites by search query "create table structure from another table in sql server 2008"

Jon Galloway - Adding simple trigger-based auditing to your SQL Server database

  http://weblogs.asp.net/jongalloway/adding-simple-trigger-based-auditing-to-your-sql-server-database
Could anyone post that if this works well if multiple tables are audited? jenny - Wednesday, March 11, 2009 10:44:40 PM Could anyone figure out how to make this script work for delete? This script only audit Insert and Update, not delete. Your primary tables should ALWAYS have INSERTUSERID, INSERTDATE, and MODIFIEDUSERID, MODIFIFEDDATE, this way when your audit runs, you can pull the data because you are writting it to the table..

Linchi Shea : SQL Server 2008 Page Compression: Using multiple processors

  http://sqlblog.com/blogs/linchi_shea/archive/2008/05/05/sql-server-2008-page-compression-using-multiple-processors.aspx
How do you instruct SQL Server 2008 to take advantage of multiple processors? There exists another rebuild option called MAXDOP, which you can use to inform SQL Server of the max number of processors you want the rebuild to use. The key compression method is called page compression, which uses the following three techniques to reduce the space taken up by duplicates on a page: Row compression

  http://sqlmag.com/t-sql/using-fake-temporary-tables
Let's explore two examples: how to use fake temporary tables inside triggers and how to use fake temporary tables to execute stored procedures affecting a batch of changes. So, how can you send a data set to a stored procedure for further processing? Suppose you have a stored procedure called CheckInvoice, which converts proposed invoices into permanent ones

Geeks With Blogs

  http://geekswithblogs.net/nagendraprasad/archive/2009/03/20/copy-a-table-into-new-table-with-and-without-data.aspx
Copy only the structure with data of an existing table into new table: SELECT * INTO tblNew FROM tblOld This is also same like the previous query, but it copies the structure of existing table(tblOld) with data as well into the new table(tblNew)

sql server - Copy complete structure of a table - Database Administrators Stack Exchange

  http://dba.stackexchange.com/questions/18059/copy-complete-structure-of-a-table
The above scripting option doesn't just pull the entire CREATE TABLE DDL from a single location in the metadata; it does a whole bunch of magic behind the scenes in the code to generate the eventual CREATE TABLE script (you can use Profiler to see where it gets its data, but you can't see how it assembles it). Arguably this is much closer to your targeted CREATE TABLE statement than a convoluted approach using sys.columns, but there is still a lot of work to do

  http://blog.sqlauthority.com/2007/08/15/sql-server-insert-data-from-one-table-to-another-table-insert-into-select-select-into-table/
If data is huge, if there are any Non-Clustered indexes that are not build on primary key or unique key, then disable those indexes, loading will be much faster. How can I fix? I have SQL Server 2008 and Visual Studio 2008 and am trying to automatically insert new records into a child table based on new inserts into its parent table

scripting - In SQL Server, how do I generate a CREATE TABLE statement for a given table? - Stack Overflow

  http://stackoverflow.com/questions/21547/in-sql-server-how-do-i-generate-a-create-table-statement-for-a-given-table
Yes, you can "right click" on the table and script the CREATE TABLE script, but: The a script will contain loads of cruft (interested in the extended properties anyone?) If you have 200+ tables in your schema, it's going to take you half a day to script the lot by hand. With this script converted into a stored procedure, and combined with a wrapper script you would have a nice automated way to dump your table design into source control etc

  http://blog.sqlauthority.com/2009/07/29/sql-server-2008-copy-database-with-data-generate-t-sql-for-inserting-data-from-one-table-to-another-table/
Select the desired output options of Script to file, Script to Clipboard or Script New Query Window.3 Clicking on Finish button will generate a review screen containing the required objects along with script generating data. i have a procedure for this which needs a table in your DB which stores information about the other server and the tables which we going to send over two servers