April 25, 2002 at 3:21 am
I am using this on SQL Server 6.5
use pubs
go
sp_MSforeachtable
@command1="master..xp_cmdshell 'bcp pubs.? out c:\? /U <user name> /P <password> /S <server name> /c'"
go
but get the error
The identifier that starts with 'm' is too long. Maximum length is 30.
Anyone know what could be wrong??
Andy.
April 25, 2002 at 4:53 am
It is you use of " instead of ' that causes this. Use ' and ' + ' = '' on the inner quoted items. See http://support.microsoft.com/default.aspx?scid=kb;en-us;Q135531 about this.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 25, 2002 at 6:57 am
Thx Antares,
While looking thru the MS site I found a stored proc that creates a bcp batch file. All worked fine.
Andy.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply