What is Cdonts and how would you use it?

Rgds

Andy

This example gets the eigth row from sysobjects you should be able to adapt it to any table.

select top 1 * from (select top 8 * from sysobjects order by...

If its a single email then select @var = field1 +' ' +Field2 + ' ' + filed3 ... from table

exec sp_send_cdontsmail ..  @message=@var

RGDS

Andy Llewellyn

I am assuming that you want to send an email to the person in the row just inserted and not to all people in the table.

First you need to query...

Try a DBCC UPDATEUSAGE first

You can use performance manager to track the number of active transactions for a particular database.

There is a indicator in the {instancename}:databases section for active transactions this can be monitored...

Try the following commands

USE master

go

DBCC SHRINKDATABASE('tempdb', NOTRUNCATE)

go

DBCC SHRINKDATABASE('tempdb', TRUNCATEONLY)

go

The NOTRUNCATE option moves all the data in the database to the front of the files before attempting the shrink.

Hope this helps

Andy...