is it theoretically possible that two users will login at the same time to the MS SQL server,
so they will have absolutely same values in master.dbo.sysprocesses.开发者_高级运维login_time ?Thanks a lot
It's only a datetime column (not even a datetime2), so it only has ~300 distinct values possible each second. I think you could easily create multiple connections during a period where it stays the same. I'll try to produce a demo, but because it's due to connection start times, it won't be something I can write in just SQL.
精彩评论