Comments
Sort by recent activity
hi @sdks if I've got it correctly, you're looking for a way to check whether SQL Prompt is enabled on suggestions and code analyisis, and then you'd like to disable those two options programmatically: [image] if so, there is a file called RedGate_SQLPrompt_CommonUI_Options_UIOptions.xmllocated into %LOCALAPPDATA%\Red Gate\SQL Prompt 9(because I've the version 9). You can find the two flags on it, as described here: [image] Changing it and restarting SSMS will maybe work (never tried before to be honest). Hope this helps / comments
hi @sdks if I've got it correctly, you're looking for a way to check whether SQL Prompt is enabled on suggestions and code analyisis, and then you'd like to disable those two options programmatical...
usually, when I receive that message there is a toggle for the error message. Without it, It's impossible to understand the reason why your SoC is not sending data. / comments
usually, when I receive that message there is a toggle for the error message.Without it, It's impossible to understand the reason why your SoC is not sending data.
Hi @Alexander_1983, did you try to expand the error detail below the message? / comments
Hi @Alexander_1983,did you try to expand the error detail below the message?
Using VSTS it's possible to query the histories also parametrising the query itself. However I don't know what's your one. / comments
Using VSTS it's possible to query the histories also parametrising the query itself. However I don't know what's your one.
hey @ipelly you can navigate the history of your souce control manager (git? TFS/VSTS? svn?) / comments
hey @ipelly you can navigate the history of your souce control manager (git? TFS/VSTS? svn?)
The same for me. Tried and got GETDATE() on the default render. / comments
The same for me. Tried and got GETDATE() on the default render.
I'd like to wait to update actually, because of my team needs. That said, I cannot get the dates. I'm still getting the GETDATE() layout. CREATE TABLE foo (dd datetime);
GO
INSERT INTO dbo.foo (dd)
VALUES
(GETDATE() -- dd
)
What is the version of your SQL Server? / comments
I'd like to wait to update actually, because of my team needs. That said, I cannot get the dates. I'm still getting the GETDATE() layout.CREATE TABLE foo (dd datetime);
GO
INSERT INTO dbo.foo (dd)...
My version is actually a frequent update version. If you upgrade I don't know if you'll find out it. / comments
My version is actually a frequent update version. If you upgrade I don't know if you'll find out it.
hey ABarthen,
what is the SQL Prompt version you're speaking of? When I write the INSERT statement the default value for datetimes is GETDATE() right now (SQL Prompt 9.1.1.4243). / comments
hey ABarthen,
what is the SQL Prompt version you're speaking of? When I write the INSERT statement the default value for datetimes is GETDATE() right now (SQL Prompt 9.1.1.4243).
Hi @...,
as far as I know, nothing but comparing MSDB database. But I strongly suggest to avoid that way. What about using this tool instead? / comments
Hi @...,
as far as I know, nothing but comparing MSDB database. But I strongly suggest to avoid that way. What about using this tool instead?