question

iranbimar avatar image
iranbimar asked

i run this script but there is some errors can anybody help me?

declare @cmd nvarchar(255); -- Please note that the fully qualified table name is needed select @cmd = ' bcp "select CAST(ID AS VARCHAR(1)),NAme from model.dbo.BB row for xml auto, root(''rows''), elements" ' + 'queryout "E:\sample.xml" -S IBIMAR\SQL2008 -T -w -r -t'; exec sys.xp_cmdshell @cmd; > --------------- Err: NULL Starting copy... SQLState = S1000, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Code page 720 is not supported by SQL Server SQLState = S1000, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver]Unable to resolve column level collations NULL BCP copy out failed NULL
xmlbcp
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
That is a collation error. Your database, table, or columns have an incompatible collation with the output you're attempting to generate. Look there first to determine where things are going wrong.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.