You might be able to use xp_cmdshell to execute osql commands for each of the separate script files.

This assumes that your scriptlets do not have to share any variables or...

I would be leery of using massive string handling in a function against a large dataset.  How about a table-driven solution?

create table Candidate_Evaluation (

   QualificationID   int not null primary key...

The next question would be about the current directory the command is run under.  When I run "xp_cmdshell 'CD'" on a server, the result is C:\WINDOWS\system32.  Was that the current...

The environment of something running under xp_cmdshell is not identical to the environment you see in a command shell.  Run "SET" in a command shell, and compare the output to...

Microsoft has some good webcasts and free courses on their web site.

That might be a fine piece of equipment (I have no idea), but using any NAS device for your data files means you have network bottlenecks between the server and...

In DTS a single data pump can be used to load data from multiple sources by being modified at run-time using ActiveX Scripts. How can the same be accomplished using...

I just ran into this myself with a new server, you have to manually configure the DTC service.  Even though it is running, it won't do anything until you slap it around.

Before you give up on Winzip (if that's what you have to work with), try again at a lower compression level.  The highest compression level is a proprietary format, but...

The PRINT statement in a trigger is only there for testing & development.  Under no circumstances should it be part of your application.  I understand having FoxPro or Access or custom...

Using SELECT inside a trigger may work, but it is a worse crime against nature than using Access as your front end for this kind of development & testing.  You...

I want to be there when you explain to a client that their 5-million name mailing will be a few months late and you're going to charge them for thousands...

My first work with triggers involved working with some very robust-looking code (written, of course, by someone long gone) that had all kinds of error handling built into every trigger. ...

The PRINT command will work if you're in Query Analyzer, but it is a message and not part of the data results.  Access isn't expecting extra messages, and I'm not even sure...

I use a tool called ActiveGender from The Software Company that would work for you.  I got the ActiveX version a while back ($250, no recurring fees) but they now have...