The table on which I  want to create the trigger is on db1 and the tables on which the trigger insert the result is on db2.Will triggers work with different...

Its is due to requirement for a new application.its a  matter of urgency

Ok mike thats nice explanation about the stats .

I am wondering  how much should I  keep "remove unused space from database files when it grow beyond" so that it fullfil my database...

I m still confused abt  this..pls suggest

I m not doing reindexing with the maint plan wizard.i have made a seperate job for thisn which is scheduled on a 15 day basis.

I am using a sample of...

I am worry about the fact that assigning improper maintainence plan will degrade the performance of db.so i am looking for some benchmark and things to be consider before assigning...

Is there any thumb rule which can be used to decide about this selection.Pls suggest

DBCC results for 'accounts'.

DBCC results for 'sysobjects'.

There are 153 rows in 3 pages for object 'sysobjects'.

DBCC results for 'sysindexes'.

There are 146 rows in 7 pages for object 'sysindexes'.

DBCC results for...

I did the same but still I am getting the same error.Our cleint is unable to use  the db..pl s help.this is urgent

I have the log files.The main problem is there is a seperate folder for each and every database.the log file exist eith the datafile.I need to attach all these databases...

strange!! no reply