>>Hi,
>> When I save a SP which includes a Openrowsource() statement like -
>>
>> SELECT a.* FROM
>> OPENROWSET('MICROSOFT.JET.OLEDB.4.0',
>> 'Text;Database=D:\textfile\;',
>> 'SELECT * FROM [20060710000#txt]' ) a
>>
>>it always show me error 7405.Any advice? Tks.
>
>>>What happens if you execute this statement in QA/SQL Man.Stud.?
>It's no problem executing it in QA,so i suspect if it be appliable to
>a SP.
What is the error 7405?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.