Hi

It was working fine till the 8th of this month but from then on it stopped starting automatically. i have the LocalSyatem as the login account. never changed any settings.

Thanks

Hi

Thank you very much

Hi

Please refer the following link http://support.microsoft.com/kb/317375. Hope this helps.

Thanks

Hi

Whenever joining two columns of character type ex varchar/nvarchar the collation issue may happen.

Use Where ColA = ColB Collate <Collation Name>

Hope this helps. If you need any more information refer...

Hi Bhuvnesh

select

reg_id = dr.reg_id,

invitee_id = di.invitee_id,

contact_type = isnull(ct.cont_type_name, ''),

item_id = I.item_id,

item_type = i.item_type,

item_category = I.item_category,

item_name = I.item_name,

item_code...

Hi

You can create a procedure and then create a job on that procedure. You can use the OPENROWSET for this purpose in the procedure.

Assuming that the excel file will always...