Activity overview
Latest activity by DanAvni
Connection to this SQL Server failed
2 servers I have in the database distribution list show a red icon with a tooltip that says the connection to the SQL server failed and I should right click to fix the connection. I am using Window...
Feature request: Remember what was installed
When installing SQL Prompt I am asked if I want to integrate it with SSMS or VS or both. I only use it in SSMS so that is what I select. When running setup for a newer version I am prompted again f...
Smart rename bug: Unable to change casing of a field
If I have a field named GUID and I want to change it to Guid SQL Prompt Smart Rename says I am using the same name. My current workaround is to rename to GuidX and then remove the X and the script ...
How to run SQL Compare UI with parameters
Is it possible to launch SQL Compare UI (RedGate.SQLCompare.UI.exe) and send it parameters for comparison like I can do with SQLCompare.exe?
Feature request: Add intellisense using SQL propmpt
On my machine I have both SQL Multi Script and SQL Prompt installed. Please add support for SQL prompt intellisense when writing queries in SQL Multi Script.
@Jon_Kirkwood, Many thanks for your answer but in my case the SPROC is not compilable when opening it for alter. It is true that fully qualified names might solve it but the purpose is to find invalid existing objects and not re-write everyting only to be able to use the tool. I am not sure how it was implemented but if the tool would have scripted the object for create and try to create it under a temp name, it would fail and this could be detectable from code. / comments
@Jon_Kirkwood, Many thanks for your answer but in my case the SPROC is not compilable when opening it for alter. It is true that fully qualified names might solve it but the purpose is to find inva...
Find Invalid Objects not detecting ambiguous column in stored procedure
Using the latest SQLPrompt I have a SPROC with a query joining two tables. The SPROC is not valid in SSMS when trying to alter it with an error message
Msg 209, Level 16, State 1, Procedure GetData...
@Russell D, Any comments? / comments
@Russell D, Any comments?
I posted under uservoice but when posting there I think this is a bug. The create script folder should script everything. The comparison project can ignore the fill factor or not (Depending on the project settings) but the script creation should script everything / comments
I posted under uservoice but when posting there I think this is a bug. The create script folder should script everything. The comparison project can ignore the fill factor or not (Depending on the ...
Thx. please add this as a feature request for a future version / comments
Thx. please add this as a feature request for a future version