Yes, I'm aware it is a 2005 forum. I posted here because it was in reply to one of Jeff's posts as a result of a search I did.

The file size is greater than 2GB. Is that the max this method can return? Unfortunately, I'm still on 2000 so CLR is not an option for me.

Jeff -

I adapted your code above and it works most of the time except when I want to get the size of compressed backup files created by Quest LiteSpeed. In...

Just the data. You could do a quick test by creating a database with initial file size at 500MB and then back it up to see the size.

Adrian -

I am curious if you were ever able to find the answer to your question. I am in a similar situation and specifically want to know how the...

I do agree with your point. However, I think one should be careful how he/she approaches the manager on this. You do not want to give the impression that there...

My hobby is teaching martial arts, however, I don't think I would do it for a living because that would require many more students. I prefer smaller class sizes. I...

Ditto on that. It's good for doing quick comparisons of data output from SSMS.

I was actually looking for Vidya to elaborate on his alternate naming convention. Would FK1_, FK2_, etc..., still just contain the table names? Do you prefer this over using column...

Vidya - can you give an example of what you are referring to? Thanks.

You could just add the column name into the new FK definition. That would make it unique.

We keep one week of full backups (one per day) along with t-Logs. We sometimes need to go back in time at a certain point to look at data.

I don't have anything constructive to say, however, I love this metaphor: "...flung from afar by the developer’s trebuchet"

Thanks for all of your input. I'm currently negotiating a table re-design, so hopefully I won't have to deal with this. I will take your ideas into consideration if I'm...

Yes! The problem is with the...