Try this:SET = 'bcp testing out E:\Martin.Christiansen\FirewallRegler.csv -c -t, -T -S ' + Lumbago My blog->
You are specifying the server name in the -T switch so there is no need for this to be in the database name (unless it's a linked server? is SC2835128 a linked server name?). The login failed.SQLState = 28000, NativeError = 18456Error = Login failed for user 'NT AUTHORITY\SYSTEM'.NULLWhat is wrong?
HiI'm trying to export a sql file to a csv file using following code:DECLARE varchar(8000)SET = 'bcp SC2835128.testing out E:\Martin.Christiansen\FirewallRegler.csv -c -t, -T -S' + master.xp_cmdshell i try to execute this with inside ssms it gives me following error:SQLState = 37000, NativeError = 4060Error = Cannot open database "SC2835128" requested by the login.
We've got lots of great SQL ServerĮxperts to answer whatever question you can come up with.
0 kommentar(er)
