I have a stored procedure which generates a few files and stores it in a particular location. When I change the location to another drive I get this error.
THE ERROR NUMBER IS 7321
THE ERROR MESSAGE IS:An error occurred while preparing the query "select * from \\VM_FILESERVER\it$\SFPC FL Citizens Takeout Data\SFPC FEB 2014 TAKEOUT4_21_2014_51218357\SFPC_FEB_2014_TAKEOUT_4_21_2014_POLICY_DETAILS.TXT" for execution against OLE DB provider "MSDASQL" for linked server "(null)".
Can some one help me out with what might be the reasons that are causing this ?
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.