Thank you for that info. Not quite at the level of detail that I was looking for but VERY GOOD information none-the-less!!

I definitely didn't know about the default traces...

It's not so much that they should not, I'm just trying to verify when. Their access is good.

I've setup auditing for the DB/Table I need info on so, I'll...

I wish it was as easy as sending an email...

I did see an article on setting up auditing but thought there was another option.

Is auditing the best way to capture that or setting up Profiler the way to do...

Thanks Alvin for the follow up.

Yes, there is an expression in the report name:

=SrsResources.Localization.GetString("Report248_Name", User!Language) + " "

I'm not sure how the report name is derived from that expression,...

Thanks Guys!!

Sorry, I've been kind of out of the loop but it would be rude for me not to express my appreciation.

I ended up making some changes in the...

Thank you Kevin!!

I think I need to sharpen my skill on really understanding fragmentation...

Ronnie

Thank you guys for your reply!

So, you're saying that I shouldn't worry about the avg_fragmentation_in_percent number in my result set? I'm trying to setup routine maintenance and just want to...

I'm thinking more along the lines of:

.mdf = master data file

.ldf = log data file

.ndf = "next" data file

🙂 Crazy I know...

I'm actually returning data with single quotes in the string. So, in my query, I'm including a column name "Reason" and the data in that column, pretty much every row,...

While I have your attention, do you have any suggestions on how I can query on a value with a single quote in the middle of a string of text?

Going...

Hi Joie,

Thanks for your suggestion. You are pretty much correct. I figured out the problem to be related to the parameter.

The table has over 40 million rows and one...

Thank you all for your input.

I was able to resolve issue.

It wasn't a straight forward approach but it worked.

The problem appeared to be related to concatenating the result set...

Great Information GoVelo!

Thank you. That's about as close to what I needed as I've gotten.

Thanks Again!

Thank you very much for your advice.

I will look into those options to see how they might work for me.

Thanks again...

Ronnie