>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.