January 14, 2010 at 10:22 am
Copy table with index and statistics,is anyone knows how I can copy table with indexes and statistics with another name
January 14, 2010 at 10:54 am
Krasavita (1/14/2010)
Copy table with index and statistics,is anyone knows how I can copy table with indexes and statistics with another name
Maybe it can be done with other alternatives, but the one that I know is copy Database in the new one!
January 14, 2010 at 1:05 pm
Do you need to copy data too?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 14, 2010 at 1:34 pm
no
January 14, 2010 at 1:50 pm
Krasavita (1/14/2010)
Copy table with index and statistics,is anyone knows how I can copy table with indexes and statistics with another name
...also with no data...any reason why do you need that!?
copying database at all an another location then using import that table with different name...let me know if it works!
January 14, 2010 at 2:30 pm
You can script out the table and its indexes from SSMS. As for the statistics, you should leave that to the DB Engine.
Once you script your table, change the table name - then execute the script on the new server.
Alternative method, Use RedGate SQL Compare - you can create the table on the destination and then alter the table name after the table is created there.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply