Helping out a developer get to the bottom of an issue, I was running profiler against his connection, and saw the following
INSERT BULK <tablename> <columnlist>
no indication of the data that was being passed.
Not being entirely sure what this was, I cut and paste this into a query window in SSMS, executed and got
Command(s) completed successfully.
later noticed that this connection was showing in
sp_who2 as SUSPENDED.