Finally, a technical term with which I'm familiar! 🙂

Apparently the UID filter is by design; the vendor's notes in the code "explain" why:

--Only do tables owned by dbo. Otherwise,...

Well...I hesitate to put the whole proc here since it's the vendor's code and I don't want to get in trouble, but here's the part that tells me it's only...

Thank you for the link! This whole thing makes a lot more sense now. So basically, shrinking the database is what's fragmenting the indexes, and the Rebuild Indexes step is...

You read my mind! I just ran a query on the views' indexes, and here's the fragmentation I came up with:

94.2108174245345

97.9705280822277

97.8662604798711

99.1450259688374

99.1922024167167

I don't know much about fragmentation, but I'm going to...

Thanks to you both for responding! Could either of you explain to me what negative effect shrinking the database would have on performance? I want to be able to explain...

Hi, Bulbanos:

Thanks for the reply! Unfortunately, I tried setting the interval to 10 million (setting it to 1 million results in too many tick marks since the total is so...

Thanks, Craig! I'll readily admit that my understanding of loops in T-SQL is limited at best; I have more experience with looping in VB. Your logic makes sense to me;...

Hi, Wayne:

Sorry, I guess I should have been more clear on what the purpose of this is. Students register for the fair months in advance, so when their records go...

Thanks for the quick response! I guess what I'm struggling with is how to increment the "a", "b", "c" part within each project. How do I make sure that the...

Ugh. Oh, well, it was worth a try. I ended up just using a ForEach Loop to send a separate email to each individual recipient. I was hoping for a...

That's what I thought. I just need a way to get around that; this email has the potential to have to go out to over 100 people, so 256 characters...

Hi, Alvin:

Thanks for the quick response! I ran the stored procedure in Management Studio, and it's not getting cut off there. In the stored procedure, the email list parameter is...

Hi, Jack:

Thanks for the response! I'm waiting for one of the users to get back to me with the exact error (all I've gotten from them so far was "a...

Hi, Luke:

Thanks for responding! I tried your suggestion, but unfortunately, it's giving me the same error. Any other ideas?

Hi, Steve:

I added a boolean variable called isCurrentLog and placed it in the ReadWriteVariables of my Script Task. I changed the script code to this:

Public Sub Main()

...