mcgants
asked on
SQL server equivalent to Access Compact Repair Tool?
Simply put, is there a SQL server equivalent to the MS Access Compact Repair Tool?
Cheers in advance
Cheers in advance
Anthony Perkins
The closest you have is Shrink Database.
Yes, sorta...but you'll have to do some reading.
DBCC INDEXDEFRAG
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_30o9.asp
and
DBCC DBREINDEX
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_94mw.asp
DBCC INDEXDEFRAG
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_30o9.asp
and
DBCC DBREINDEX
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_94mw.asp
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Also, please maintain these abandoned questions:
1 12/08/2004 30 ASP.NET class files Open ASP.NET
2 12/07/2004 250 Multiple Log-ons Error Open ASP.NET
1 12/08/2004 30 ASP.NET class files Open ASP.NET
2 12/07/2004 250 Multiple Log-ons Error Open ASP.NET