Archive for April 22nd, 2013

SQL Server Management Studio shows result tab that does not match the query

April 22nd, 2013

I couldn't figure out why my SQL Server Management Studio (SMSS) would show results that would not match the query underneath. They all looked like results for sp_who and sp_lock, system stored procedures that can be used for fetching information from SQL Server.

It turns out that, by default, ctrl-1 and ctrl-2 are assigned to run sp_who and sp_lock. Since the shortcuts for switching between PC's on my KVM switch are set to ctr-alt-1 and ctrl-alt-2, I would regularly get this issue without really understanding what was going on.

If you want to get rid of this, simply go to Tools, Options, Keyboard and clear the text for the keys that you accidentally press once in a while.

Posted in Sql | Comments (0)

SEO Powered by Platinum SEO from Techblissonline