use: DBCC INDEXDEFRAG (Northwind, Orders, CustomersOrders) GO where northwind etc are databases.
details: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_30o9.asp ----- Original Message ----- From: "yean50" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Friday, August 26, 2005 12:19 PM Subject: [AspNetAnyQuestionIsOk] Defragment SQL database > Hi, > > Does anyone know how can a SQL database be defragment? > > Thanks, > > > > > __________________________________ > Yahoo! Mail for Mobile > Take Yahoo! Mail with you! Check email on your mobile phone. > http://mobile.yahoo.com/learn/mail > > > > > Yahoo! Groups Links > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
