>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.?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.