Ali,

I've handled this using DTS by creating a Working table like Mark suggested and setting up my flat file as a txt or xls file source. I run through scrubbing and...

Ben,

Brian's query works because of the set-based nature of SQL. The looping that you describe is all handeld behind the scenes for us. Thanks for helping out with this one.

Jim

Brian and John, thank you guys for providing this. I hadn't used the

SELECT @Attribs=@Attribs+Attribute+', ' FROM Table2

syntax in a long time and had forgotten about it. This works perfectly...

yuk! that's what i was afraid of.

Thanks for your help, Ben.

Thanks for the suggestion, Ben. Unfortunately, there can be any number of attributes for each order.

Thank you for the clarification.

As was stated earlier, you have to set up a regular transaction log backup plan. BOL says:

"When SQL Server finishes backing up the transaction log, it automatically truncates the inactive...

SQL Profiler has a SQL Transaction available in the "Available Event Classes". This tracks the BEGIN, COMMIT, ROLLBACK, SAVE statements associated with transaction.

There is also the Transaction Log option...

"For reading the Transaction Log, I've heard that Lugiment's Log Explorer is good."

Lumigent Log Explorer is a very useful tool. However, if you have very large log files or log backup...

Do you have an end date set on the schedule?

I'm a little confused on why you are converting the @scanDensity to a varchar for comparison with the Scandensity decimal value. i've never seen that before.

case when ScanDensity > '...

What is the schedule of your package set for?  (how often, what days, etc.)

It looks to me like you are hitting the second "Then 9 -- eliminate from consideration" in the case where the clustered index is greater than the density you specify...

Thank you for the reply...Yes, both sa and BUILTIN/Administrators are set up on the server. SQL Agent runs under a windows account set up for that machine. That account was also...

You cannot assign a table an owner that does not exist in that database. It might be possible that the bmssa login you were seeing as the owner was an...