SharePoint University

Hello,

I am using C# vs2005 and sql express 2005 and I want to be able to make a web part that will show all the users that are currently online. I found a tutorial for it here:http://blogs.sqlxml.org/bryantlikes/articles/592.aspx but the forum has been dead for some time now. When I upload the web part I get an error stating "Keyword not supported: 'userid'" so at first I changed only my sql connection to say User Id but then  I changed each instance of the word and I am still getting the error. I have deleted the web part and uploaded it again from scratch and I am still seeing the error I am not sure if it has to do with the sql code or if sharepoint is caching that web part somewhere. If anyone is able to help me figure out what changes I need to make to the sql query or if its just something in sharepoint I greatly appreciate it. 

I fixed my caching problem but I do have a question about the Hit_add after alter proc but that is more of a sql question however if someone could help me or if this does have to do with sharepoint I would like to know what the updated syntax for it is.

create table ActiveUsers (
UserID varchar(50) not null,
LastHit datetime not null,
LastUrl varchar(256) not null,
constraint PK_ActiveSessions primary key clustered
(
  UserID
)
)
go
alter proc Hit_Add
(
@Url varchar(256),
@UserID varchar(50)
)
as
-- this needs to be changed to the userID
-- that your site runs as
if (@UserID = 'DOMAIN\PROCESSID') return
insert into Hits values
(@Url, @UserID, getdate())
delete ActiveUsers
where UserID = @UserID
  or datediff(mi, LastHit, getdate()) > 30 -- minutes
insert into ActiveUsers values
(@UserID, getdate(), @Url)
go
create proc ActiveUsers_Get
as
select UserID, LastHit, LastUrl, datediff(mi, LastHit, getdate()) Age
from ActiveUsers

go

 there is a standard web part called SITE USERS

i think that works. not tried it though