Comments
Sort by recent activity
Hi @Jacco,
the rules are stored in `C:\Users\<youruser>\AppData\Roaming\SqlCodeGuard30` as a XML file. You can write a PowerShell in order to copy that file in a shared environment (a source control or else a cloud storage, like Google drive/One drive/Dropbox). Then, everyone must copy that file in its `C:\Users\<itsuser>\AppData\Roaming\SqlCodeGuard30` folder.
I didn't find any "default location" for that XML file. I'd like to change it to set the shared folder, but I couldn't find anything about this setting.
For the moment, we're getting the XML setting file and copying it on a git repo. Then, every team member executes a PoSh script in order to put the file into its user folder. / comments
Hi @Jacco,
the rules are stored in `C:\Users\<youruser>\AppData\Roaming\SqlCodeGuard30` as a XML file. You can write a PowerShell in order to copy that file in a shared environment (a source contro...
hi EsioNunes,
what is the style you're using when formatting? / comments
hi EsioNunes,
what is the style you're using when formatting?
hey @gardner358
we have had the same problem. You've to navigate to the `%LOCALAPPDATA%\Red Gate\SQL Prompt x` (where x is your previous version) and copy the `SavedTabs.db` file into the new folder (SQL Prompt 9). It worked on my side.
hope this helps / comments
hey @gardner358
we have had the same problem. You've to navigate to the `%LOCALAPPDATA%\Red Gate\SQL Prompt x` (where x is your previous version) and copy the `SavedTabs.db` file into the new folde...
Hi @jakkir,
could you please try to check the log file and send us the content? / comments
Hi @jakkir,
could you please try to check the log file and send us the content?
Yes, got it.
However, you can call sp_executesql with param names: EXECUTE sys.sp_executesql @stmt = N'SELECT * FROM dbo.Countries WHERE CountryName = @p0;'
, @params = N'@p0 VARCHAR(100)'
, @p0 = 'USA';
at least, starting from 2008: [image] / comments
Yes, got it.
However, you can call sp_executesql with param names:EXECUTE sys.sp_executesql @stmt = N'SELECT * FROM dbo.Countries WHERE CountryName = @p0;'
, @params = N'@p0 VARCHAR(100)'
, @p0...
hay @buinauskas,
I guess you're speaking about SQL Prompt 9 Rules. You can uncheck the following rule in order to avoid the "issue". It's up to you to manage what rules you'd like to consider. It's not a bug "to be fixed" IMHO. [image] / comments
hay @buinauskas,
I guess you're speaking about SQL Prompt 9 Rules. You can uncheck the following rule in order to avoid the "issue". It's up to you to manage what rules you'd like to consider. It's...
hey @davidsumlin
in order to move the AND right under the WHERE statement you've to set the "Alignment" property, under Operators, to "To Statement": [image] / comments
hey @davidsumlin
in order to move the AND right under the WHERE statement you've to set the "Alignment" property, under Operators, to "To Statement":
hey @davidsumlin
in order to align the table to the field list you have to set the "Align items to the tabs stops", under Lists, to true: [image] / comments
hey @davidsumlin
in order to align the table to the field list you have to set the "Align items to the tabs stops", under Lists, to true:
done / comments
done
I'd like to nominate Alex Yates, too.
The reason is simple, he's helping all the community to understand and to "own" the devops concepts, that are (IMHO) the foundation of a new perspective across the IT. At least it should be :-)
Then, he's contributing into this forum also and, additionally, his clever approach to automation in real scenarios is useful and reliable. As a result, he's one of the most important people to listen to.
Just my two cents.
And thanks @AlexYates, it means a lot for me! / comments
I'd like to nominate Alex Yates, too.
The reason is simple, he's helping all the community to understand and to "own" the devops concepts, that are (IMHO) the foundation of a new perspective across...