 | |
Can I create a Scipt with only create index command?
microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Can I create a Scipt with only create index command? -
08-26-2008
, 09:27 AM
#2
| |||
| |||
|
|
I'm using SSMS with SQL 2005 SP2. I've been trying to create a script using the "Generate Script" wizard that only has Drop Index and Create Index commands. I don’t want the create table command. The database has about 500 tables and it will take me hours to generate a FULL script and manually edit out all the create table commands. I swear this was an option in the old SQL 2000 Enterprise Manager. I'm I look for a "needle in a haystack?" |
not used scripting much in EM 2000.
And, no, you cannot do it in SSMS. But I agree that it could be useful.
http://connect.microsoft.com/SqlServer/Feedback/ is a good place to make
your word heard in the issue.
In the mean while, here is a Perl one-liner for you:
perl -ne "BEGIN {$/ = qq!\nGO\n!} print if /CREATE( UNIQUE)? (NON)?CLUSTERED
INDEX/" yourfile.sql
Where yourfile was created by the script wizard in SSMS.
Caveat 1: when you script the database make sure to select output to an ANSI
file.
Caveat 2: this does not include Primary keys and Unique constraints.
Caveat 3: my test file was created by SSMS 2008.
Then again, if you have your code under version control, this should
not really be an issue.
--
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
#3
| |||
| |||
|
|
I'm using SSMS with SQL 2005 SP2. I've been trying to create a script using the "Generate Script" wizard that only has Drop Index and Create Index commands. I don’t want the create table command. The database has about 500 tables and it will take me hours to generate a FULL script and manually edit out all the create table commands. I swear this was an option in the old SQL 2000 Enterprise Manager. I'm I look for a "needle in a haystack?" |
not used scripting much in EM 2000.
And, no, you cannot do it in SSMS. But I agree that it could be useful.
http://connect.microsoft.com/SqlServer/Feedback/ is a good place to make
your word heard in the issue.
In the mean while, here is a Perl one-liner for you:
perl -ne "BEGIN {$/ = qq!\nGO\n!} print if /CREATE( UNIQUE)? (NON)?CLUSTERED
INDEX/" yourfile.sql
Where yourfile was created by the script wizard in SSMS.
Caveat 1: when you script the database make sure to select output to an ANSI
file.
Caveat 2: this does not include Primary keys and Unique constraints.
Caveat 3: my test file was created by SSMS 2008.
Then again, if you have your code under version control, this should
not really be an issue.
--
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
#4
| |||
| |||
|
|
I'm using SSMS with SQL 2005 SP2. I've been trying to create a script using the "Generate Script" wizard that only has Drop Index and Create Index commands. I don’t want the create table command. The database has about 500 tables and it will take me hours to generate a FULL script and manually edit out all the create table commands. I swear this was an option in the old SQL 2000 Enterprise Manager. I'm I look for a "needle in a haystack?" |
not used scripting much in EM 2000.
And, no, you cannot do it in SSMS. But I agree that it could be useful.
http://connect.microsoft.com/SqlServer/Feedback/ is a good place to make
your word heard in the issue.
In the mean while, here is a Perl one-liner for you:
perl -ne "BEGIN {$/ = qq!\nGO\n!} print if /CREATE( UNIQUE)? (NON)?CLUSTERED
INDEX/" yourfile.sql
Where yourfile was created by the script wizard in SSMS.
Caveat 1: when you script the database make sure to select output to an ANSI
file.
Caveat 2: this does not include Primary keys and Unique constraints.
Caveat 3: my test file was created by SSMS 2008.
Then again, if you have your code under version control, this should
not really be an issue.
--
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
#5
| |||
| |||
|
|
I'm using SSMS with SQL 2005 SP2. I've been trying to create a script using the "Generate Script" wizard that only has Drop Index and Create Index commands. I don’t want the create table command. The database has about 500 tables and it will take me hours to generate a FULL script and manually edit out all the create table commands. I swear this was an option in the old SQL 2000 Enterprise Manager. I'm I look for a "needle in a haystack?" |
not used scripting much in EM 2000.
And, no, you cannot do it in SSMS. But I agree that it could be useful.
http://connect.microsoft.com/SqlServer/Feedback/ is a good place to make
your word heard in the issue.
In the mean while, here is a Perl one-liner for you:
perl -ne "BEGIN {$/ = qq!\nGO\n!} print if /CREATE( UNIQUE)? (NON)?CLUSTERED
INDEX/" yourfile.sql
Where yourfile was created by the script wizard in SSMS.
Caveat 1: when you script the database make sure to select output to an ANSI
file.
Caveat 2: this does not include Primary keys and Unique constraints.
Caveat 3: my test file was created by SSMS 2008.
Then again, if you have your code under version control, this should
not really be an issue.
--
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
#6
| |||
| |||
|
|
I'm using SSMS with SQL 2005 SP2. I've been trying to create a script using the "Generate Script" wizard that only has Drop Index and Create Index commands. I don’t want the create table command. The database has about 500 tables and it will take me hours to generate a FULL script and manually edit out all the create table commands. I swear this was an option in the old SQL 2000 Enterprise Manager. I'm I look for a "needle in a haystack?" |
not used scripting much in EM 2000.
And, no, you cannot do it in SSMS. But I agree that it could be useful.
http://connect.microsoft.com/SqlServer/Feedback/ is a good place to make
your word heard in the issue.
In the mean while, here is a Perl one-liner for you:
perl -ne "BEGIN {$/ = qq!\nGO\n!} print if /CREATE( UNIQUE)? (NON)?CLUSTERED
INDEX/" yourfile.sql
Where yourfile was created by the script wizard in SSMS.
Caveat 1: when you script the database make sure to select output to an ANSI
file.
Caveat 2: this does not include Primary keys and Unique constraints.
Caveat 3: my test file was created by SSMS 2008.
Then again, if you have your code under version control, this should
not really be an issue.
--
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
#7
| |||
| |||
|
|
I'm using SSMS with SQL 2005 SP2. I've been trying to create a script using the "Generate Script" wizard that only has Drop Index and Create Index commands. I don’t want the create table command. The database has about 500 tables and it will take me hours to generate a FULL script and manually edit out all the create table commands. I swear this was an option in the old SQL 2000 Enterprise Manager. I'm I look for a "needle in a haystack?" |
not used scripting much in EM 2000.
And, no, you cannot do it in SSMS. But I agree that it could be useful.
http://connect.microsoft.com/SqlServer/Feedback/ is a good place to make
your word heard in the issue.
In the mean while, here is a Perl one-liner for you:
perl -ne "BEGIN {$/ = qq!\nGO\n!} print if /CREATE( UNIQUE)? (NON)?CLUSTERED
INDEX/" yourfile.sql
Where yourfile was created by the script wizard in SSMS.
Caveat 1: when you script the database make sure to select output to an ANSI
file.
Caveat 2: this does not include Primary keys and Unique constraints.
Caveat 3: my test file was created by SSMS 2008.
Then again, if you have your code under version control, this should
not really be an issue.
--
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
#8
| |||
| |||
|
|
I'm using SSMS with SQL 2005 SP2. I've been trying to create a script using the "Generate Script" wizard that only has Drop Index and Create Index commands. I don’t want the create table command. The database has about 500 tables and it will take me hours to generate a FULL script and manually edit out all the create table commands. I swear this was an option in the old SQL 2000 Enterprise Manager. I'm I look for a "needle in a haystack?" |
not used scripting much in EM 2000.
And, no, you cannot do it in SSMS. But I agree that it could be useful.
http://connect.microsoft.com/SqlServer/Feedback/ is a good place to make
your word heard in the issue.
In the mean while, here is a Perl one-liner for you:
perl -ne "BEGIN {$/ = qq!\nGO\n!} print if /CREATE( UNIQUE)? (NON)?CLUSTERED
INDEX/" yourfile.sql
Where yourfile was created by the script wizard in SSMS.
Caveat 1: when you script the database make sure to select output to an ANSI
file.
Caveat 2: this does not include Primary keys and Unique constraints.
Caveat 3: my test file was created by SSMS 2008.
Then again, if you have your code under version control, this should
not really be an issue.
--
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
#9
| |||
| |||
|
|
I'm using SSMS with SQL 2005 SP2. I've been trying to create a script using the "Generate Script" wizard that only has Drop Index and Create Index commands. I don’t want the create table command. The database has about 500 tables and it will take me hours to generate a FULL script and manually edit out all the create table commands. I swear this was an option in the old SQL 2000 Enterprise Manager. I'm I look for a "needle in a haystack?" |
not used scripting much in EM 2000.
And, no, you cannot do it in SSMS. But I agree that it could be useful.
http://connect.microsoft.com/SqlServer/Feedback/ is a good place to make
your word heard in the issue.
In the mean while, here is a Perl one-liner for you:
perl -ne "BEGIN {$/ = qq!\nGO\n!} print if /CREATE( UNIQUE)? (NON)?CLUSTERED
INDEX/" yourfile.sql
Where yourfile was created by the script wizard in SSMS.
Caveat 1: when you script the database make sure to select output to an ANSI
file.
Caveat 2: this does not include Primary keys and Unique constraints.
Caveat 3: my test file was created by SSMS 2008.
Then again, if you have your code under version control, this should
not really be an issue.
--
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
#10
| |||
| |||
|
|
I'm using SSMS with SQL 2005 SP2. I've been trying to create a script using the "Generate Script" wizard that only has Drop Index and Create Index commands. I don’t want the create table command. The database has about 500 tables and it will take me hours to generate a FULL script and manually edit out all the create table commands. I swear this was an option in the old SQL 2000 Enterprise Manager. I'm I look for a "needle in a haystack?" |
not used scripting much in EM 2000.
And, no, you cannot do it in SSMS. But I agree that it could be useful.
http://connect.microsoft.com/SqlServer/Feedback/ is a good place to make
your word heard in the issue.
In the mean while, here is a Perl one-liner for you:
perl -ne "BEGIN {$/ = qq!\nGO\n!} print if /CREATE( UNIQUE)? (NON)?CLUSTERED
INDEX/" yourfile.sql
Where yourfile was created by the script wizard in SSMS.
Caveat 1: when you script the database make sure to select output to an ANSI
file.
Caveat 2: this does not include Primary keys and Unique constraints.
Caveat 3: my test file was created by SSMS 2008.
Then again, if you have your code under version control, this should
not really be an issue.
--
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.