Thanks for the reply Steve.

The 2 jobs are running the same proc - so yes they are using the same linked server. I don't see a related property of the...

Thanks again PaulB.

I don't have any better feel at the moment for how many databases fit in each category - but I get the point of the exercise - the...

Thanks SA.

My 3rd party or native question was really to get at the robustness of the native solutions given our situation - many databases, some very large, distant geographic locations,...

Thanks for the reply PaulB.

I'd say we have around 500 - 600 databases.

Good questions...I'd say no they won't all have the same BC requirements.

There will be som that...

Thanks guys. Good reads.

Also, the more I pondered this it occurred to me that since SQL Trace uses stored procedures, that implies that it would run in the sqlservr.exe process.

For posterity...

I overlooked a simpler answer. I was using a comma as the field terminator and some of the data legitimately contained commas. The row limit is not 2000, I...

Thanks for the reply Steve.

It appears sp_helpdb returns the "allocated" size, just like the sysfiles table. I've never peeked at the backup tables, I can do that, but it just...

Congratulations to Steve and the other founders. And particularly to all the folks who take the time to answer questions and post articles. I owe alot of what I know...

In fairness to the AD guys, whether it's them or us, someone's putting these folks in groups. Truth be told, I've never minded because I like the increased visibility /...

Thanks for the reply.

Yes, I'm aware we can do that but for whatever reasons the Active Directory team preferred that the SQL team manage the roles / groups.

Ok, I found the answer in this post: http://weblogs.asp.net/anjanaram/archive/2005/05/03/405434.aspx. Thank you AnjanaRam for this post.

from the post:

"For other system tables , it really doesn't matter if the stored...

I lived in Denver for five years - from late 97 to early 03 - and am planning to move back within the next couple of years. We didn't spend...

Steve, thanks for the suggestion - I'll take a look.

Commuting costs are making a huge dent in our family budget.

A few years ago, opting for the lower housing costs, more land, etc...we moved quite a ways from my...

great detail, that was big help!