My schema works like so....

UserMap = GUID, SPID, AppUsername

When a connection is established to the db.

Conn C = new Conn();

C.Execute("DELETE FROM UserMap WHERE SPID = @@SPID");

C.Execute("INSERT INTO UserMap (SPID,AppUsername) VALUES...

Hmmmmm... maybe on occassions the spid->username map fails to write and the exception handing is allowing future transactions to continue..

I'll do some further digging..

Is there something fundamentally wrong with what...

Thats why I used char(91) and char(93) it wouldn't matter what the table name was then.

In SQL 2005 you don't have those issues because you can use NVARCHAR(MAX).

Basically the proceedure spits out in 4 parts so you could write a front end which takes the 4...

run the sp_who2 command on the SQL Server to try and see how many users are running on the database server. 

use the kill (spid) to remove any connections which...

No outlook is a mail client and doesn't require any configuration to receive emails.

SQL server on the other hand does require a MAPI profile to be able to send emails. 

Have...

Do I win ?

Try this :-

DECLARE

@sSql AS NVARCHAR(4000)

DECLARE

@StupidTableName AS NVARCHAR

Adam can I also ask the overhead involved on large SQL Server databases which use lots of temp-tables?

i.e. If the bowling site was to be used by 100,000's of concurrent...

I didn't realise this would happen when I posted the solution.

From what I can tell I didn't sl@g anyone off, Just pointed out about the use of temp tables...

To be honest.. I don't give a flying poop.. Temp tables suck.

I presume you done some work with execution plans / indexes to make your findings fair ?

Or did you run...

This is a friendly community.

If your willing to post a solution you must be willing to take critism.

I never claimed that my solution was in fact 'THE BEST'.. Ive always...

Sorry its a in-memory temp table until it get too big, then its stored in the temp database.

He he..

Looked at yours liked the way...

temp tables... boo hoo.

My Solution used 3 functions and 1 stored proc, used the original table.  I added a game id for testing and presumed scores would be entered in order.. I know...