itsdavetime

You're not substituting Me.classname.UserID as a variable. You're passing it in the code as a value itself.

select convert(mydatecolumn,varchar(15),101)

I really have never heard of that driver nor understand what you're trying to do. The question is though, why are you connecting to port 1279? Did you change the port number in the server network utility? If not, it should be 1433.

Not sure what you mean when you ask if you can store the column alias when you create the table. A column alias can be assigned when you perofrm a query on the table.

Just to a while loop. declare @rowcount int, @counter int select @rowcount = (select count(*) from table_name) set @counter = 0 while @counter <= @rowcount begin select * from table_name where rowid = @counter set @counter = @counter + 1 end

You can't drop a user if they are currently logged in. Do an sp_who to find the SPID's the user is logged in with, and kill those spid's. Then drop the user.