Software Development

Thursday, November 23, 2006 - Posts

• EXECUTE permission denied on object 'xp_cmdshell', database 'mssqlsystemresource', schema 'sys'.

  Run the below command with sql login "mysqllogin" Declare @str nvarchar(4000) Set @str =N'BCP KodyazDB.dbo.Brands out c:\export.txt -S PCKodyaz\yukon –U mysqllogin -P myloginpwd' Exec master..xp_cmdshell @str   Msg 229, Level 14, State 5, Read More posted Thursday, November 23, 2006 3:19 PM by eralper | 0 Comments Filed Under: SQL

• BCP command fails because of "Unknown argument 'ûU' on command line"

  The below command is sent to me via Outlook email message. I connected to my local server using my windows user account as system administrator.   Declare @str nvarchar(4000)Set @str =N'BCP KodyazDB.dbo.Brands out c:\export.txt -S PCKodyaz\yukon Read More posted Thursday, November 23, 2006 12:14 PM by eralper | 0 Comments Filed Under: SQL