Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 script error

Author  Topic 

Richard.Fowler
Starting Member

1 Post

Posted - 2011-04-15 : 16:56:36
please help

run this

DECLARE @bcp varchar(255)

SELECT @bcp = 'BCP "SELECT DisplayName,PIN, MailboxSMTPaddr, ModelName, Appsver,PhoneNumber, IMEI, HomeNetwork, ITPolicyName FROM USERCONFIG A JOIN SyncDeviceMgmtSummary B ON A.ID = B.UserConfigId" queryout \\ c:\temp\BBUsers.csv -c –U"sa_blackberry" –P"XXXXXXX" -Sushousql01'

EXECUTE MASTER..xp_cmdshell @bcp


get this

Unknown argument 'c:\temp\BBUsers.csv' on command line.
NULL

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-04-15 : 17:06:26
SELECT @bcp = 'BCP "SELECT DisplayName,PIN, MailboxSMTPaddr, ModelName, Appsver,PhoneNumber, IMEI, HomeNetwork, ITPolicyName FROM USERCONFIG A JOIN SyncDeviceMgmtSummary B ON A.ID = B.UserConfigId" queryout c:\temp\BBUsers.csv -c –U"sa_blackberry" –P"XXXXXX" -Sushousql01'
Go to Top of Page
   

- Advertisement -