Thanks for clearing that up. It sounds like we'd need to stick with the current solution because all of the apps are disconnected. We do use a SessionLockDateTime...

Yes, you are correct. The SessionLockID is either the MAC Address of the PC or (in Citrix or Terminal Services) a Citrix assigned SessionID or Terminal Services Session ID....

Wow, how have I never heard of this? I'm having trouble wrapping my head around this, could you perhaps give an easy "real-world" example of how it might be...

Yes, I've always had it in mind to re-think the key. I like your idea and I'll look into it. We don't use the keys for anything really...

We've used GUIDs a lot in one implementation. This was a time-tracking system and one of the things we implemented was in the Activities table, the PKey was a...

I guess this wouldn't be related to XML or your article, it's more of a Solution.  Use DevExpress' TreeList component or create your directory structure from a single table instead...

Good article, but it's a bit misleading.  This doesn't have anything to do with a Maximum "Page" size, it's a Maximum Row Size.  However, very informative.  Keep in mind also...

Ok, so it sounds like our implementation is fine then.  There is an internal Business Object of the application that stores the "Active User" so we can use the ActiveUser.ID...

The reason for the one (master) Login is because I thought that in order to take advantage of SQL Server connection pooling, the Connection Strings all had to be the...

Ok, so if I am authenticating against a "Users" table for example, I could do what...get a Count(*) of the Logged-in users and if it exceeds the Licensing not Log-in?

I see your point. Since none of the Queries performed on these tables actually use the correct format ("2.0" vs. "2"), then the Query plan is probably converting these...

Well, if you can make it for one table, I can probably modify the Proc to handle any table. Also, I can have the Proc auto-magically figure out the...

Could someone give me an example of how I might be able to import an XML Doc that has this structure? I currently use this structure when Exporting /...

You can't exactly do what you're doing in VB6.  In .NET it might be Ok.

You should change your Procedure to this:

CREATE PROCEDURE dbo.stp_ConvertCharges

 @Errors int output = 0

AS

SET NOCOUNT ON

BEGIN

SELECT...

Oh my god, I cannot believe how long of a solution you've made of this!   Why didn't you first do a search on...