Viewing 6 posts - 16 through 21 (of 21 total)
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
January 18, 2010 at 10:03 pm
January 13, 2010 at 2:13 am
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...
January 11, 2010 at 3:24 am
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...
January 11, 2010 at 3:20 am
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...
January 11, 2010 at 2:21 am
Viewing 6 posts - 16 through 21 (of 21 total)