defrag database

Hello all
Is there an easy way to see if my db needs to be defraged?
ThanksWhat version of SQL Server?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Andre Gibson" <AndreGibson@.discussions.microsoft.com> wrote in message
news:80E6AA03-C748-4A6E-96EB-D2D7A7E48AB1@.microsoft.com...
> Hello all
> Is there an easy way to see if my db needs to be defraged?
> Thanks|||sorry Sql Server 2000
"Tibor Karaszi" wrote:

> What version of SQL Server?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Andre Gibson" <AndreGibson@.discussions.microsoft.com> wrote in message
> news:80E6AA03-C748-4A6E-96EB-D2D7A7E48AB1@.microsoft.com...
>|||Check out DBCC SHOWCONTIG
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Andre Gibson" <AndreGibson@.discussions.microsoft.com> wrote in message
news:DE1AD78C-62F8-4E03-ACBF-05A264D26B33@.microsoft.com...[vbcol=seagreen]
> sorry Sql Server 2000
> "Tibor Karaszi" wrote:
>

default tables

hi all
is there any one who can tell the basic idea behind inserted, deleted mssql table. how these r affected on dml operations.
i m new to mssql.
thanksInserted and deleted are two special tables used in the trigger statements.

The deleted table stores copies of the affected rows during DELETE and UPDATE statements. During the execution of a DELETE or UPDATE statement, rows are deleted from the trigger table and transferred to the deleted table. The deleted table and the trigger table ordinarily have no rows in common.

The inserted table stores copies of the affected rows during INSERT and UPDATE statements. During an insert or update transaction, new rows are added simultaneously to both the inserted table and the trigger table. The rows in the inserted table are copies of the new rows in the trigger table.

Check BOL for more information.

Harshal.