in my job

step 1-- re indexing

EXEC sp_msForEachTable @COMMAND1= 'DBCC DBREINDEX ( "?")'

step 2--- update statistics

DECLARE @table_name varchar(1000),@sql nvarchar(4000) declare c1 cursor for SELECT name FROM sysobjects WHERE xtype...

But i want to re index all tables in database...

all tables are heavily fragmented

i have find one job re indexing running on sunday...

that might be the issues...

But how to maintain that data file not to grow

It is because full backup occur..

i have checked it but there is no hidden tasks are running on sunday

i have run profiler also i couldn't find anything on that...

i have finally finds the problem one of my scheduled job executing below script at every 10 sec so that why cmdshell is disabled

sp_configure 'xp_cmdshell',0

reconfigure

i am disable that job and...

Sql server 2008 policy is disable.....

but when i enable xp_cmdshell its automatically disable.....

how i can see any triggers or notifications......

i have done this

sp_configure 'xp_cmdshell',1

go

reconfigure with override

certain fraction of seconds its enabled and again its disable

check what your given credential while setting database profile account. ....

Its depends upon ur network bandwidth....

u can use import and export data....

db_datareader you will able to read all tables where as in

db_denydatawriter you are not able to read any tables and does not allow to do insert,delete,update.

after ur rebuild index/reorganize, you scheduled shrink database log then after take a full database backup

while installation check whether ur antivirus is blocking some of components.....