 | |
Can I create a Scipt with only create index command?
microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools
 |
| | Thread Tools | Display Modes |
#31
 
| |||
| |||
|
Re: Can I create a Scipt with only create index command? -
08-29-2008
, 05:40 PM
|
How to create a script with indexes and Primary Keys only using SQL Server 2000 Enterprise Manager In short, using SQL Server 2000 EM, from a database select the Generate Script option. When the wizard starts, 1. From the General Tab - select the script all object box 2. From the Formatting Tab remove all the checkboxes under the srcipting options... 3. From the Options Tab, select Script Indexes and/or Script Primary keys... 4. Then either press OK or return to the General Tab and press preview. The resulting output is a script of only create index commands and/or Alter Table commands (used to create the PK constraint). A very useful feature that is no longer available in SSMS 2005 or SSMS 2008. |
almost as if it works by accident.
I tried the corresponding in SSMS, but it was smarter, it scripted
nothing at all.
I'm afraid that you will have to make your own hack; my Perl hack could
be a start, or investigate the third-party market. Red Gate's SQL
Compare is able to script to file, but I don't have any copy available
to see what you selections you can make.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#32
| |||
| |||
|
|
How to create a script with indexes and Primary Keys only using SQL Server 2000 Enterprise Manager In short, using SQL Server 2000 EM, from a database select the Generate Script option. When the wizard starts, 1. From the General Tab - select the script all object box 2. From the Formatting Tab remove all the checkboxes under the srcipting options... 3. From the Options Tab, select Script Indexes and/or Script Primary keys... 4. Then either press OK or return to the General Tab and press preview. The resulting output is a script of only create index commands and/or Alter Table commands (used to create the PK constraint). A very useful feature that is no longer available in SSMS 2005 or SSMS 2008. |
almost as if it works by accident.
I tried the corresponding in SSMS, but it was smarter, it scripted
nothing at all.
I'm afraid that you will have to make your own hack; my Perl hack could
be a start, or investigate the third-party market. Red Gate's SQL
Compare is able to script to file, but I don't have any copy available
to see what you selections you can make.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#33
| |||
| |||
|
|
How to create a script with indexes and Primary Keys only using SQL Server 2000 Enterprise Manager In short, using SQL Server 2000 EM, from a database select the Generate Script option. When the wizard starts, 1. From the General Tab - select the script all object box 2. From the Formatting Tab remove all the checkboxes under the srcipting options... 3. From the Options Tab, select Script Indexes and/or Script Primary keys... 4. Then either press OK or return to the General Tab and press preview. The resulting output is a script of only create index commands and/or Alter Table commands (used to create the PK constraint). A very useful feature that is no longer available in SSMS 2005 or SSMS 2008. |
almost as if it works by accident.
I tried the corresponding in SSMS, but it was smarter, it scripted
nothing at all.
I'm afraid that you will have to make your own hack; my Perl hack could
be a start, or investigate the third-party market. Red Gate's SQL
Compare is able to script to file, but I don't have any copy available
to see what you selections you can make.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#34
| |||
| |||
|
|
How to create a script with indexes and Primary Keys only using SQL Server 2000 Enterprise Manager In short, using SQL Server 2000 EM, from a database select the Generate Script option. When the wizard starts, 1. From the General Tab - select the script all object box 2. From the Formatting Tab remove all the checkboxes under the srcipting options... 3. From the Options Tab, select Script Indexes and/or Script Primary keys... 4. Then either press OK or return to the General Tab and press preview. The resulting output is a script of only create index commands and/or Alter Table commands (used to create the PK constraint). A very useful feature that is no longer available in SSMS 2005 or SSMS 2008. |
almost as if it works by accident.
I tried the corresponding in SSMS, but it was smarter, it scripted
nothing at all.
I'm afraid that you will have to make your own hack; my Perl hack could
be a start, or investigate the third-party market. Red Gate's SQL
Compare is able to script to file, but I don't have any copy available
to see what you selections you can make.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#35
| |||
| |||
|
|
How to create a script with indexes and Primary Keys only using SQL Server 2000 Enterprise Manager In short, using SQL Server 2000 EM, from a database select the Generate Script option. When the wizard starts, 1. From the General Tab - select the script all object box 2. From the Formatting Tab remove all the checkboxes under the srcipting options... 3. From the Options Tab, select Script Indexes and/or Script Primary keys... 4. Then either press OK or return to the General Tab and press preview. The resulting output is a script of only create index commands and/or Alter Table commands (used to create the PK constraint). A very useful feature that is no longer available in SSMS 2005 or SSMS 2008. |
almost as if it works by accident.
I tried the corresponding in SSMS, but it was smarter, it scripted
nothing at all.
I'm afraid that you will have to make your own hack; my Perl hack could
be a start, or investigate the third-party market. Red Gate's SQL
Compare is able to script to file, but I don't have any copy available
to see what you selections you can make.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#36
| |||
| |||
|
|
How to create a script with indexes and Primary Keys only using SQL Server 2000 Enterprise Manager In short, using SQL Server 2000 EM, from a database select the Generate Script option. When the wizard starts, 1. From the General Tab - select the script all object box 2. From the Formatting Tab remove all the checkboxes under the srcipting options... 3. From the Options Tab, select Script Indexes and/or Script Primary keys... 4. Then either press OK or return to the General Tab and press preview. The resulting output is a script of only create index commands and/or Alter Table commands (used to create the PK constraint). A very useful feature that is no longer available in SSMS 2005 or SSMS 2008. |
almost as if it works by accident.
I tried the corresponding in SSMS, but it was smarter, it scripted
nothing at all.
I'm afraid that you will have to make your own hack; my Perl hack could
be a start, or investigate the third-party market. Red Gate's SQL
Compare is able to script to file, but I don't have any copy available
to see what you selections you can make.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#37
| |||
| |||
|
|
How to create a script with indexes and Primary Keys only using SQL Server 2000 Enterprise Manager In short, using SQL Server 2000 EM, from a database select the Generate Script option. When the wizard starts, 1. From the General Tab - select the script all object box 2. From the Formatting Tab remove all the checkboxes under the srcipting options... 3. From the Options Tab, select Script Indexes and/or Script Primary keys... 4. Then either press OK or return to the General Tab and press preview. The resulting output is a script of only create index commands and/or Alter Table commands (used to create the PK constraint). A very useful feature that is no longer available in SSMS 2005 or SSMS 2008. |
almost as if it works by accident.
I tried the corresponding in SSMS, but it was smarter, it scripted
nothing at all.
I'm afraid that you will have to make your own hack; my Perl hack could
be a start, or investigate the third-party market. Red Gate's SQL
Compare is able to script to file, but I don't have any copy available
to see what you selections you can make.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.