Can master.dbo.sysprocesses.login_time have the same values?
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.
精彩评论