There are tools out there, visio and access are two that work.  but tables and keys aren't going to be your problem.  Triggers, procedures, sequences are were you are going...

I am on old c/c++ programmer, did some java for a while, but recently had the need to do c# for an application.  Just a comment.  It was pretty easy...

I am pretty sure this was in 2000 (although the ".sys." will need changed)

The master.sys.sp_MSforeachdb procedure is good for that.  (however, all it does is the...

It was mentioned that you can't pre-calc the data.  Actually have you considered using temp tables for this.  Most of the subqueries were group by's  That would be perfect to...

In a past life, I had to setup some indexes in a similar way for a database.  It was touched on by an earlier post, but this might help explain...

Can you re-state your question.  I don't think I understand what it is you want Bob to be table to do.   Select (only) from the view but modify on the...

There is no way to do this without dropping and re-creating the table.  There are scripts that will aid you in doing that, but I had to do the same...

I agree.  If the client can't connect, for them it is an outage. 

However, from a measurement perspective I think an outage should be anything within the scope of individual...

First off the command you are using will only recover 5G if you current filesize is 65G.  That aside you shouldn't be getting deadlocks.  Have you enabled Deadlock Tracing? 

I guess I don't understand the point of the post.

I well aware of all of the issues that result when you ship logs from a 2000 instance to a 2005...

Sorry about making assumptions.  I am sure you all have been in those situations where you put a huge effort into something and you are really proud of what you come...

Not that I disagree with any of your points, there is a "Cost" with going to 64 bit.  That cost is that nearly every application that runs in 64bit mode...

Not that it was the point of the OP, but since I added it I should have expected this sort of reply.

However, I will clairify.  I did make an apparently...

Why are you trying to do this?  Not sure what it is that you are trying to accomplish. 

This is not clear, are you modifying the fields in Access or...

sp_help_revlogin.  There is a version for 2000 and 2005, however, I don't know about 7.  Perhaps you could upgrade to 2000 first?

http://support.microsoft.com/kb/246133

Sorry, that's the best I can offer.