I don't think your agent account is the problem here (although I do not recommend using an account with Domain Admin privledges).  Check your scheduled jobs that run your DTS...

If you are wanting to view current users, use sp_who2.  If you are wanting an ongoing log of user connections, you will have to set your SQL Server's security audit...

Use Raiserror.  Use with log if you want the error to appear in the log file.

select @count = count(*) from test_tbl

IF @count > 0 

    raiserror('Your Error Message Here',16,1) with...

"Since SQL Server 2000 does not provide functionality like Row_Number(), I am taking a variable of type Table with an identity column. I am pusing all the relavent data into...

Look up sp_rename in BOL.

Your biggest problem is that, not only are cursors inefficient, you are using nested cursors.  I would suggest finding a set based solution to your problem.  I will take a...

Joe, Peter's set based solution is a much better approach to using a loop of any kind.  There are many, many posts and articles on SSC detailing the benefits of set...

What does your execution plan show?  I would guess that it is doing an index seek based off of your WHERE clause and that the delay is the lookup of...

It looks to me like your colleague has found a set based method to his UPDATE where most people would have created a cursor.  While his code may be a...

I'm a little unclear on what you are asking for.  If you just want to limit your groupings by only grouping A, B when c = 3, then just do...

It is a little unclear on what you are asking.  What do you mean by 'Transition'?  What is your role in the 'Transition'?

Not only is it unsupported, but I think it may even void your support for that licensed copy.

Yes, Vladan is correct.  If you use your example data in my example, you will not get the results you show in your example. 

declare @table table (mydate datetime)

insert into @table

select '01/01/2005' union all

select '02/20/2005' union all

select '03/20/2005' union all

select '04/01/2005' union all

select '05/04/2005' union all

select '01/01/2006' union all

select '02/01/2006' union all

select '03/04/2006' union...

What datatype are your columns?  You are either using char() or you are using varchar()

and the application is inserting the trailing spaces.  Either way, use trim to display them...