Thanks henrico

Thanks Everyone ..

but wat abt data security..

The reason is because u dont have permission...

Thanks Everyone

Thanks Grant

Please check whether its .ldf or .mdf file thats growing ...

Tat might be ldf and u can shrink that...

Thanks Ninja,

So TRUNCATE and DELETE are almost same then why its like TRUNCATE can be done by using an ALTER permission where as DELETE cannot and need specific permission?

Thanks Pradeep..

Can you please let me know why like this?? I wonder why Truncate remove all data which cannot be rolled back with just an ALTER PERMISSION

TIA

Thanks alot grant & Eric for that informative and quick reply..

Hi Sudhakara,

Try creating a db mail so that you will automatically get answer for ur question

account_idmail account id

Servernameserver type (SMTP,MAPI)

servernameMail Server Name

portPort

usernameUser name

credential_id

use_default_credentials0 for no and 1 for yes

enable_ssl1 for no and 1 for yes(secure socket layer)

flags

last_mod_datetimemodified date

last_mod_usermodified by user

many reasons..

1. any job inserting bulk data into that database.

2.some other offline operation on related tables.

3.backup database job start by that time.

4.maintenance plans

5.tempdb full

6.cpu,memory bottleneck

7.too many indexes

8.excessive normalization

created a user having only read permission in SOURCE SERVER.

select security tab under linked server properties in TARGET SERVER and use that user in BE MADE USING THIS...

A database can become suspect for several reasons. Possible causes include denial of access to a database resource by the operating system, and the unavailability or corruption of one or...

suspend or suspect?