[dba-SQLServer] SQL Server 2005 - Shrinking databases

Stephen Hait shait at mindspring.com
Mon Jan 22 14:04:42 CST 2007


On 1/22/07, JWColby <jwcolby at colbyconsulting.com> wrote:
> Is there any way to get sql server to build the script from existing
> indexes?

EM for SQL Server 2000 can generate the SQL to create the indexes.
Right click the table you want to script indexes for, select All
Tasks, Generate SQL Script and look at the options there.

Stephen



More information about the dba-SQLServer mailing list