Hello Tim,
  Could you please add Database defragmentation ? (records, indexed)
like DBISAM had (rebuilding indexes) ?

In MSSQL Server you can do this:
ALTER DATABASE MYDATABASE
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE

GO

DBCC CHECKDB ('MYDATABASE', REPAIR_REBUILD)

GO

ALTER DATABASE MYDATABASE
SET MULTI_USER
WITH ROLLBACK IMMEDIATE

Thank you

--
Charalabos Michael - [Creation Power] - http://www.creationpower.gr

>   Could you please add Database defragmentation ? (records, indexed)
> like DBISAM had (rebuilding indexes) ?

It's already in EDB.  But instead of it being a function of the TEDBTable
object, it's an SQL call.  The online documentation for this call is
available at
http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=14&topic=286

Hope this is what you were looking for.

--

---------------------------------------
 Terry Swiers
 Millennium Software, Inc.
 http://www.1000years.com
 http://www.atrex.com

 Atrex Inventory Control/POS -
    Big business features without spending big business bucks!

Atrex Electronic Support Options:
 Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp
 Email: mailto:support@atrex.com
 Newsgroup: news://news.1000years.com/millennium.atrex
 Fax: 1-925-829-1851
 Phone: 1-925-828-5892 (M-F, 9a-5p Pacific)
 ---------------------------------------

Dear Terry,

> It's already in EDB.  But instead of it being a function of the TEDBTable
> object, it's an SQL call.  The online documentation for this call is
> available at
> http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=14&topic=286

Opps, i missed that due the fact is not included in EDB Manager ...

But as i can it does optimize the dabatase and not the indexes. (aka
index rebuild)

Thank you

--
Charalabos Michael - [Creation Power] - http://www.creationpower.gr

Michael,

<< But as i can it does optimize the dabatase and not the indexes. (aka
index rebuild) >>

In ElevateDB, an OPTIMIZE TABLE always rebuilds the indexes.

--
Tim Young
Elevate Software
www.elevatesoft.com

Dear Tim,

> << But as i can it does optimize the dabatase and not the indexes. (aka
> index rebuild) >>
>
> In ElevateDB, an OPTIMIZE TABLE always rebuilds the indexes.
>

Thank Tim for the info. It would be nice to update your documents
informing about index rebuild on optimize table.

--
Charalabos Michael - [Creation Power] - http://www.creationpower.gr

Michael,

<< Thank Tim for the info. It would be nice to update your documents
informing about index rebuild on optimize table. >>

I will make a note of this.

--
Tim Young
Elevate Software
www.elevatesoft.com