I changed from LoginName = SYSTEM_USER to LoginName = CONVERT(varchar,SYSTEM_USER) and that did the trick! Any ideas why that solved the problem?

Is this what you're looking for? The window procedure may call this several hundred times based on settings for the user.

SQL2000

|--Nested Loops(Left Semi Join, WHERE:([t_SumInventory].[SiteID]=[SiteSecurity].[SiteID]))

...