to fix this problem: remove temp files from %temp% folder (C:\Users<user name>\AppData\Local\Temp) open the register and remove “HKLM\SOFTWARE\WOW6432Node\Microsoft\Microsoft SQL Server Management Studio” or execute via cmd (with admin rights): reg DELETE “HKLM\SOFTWARE\WOW6432Node\Microsoft\Microsoft SQL Server Management Studio” /reg:32 run install with admin rights NOTE: Just for those who don’t know register just open CMD as an […]
Tag: management
sp_help for SQL Server Management Studio
If you have SQL Server Management Studio, open it up and execute sp_help ‘dbo.TableName‘. See which column that FK is on, and which column of which table it references. And also that code will let you see many details about Target Table. You can use the same with shourtcut ALT + F1 as well.
