Sorry... I thaught you knew how to grant permissions with tsql .

I'm gonna be delaying a lot after this one .

Anyways, I think 26% is not a lot. Thge fact is that you...

I have no ida why she sets so many variables... and she didn't provide enough information. So looks like you'll have to wait on this one

That's you bottlenck. Change this task to a bulk insert using dts.

You could import all the files, then start working on validating/splitting.

Then you'd just have 11 insert queries to...

Just forgot something... make sure that the trigger only fires on the first update. I assume here that you are updating a column in the same table where the...

You can add another update trigger if you want. But I would make sure that it fires after the first one. Look up sp_settriggerorder in bols for more...

Here's a little view I put up for an ADP releasing software (releases are made often due to many hotfixes).

It select the procs and functions that do not have deny...

Same here... working only 4 hours today. So I only have 26 minutes to go now .

Or does he mean with the system tables??

Looks like I didn't go to school long enough .

Thanx for the tip.

How are importing the files anyways?

She's going to Pluto to get some ice. I choose to go in my Freezer. Takes less time. .

It's her choice...

You'll have to debug the procedure... I can't help you on that part. You'll have to figure out what's hapenning.

Is the error coming from the files, or from the import?

I'm still looking at it and I still don't get it... can you share the idea behind this technic?