I appreciate your broad explanation.  To be honest, I created the mileage table just as a simple example because the actual situation was more complex; so, I agree it does...

Thank you Drew and Scott for the feedback.  This is the first time I have used DateTime2 instead of DateTime . Drew.Allen: I changed the ValidFrom and ValidTo to be...

Thank you both so much for the assistance. I will look the code over to see if that resolves my problem as well as improves my understanding of the...

Hopefully even though this is a reply to an old post; I hope someone may read it and assist me in understanding what I am doing wrong to find the...

Were you ever able to find an answer to this. I have a similar need where my customer wants a report of items and then at the end an index...

I must say that I have never heard of a hex code attack; so, thank you for causing me to look into that.

My recommendation is layering. If...

Very nice. I needed some code to find the number of occurrences of more than one character and I found that all I had to do was add a...

Thanks. That was my next move.

Good article to grow by, and very much look forward to Part 2.

So basically, it just should not be done for control, organization, and sanity sake within the structured environment that we so like to construct for ourselves, but does not have...

Is it on server start or database engine start?

Ahh yes.  I see I was confusing fixed db roles with server roles.  Hate when that happens.

Is it the speed that makes this question correct; because I can right click and get a complete list of the permissions for fixed roles?

Intresting article.  Thank you Yousef.

I have one concern using this in SQL 2000.  If you need to make sure you reset the Context_Info at the end of the procedure and...

SQL Server Version=

Microsoft SQL Server  2000 - 8.00.2039 (Intel X86)   May  3 2005 23:18:38   Copyright (c) 1988-2003 Microsoft Corporation  Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)...