Thanks Glen for the reply,

After I configure the database mail Under management in SSMS, whatelse I need to do in order to do the database mail complect and how can...

I am sorry I forgort to add one point, we are using exchange server for sending the emails. we created the new email account for sql 2008 in the exchange...

Thank you all

I got the solution, I just changed the datatype of that column to nvarchar and do the insert operation and again change the datatype to datatime. below is...

sorry for messing up the table structure, here is the tables list:

table1:

ID | meat

1 | beef pork

2...

Thank you all for your valuable replies.

Great Regards

Hello,

U r correct, thats the prefered method, but in that method we have to take tail log backup so I am just wondering if it interupts the users...