I am trying to import an csv file onto a SQL 2005 table. The stored procedure works when I login with my credential. However, the stored procedure fails when I try to schedule it to run. I know it has to do with the credential of the SQLAgent services, but I still don't know how to get around it. Can someone help?
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.