i hav 2 databases on an sqlserver. the 1st one contains fulltext catalogs, the 2nd one has a stored proc with a bulk insert statement which access a remote csv file.
for full text indexing to work i think sqlserver needs to be started by a local user, but for the bulk insert statement to work, sqlserver needs to be started by a domain user who has read access to the remote file.
can i solve the problem by starting two sqlserver instances, one by the local user and the second one by a domain user, and hav the two databases on the two instances.
am not sure whether this is the right solution for my problem.
please help.
renjith