So trigger should be avoided if possible?

hey jeremy,

two databases will be in the same server and two will be in different server. i could have used replication but the problem is the schema is different in...

thanks dinesh.

that did the trick.

as mentioned in the article from the link you provided, i can start trace to trace events using filters. but the problem with using sp for tracing is i couldn't...

thanx scott.

i have created a job to run every 1 minute and execute that sp. is there any way i can make the recurring job frequency less than 1...

but how can i differentiate the applications? i mean which one is EM, QA or custom application? i am using windows authentication. so they will be able to connect using...

thanx for all the help guys. i am new to this thing. i didn't know that "Whenever job completes" feature was in the "Jobs". I was looking for it under...

actually i am testing with this email thing. so i want to do both at the moment: notify on failure or success or email the maintenance plan report if that's...

where can i find "Whenever the job completes" option? BTW, i am using sql 2000, standard edition.

yes it did. i tried couple of times.

that was in my development machine. yes i did reboot my computer but still not working.

thanx dilip.

i did use the BBCC DEINDEXFRAG and DBCC DBREINDEX and also tried deleting and recreating index manually but still extent scan fragmentation doesn't improve. fill factor is 90%.

DBCC...

thanx dilip.

i did use the BBCC DEINDEXFRAG and DBCC DBREINDEX and also tried deleting and recreating index manually but still extent scan fragmentation doesn't improve. fill factor is 90%.

DBCC...

thanx dilip.

i have got two databases. i checked them using command "dbcc checkdb 'dbname' " and i got the following message at the end "CHECKDB found 0 allocation errors and...

Hi dilip,

Thanx for the reply. My integrity check is failing but full backup and transaction backup is running fine. Do I need to be worried?