ssms

How can I execute a single query in SQL Server Management Studio?

by

I did some searching and was unable to find any keyboard shortcuts for executing individual lines in SSMS. There is a reference online though. http://msdn.microsoft.com/en-us/library/ms174205.aspx Personally I just highlight the row in question (Shift + End or Shift + ↓, etc.) and hit F5. Ctrl + E works just as well on a Mac.

Easy way to convert exec sp_executesql to a normal query?

by

I spent a little time making an simple script that did this for me. It’s a WIP, but I stuck a (very ugly) webpage in front of it and it’s now hosted here if you want to try it: http://execsqlformat.herokuapp.com/ Sample input: exec sp_executesql N’SELECT * FROM AdventureWorks.HumanResources.Employee WHERE ManagerID = @level’, N’@level tinyint’, @level … Read more

How to fix endless reboot loop installing Microsoft ODBC Driver 17 – message: A previous installation required a reboot of the machine for changes

by

I have found one another solution under https://www.youtube.com/watch?v=x9pq3fUOO3s that worked for me when I faced problems with ODBC Driver 17 installation while updating Microsoft SQL Server. It basically requires cleaning the value of PendingFileRenameOperations (replacing the multi-string value with an empty string) under the registry key Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager.

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)