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.
Author |
Topic |
Richard.Fowler
Starting Member
1 Post |
Posted - 2011-04-15 : 16:56:36
|
please helprun 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 @bcpget 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' |
 |
|
|
|
|
|
|