I have a question regarding Bulk Insert and how it processes and connects to the import file.
I have heard that SQL Server 2005 cannot bulk load from a network folder. My understanding is that Bulk Insert also runs using the SQL Server Agent account.
Are these correct statements?
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))