Start...Run...TSAdmin.exe

Connect to the machine by name, and as long as you have priviledges, you can see the sessions, and reset them if required. However, I can't remember whether TSAdmin is...

OK, simple solution:

declare @mins int

select @mins = 187

select convert(varchar, floor(@mins/60))+':'+right('0'+convert(varchar, @mins % 60),2)

The above uses a variable to store the minutes, but if you have a table called SomeTable with...

We had massive problems getting DTS to work.

In the end it cam down to each server being able to see each other server by name rather than by IP address....