Posts
Sort by recent activity
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.
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...
script folder and index fill factor
When creating a script folder the fill factor is not scripted. how can I change that?
Rename field bug
The rename field generated this sql while renaming RequestId to RequestIdXXXCREATE NONCLUSTERED INDEX [IX_RequestID] ON [dbo].[EmployeeTimeSheet] ([RequestIDXXX]) WHERE ([RequestId] IS NOT NULL) ON...
Deployment Bug
My source table has a column that does not exist in the target. It appears as unmapped in the column selection. Yet when I try to deploy, SQLDC tries to insert null into it resulting in "Invalid co...
How to do one way sync of data using CLI
I have two databases:
one is live data and is holding data for 3 month
the other should hold parts of the data as an archive.
I need to do one way sync from live->archive using CLI but I do need th...