Just would like to give more information about the issue…whenever we are calling sp_send_dbmail for sending an email with attachment, under our application transaction….sometimes msdb database moves into suspect...

Just would like to give more information about the issue…whenever we are calling sp_send_dbmail for sending an email with attachment, under our application transaction….sometimes msdb database moves into suspect...

We have checked the same and looks that some issues related to implementation of the same. I dont think that Re-start is the solution to the problem :). We cant...

I have done in some other way and was looking for something like the same. I will execute the same and check if the same works. Some one told me...

I am trying to paste the xml content here but the site is now allowing me to do so.

Hi Jerry

thanks a lot for the same.

Cheers

Siddarth

We also have the same understanding so we are not getting why we are not getting the right value. I think we need to analyse again and need to ensure...

It appears from the records in db that we are not getting the correct value. Is that possible that some other transaction is also inserting the value after our insert...

I have gone through the link and came to know that it will log the details for all tables in DB. We do not need logging for all the tables,...

we are using sql 2005

thanks for the link

thanks a lot for the same.

SID

Thanks alot for the same. Due to security constraints, I am not able to open the same at work place. I will go through the same and will get back...

Thanks alot for the inputs.

Thanks alot for the inputs. There is lot of material available on net and its difficult for me to know which one is good.

there is a sql job which runs in once every night which has openrowset.