OK.Everything is true and also the datafiles will increase as per the insertion of the data.But why so much free space remain where as it is not the same for...

Can anybody tell me why this happen?

That means in which situation and how can we avoid it??????????

The perticular user is not showing in the restored database.It is showing some different user.And this time when I run the above command it is showing that updating 1 user...

Hi,

when I am running this command in T_SQL logging in as administrator then the following message is coming.

The number of orphaned users fixed by updating users was 0.

The number of...

Hi,

I am not getting it.

Will u plz tell me in details?????????

then can u plz me out to resolve the problem????

I restore it on a different server.

I have checked from all sites.

But ur suggestion worked out.Actually i had to change from properties of sql server agent.

Regards.

Sunanda

Around 30000000 records are there in the table.I cant use TRUNCATE as its index will also removed(though I can recreate it again).

So any other option.

I want to cleanup the table.As per my application we need to cleanup the table when the database size is increased.

I am attaching the table structure and these tables contain the following records.

shareholder--------1693568

company_master---864470

share_capital-------903381

tbldirector----------1257093

I need to do reindexing as the tables are very big and if I wont do reindexing then locking in objects and for which the agent's system are hanged frequently.

If...

thanks a lot.

it is solved now.

Thanks a lot.