Posted by Erland Sommarskog on 03/07/07 22:24

Connie (csawyer@rwbaird.com) writes:
> exec sp_textcopy @srvname = 'MILNPPRODSQL',
>...
> This script runs with no issue in our Dev environment (which has a
> restore of our production db) but when I run in production I get the
> following error:
>
> The system cannot find the path specified.
>
> I can't figure out what path it is erroring on?? Both servers are
> Windows 2003. The environmental variables on each server is
> identical. Only difference I can think of is that our production
> server is a clustered sql server and our dev server is not....

We don't know what is in that sp_textcopy, but apparently textcopy is
on in the path on the production server. You may have to modify this
sp_textcopy, so that it does not assume that textcopy is in the path.

And, of course, if the production server is SQL 2005, then there is
no textcopy available.

Overall, I am not very fond of the solution of calling textcopy from
xp_cmdshell. If this is for an Agent job, I think it would be better
to do with an Active-X task instead.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]