Posted by Connie on 03/08/07 18:23

On Mar 7, 4:46 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Connie (csaw...@rwbaird.com) writes:
> > Erland, The reason I am doing this is to extract a blob from a sql
> > server table and store it into a location on our server. Here is what
> > is in the sp_textcopy:
> > CREATE PROCEDURE sp_textcopy (
> > @srvname varchar (30),
> > @login varchar (30),
> > @password varchar (30),
> > @dbname varchar (30),
> > @tbname varchar (30),
> > @colname varchar (30),
> > @filename varchar (30),
> > @whereclause varchar (40),
> > @direction char(1))
> > AS
> > DECLARE @exec_str varchar (255)
> > SELECT @exec_str =
> > 'C:\Progra~1\Micros~1\MSSQL\Binn\textcopy.exe /S ' + @srvname
> > +
> > ' /U ' + @login +
> > ' /P ' + @password +
> > ' /D ' + @dbname +
> > ' /T ' + @tbname +
> > ' /C ' + @colname +
> > ' /W "' + @whereclause +
> > '" /F ' + @filename +
> > ' /' + @direction
> > EXEC master..xp_cmdshell @exec_str
> > GO
>
> > I believe that I must be having some sort of right issue on the
> > Production server where I am now trying to run this. It works
> > perfectly in Development.
>
> No, it's not a permissions issue. But it would be as simple that on
> the production box, SQL Server is not installed on the C disk. Or
> that the 8.3 name for C:\Program Files\Microsoft SQL Server is
> different. The first thing to try is replace the 8.3 parts with the
> long names. Next is to check where textcopy is located on the
> production server.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx- Hide quoted text -
>
> - Show quoted text -

Did all of that already, checked the location of the textcopy.exe and
it does exist in the same location on dev as it does on production. I
tried using the long names and the short name both, still same
results... I have basically gone through and verified everything and
compared production to development, I am just frustrated right
now....Thanks for all the ideas and help though I am open for all and
any suggestions....

[Back to original message]