Viewing 15 posts - 1 through 15 (of 17 total)
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...
September 2, 2009 at 7:15 am
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...
September 2, 2009 at 5:42 am
Thats why I used char(91) and char(93) it wouldn't matter what the table name was then.
April 19, 2006 at 10:07 am
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...
April 16, 2006 at 11:05 am
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...
April 13, 2006 at 8:23 am
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.
April 13, 2006 at 8:16 am
Do I win ?
April 13, 2006 at 8:04 am
Try this :-
@sSql AS NVARCHAR(4000)
@StupidTableName AS NVARCHAR
April 13, 2006 at 8:00 am
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...
October 11, 2005 at 8:40 am
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...
October 11, 2005 at 12:30 am
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...
October 10, 2005 at 2:10 am
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...
August 1, 2005 at 3:24 pm
Sorry its a in-memory temp table until it get too big, then its stored in the temp database.
Looked at yours liked the way...
July 26, 2005 at 6:24 am
temp tables... boo hoo.
July 26, 2005 at 5:48 am
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...
July 26, 2005 at 1:54 am