Whilst trying to carry out a bcp from within SQL server 6.5 with the
following command line structure
EXEC master..xp_cmdShell "bcp database.dbo.table in 'filepath'
/f'formatpath' /e'errorpath' /Uusername /Ppassword /Sserver"
I get the following error
Cannot find the function 'xp_cmdShell' in the library 'xpsql60.dll'.
Reason: '127(The specified procedure could not be found.)'
I have not been able to find out what this means but have not been able
I am using the account as a non sa and have permissions to execute
xp_cmdShell. Apparently the sa has run xp_cmdShell within the database
server and it works OK.
Any help would be appreciated.
Sent via Deja.com http://www.deja.com/
Before you buy.