bcp copy in failed
Few days back , we have faced the issue regarding bcp in, message was bcp copy in failed. Although Rows were inserting successfully. The user which We were using that was dbo of database and had all
permissions.
We tried with other login id and it was working fine, that was dbo alias.
We tried to remove user, added as dbo alias, given explicit permission,but it didn’t work out.
It was totally weried as there was no problem at all , or you can say the issue which we were not able to
investigate as error is not much explanatory.
Also I would like to mention , we have refreshed this database from 12.5.4 to 15.0.3 env.
Finally we dropped the user, dropped login account and added again , means we craeted new login account
with same name and after that added in db as a dbo alias. It worked fine now.
I am still not sure why this caused the issue.
Anurag has more than 6+ years of experience in Sybase Database Development .His Area of expertise includes Performance, Query Optimization, Cost Optimization, TSQL Development. He is also involved in Consultancy to Financial Firms for Database Implementation and Maintenance. He has supported many Global Financial firms.