Re: How to generate drop and recreate index script in SQL Manageme

If you are just talking about the index by itself it may not. I would have
to try that. But you said tables and their indexes. When you drop the table
the corresponding indexes get dropped as well.

--
Andrew J. Kelly SQL MVP

"Moh" <mabbas@xxxxxxxxx> wrote in message
news:4DF047CC-622D-46AA-ABD6-169D312F4C16@xxxxxxxxxxxxxxxx
you think so. did you tyry it out. I do have SP2 and it does not give
option
to drop index unless I am missing which you know
--
Sr DBA
Pier 1 Imports
mabbas@xxxxxxxxx


"Andrew J. Kelly" wrote:

Well assuming you have SP2 loaded you can do this from SSMS by generating
a
script similar to how it was done in 2000. Right click ont he db and
choose
Tasks - Generate Scripts.

--
Andrew J. Kelly SQL MVP

"Moh" <mabbas@xxxxxxxxx> wrote in message
news:66ED2530-32D6-46F9-9609-7CAE6D9A268E@xxxxxxxxxxxxxxxx
I am wondering it was so simple to create the script in SQL2000. How can
we
generate the a script to drop and recreate the tables and associated
indexes
in SQL management studio 2005

Thx,
--
Sr DBA
Pier 1 Imports
mabbas@xxxxxxxxx





.

Relevant Pages

  • Re: Row size and DBCC SHOWCONTIG
    ... Sorry but I didn't even see the script the first time. ... Andrew J. Kelly SQL MVP ... > It behaves the same way with or without a clustered index. ... >> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Database Backup
    ... Don't use EM, use a script instead. ... The restore syntax is ... Andrew J. Kelly SQL MVP ... >> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Passing in multiple values to one parameter
    ... > Table script ... > Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Moving Full database to Empty database
    ... Andrew J. Kelly SQL MVP ... > script droping of them? ... Do a Restore of the full db over top of the Empty DB. ... >> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.dts)
  • Re: Extremely high % Disk Time .. How is this possible??
    ... Andrew J. Kelly SQL MVP ... > Slicing them into logical drives may look better but it does not increase ... I prefer to look at disk queue ... >>> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.clustering)