June 18, 2008 at 8:37 am
Hi all,
First, let me say that I inherited this code. Whew! Now, with that taken care of.....
We have a procedure in our program that opens the database, inserts a record and closes the database. And when we have 6000+ records to import you can imagine this takes a long time. Leaving the database open for a long time doesn't seem to be a viable option because then if some other part of the program attempts to access the database we get a native exception (0xC0000005) error.
What I'd like to be able to do is put some sort of trigger in the database so that when a certain file is found to exist in a certain directory, the database would then do something like a DTS operation and import all those records quickly. Is something like this even possible?
Thanks!
June 18, 2008 at 8:52 am
See http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/30138/ this could be adapted
June 18, 2008 at 8:52 am
See http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/30138/ this could be adapted
June 18, 2008 at 9:24 am
Not sure if this is possible, but you might ping Steve Lasker. He worked on the Compact team.
August 19, 2008 at 2:33 pm
Just now having time to look at this issue again. Boy, if my work life could stay focused on one issue at a time it'd be a lot easier. 😉
Anyway... just wanted to say thanks for the answers. I'll be looking into your suggestions further. 'preciate it!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply