Reply to Re: Scripted CREATE INDEX

Your name:

Reply:


Posted by jezemine on 03/13/07 00:55

On Mar 12, 11:55 am, "rcamarda" <robert.a.cama...@gmail.com> wrote:
> I haveSQLServer 2005 x64. I found in the studio I cangenerateall
> sorts of scripts, including the creation of indexes.
> I works, however thescriptcontains the CREATE TABLE statements as
> well. I want the scripts to recreate the scripts on another filegroup
> (testing a theory from previous post).
> Am I missing a switch in the wizard to exclude CREATE TABLE?
> I did create thescript, but then I manually deleted all the CREATE
> TABLE statements, which was a pain.
> Thanks
> Rob

If you want to fine-tune what gets scripted, you might want to check
out this free app I wrote using SMO:

http://www.elsasoft.org/tools.htm

it will generate scripts for all objects in any 2000 or 2005 db. You
could easily modify it to script only indexes. source code is
available. implemented in C#.

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация