Stack Overflow
Stack Overflow

Questions tagged [red-gate-sql-prompt]

Red Gate SQL Prompt is an add-in for SQL Server Management Studio and Visual Studio intended to ease the development of T-SQL code.

12 questions
5
votes
2 answers

Redgate SQL Prompt equivalent for PostgreSQL database

I'm starting at a new company after coming from a previous role where I could rely on Redgate's SQL Prompt with a MySQL environment. I'm now working with a Postgresql environment (SQL Workbench/J) and was wondering if anyone had come across any…
Ben Saunders
  • 929
  • 10
  • 20
5
votes
3 answers

SSMS 2012 System.OutOfMemoryException (client side) and SQL Prompt (debug info incl)

Some background: I've been encountering this memory exception within SSMS 2012 since it was released coupled with Red Gate's SQLPrompt (this exception never happens in my SSMS 2008R2 on the same laptop). I was originally encountering these…
artofsql
  • 613
  • 4
  • 11
2
votes
0 answers

Not able to view the Database Diff Report in Azure Devops Build pipeline

I was able to use the Redgate Ready Roll extension in Azure Devops Build and Release Pipeline. Everything was working fine till 8th April,2019. Now, suddenly I am facing below challenges. I am not able to view the Database Diff Report in…
nikita kakraniya
  • 141
  • 2
  • 14
2
votes
3 answers

How to disable visual studio intellisense just in SQL Query?

I have a redgate [sql prompt] extention intellisense on visual studio 2013 ,when I am type in SQL Query the two intellisense appear see the below Image , So I want to disable the visual studio intellisense Just in SQL Query [Not in all visual studio…
Osama AbuSitta
  • 3,918
  • 4
  • 35
  • 51
1
vote
1 answer

Redgate SQL Prompt - how to reformat all files in source control repo

Redgate SQL Prompt has a great feature of being able to reformat any open sql query, however I've got a large schema source controlled in SQL Source Control, that has a real mix of standards that I would like to harmonise. It would be too much work…
Neil P
  • 2,920
  • 5
  • 33
  • 64
0
votes
1 answer

Why do I keep getting Incorrect usage of const UDF in SSMS?

I keep getting warnings in SSMS (using v17.7) and RedGate SQL Prompt: Incorrect usage of const UDF It underlines SYSUTCDATETIME() The following underlines SYSUTCDATETIME() in both places SELECT 2 FROM (VALUES (CAST('2020-06-26' AS…
Daniel Leach
  • 5,517
  • 4
  • 18
  • 32
0
votes
1 answer

Redgate failing to compare schema between different versions of SQL Server

I am trying to compare the data and schema using SQL Compare and SQL Data Compare (version 10.2). The databases I am working with are in versions 2014 and 2016 of SQL Server. I am getting this error message. Any idea why this is happening - could…
t_plusplus
  • 4,079
  • 5
  • 45
  • 60
0
votes
1 answer

SQL tool to list the related tables to the parent table

Dears, Could you please help me to find a SQL tool that will show me the list of the tables that have relation with the parent table. Example: Select * from table_1 when I write join there will be listed tables that are related to the table_1…
Mylinda
  • 1
0
votes
1 answer

How to get RedGate Sql Prompt to work in SSDT project?

I am working on a SSDT project and I would like to use intellisense and snippet support of RedGate Sql Prompt, but I am unable to get that working. All I get from SqlPrompt is the name of the database and my snippets, nothing about the tables. What…
haku
  • 4,105
  • 7
  • 38
  • 63
0
votes
3 answers

How can I alter SQL Prompt settings to not auto-correct a phrase?

I have SQL Server Mgt Studio, and have the red-gate SQL Prompt plugin. For most cases, it's amazing and makes life easier with most auto-corrects, but I'm using a specific database called offset, but it'll always auto-correct it to OFFSET because…
mlh351
  • 319
  • 1
  • 3
  • 14
0
votes
1 answer

SQL Server Management Studio autocomplete behavior

I have SQL Server Management Studio 2008 with SQL Prompt 5. When I type in a query, and hit enter, the cursor jumps backwards to the middle of the word. If I type SELECT * FROM and then select the table name from intellisense, this does NOT…
Ethan Schofer
  • 1,718
  • 5
  • 26
  • 55
-1
votes
1 answer

SQL Prompt error

I tried two versions of Redgate SQL Prompt, but there are no result, with SQL Server 2014 no version works. Here is the error: The loading of the 192.xxx.xx.xxx server failed because of Database version 12.00.2000 not supported Can anyone tell me…
Arkadi
  • 1,153
  • 1
  • 14
  • 35