>another thing,
>how do i work with the table ? as i normally would with any or any special case ?
>does it take manual transactions ?

As with any other table. However do that with a stored procedure (you could create temporary stored procedures same way - prefix with 2 sharps).
You know I actually still think OpenRowSet() is a better and easier way. If it's local firewall wouldn't be a problem.
Cetin