Comments
Sort by recent activity
Using the SQBServerSetup.exe, as I'm very accustomed to doing, is a worse experience...
There are no passwords for gMSA logins, so when I use that dialog, I'm immediately confronted with a requirement for a login AND a password. "No can do..." is my response to that. Cancel and go back to good-old local Windows Login, which is a royal pain to set up in Windows Server 2016 (thanks MS!).
I'm up and running, but I also had to negotiate the "not a server principal" when SQB was up and running with the local login and the SQL Service with the gMSA. So, I added the gMSA as a SQL Login and granted it sysadmin role. Backups still failed: 1/16/2018 7:24:47 PM: Backing up master (full database) to:
1/16/2018 7:24:47 PM: G:\SQLBackups\master\FULL_<Server>_master_20180116_192447.sqb
1/16/2018 7:24:47 PM: Error 880: BACKUP DATABASE permission denied in database: (master)
1/16/2018 7:24:47 PM: SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'RS\XXXSQLService$' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission.
That's when I changed the SQL Service to also use the local admin login, and, per normal, everything just works.
Despite Microsoft stating that for YEARS gMSAs can be used with SQL Server, the reality, unless (very likely) we missed some crucial configuration re the gMSA, is that gMSAs aren't really 100% compatible...
We would dearly like to use them for security reasons. If we missed something (this is the first time using any gMSA for our I.T. Manager or myself, accidental DBA) we are all ears! / comments
Using the SQBServerSetup.exe, as I'm very accustomed to doing, is a worse experience...
There are no passwords for gMSA logins, so when I use that dialog, I'm immediately confronted with a requirem...
A solid "maybe" on that one, Jessica. I updated to the latest SQP 9.1.1.4243, but I don't have any bandwidth at this time to tinker while fighting performance issues faced by a Tier-1 Client.
Sorry to disappoint, but it will be a few weeks (the issues are MANY!) / comments
A solid "maybe" on that one, Jessica. I updated to the latest SQP 9.1.1.4243, but I don't have any bandwidth at this time to tinker while fighting performance issues faced by a Tier-1 Client.
Sorr...
Turned "it" on in SSMS 2017 v17.5 - SQP 9.1.0.4138. I'm now restarting SSMS because it became unresponsive - utterly unresponsive. You can guess what's being PERMANENTLY turned OFF! / comments
Turned "it" on in SSMS 2017 v17.5 - SQP 9.1.0.4138. I'm now restarting SSMS because it became unresponsive - utterly unresponsive. You can guess what's being PERMANENTLY turned OFF!
Hi Michael
Thanks for the reply.
db is at 87.7MB, and includes an 11M row resultset as I write.
Other plug-ins, yes, and have had them for almost as long as SQP: ApexSQL Refactor, SentryOne Plan Explorer.
Our database object size may be considered to be on the large size, and with each connection, master is a given, but usually one of these large databases is retrieved for SQP. Raw SELECT COUNT(*) from sys.objects gives 26,237; columns is 52,855; sysconstraints is 11,104, if that's any kind of guide.
I have "Manual Refresh" on, BTW.
Happy to give you any other stats, logs, etc.
I'm now on 9.0.2.3223 / comments
Hi Michael
Thanks for the reply.
db is at 87.7MB, and includes an 11M row resultset as I write.
Other plug-ins, yes, and have had them for almost as long as SQP: ApexSQL Refactor, SentryOne Plan Ex...
One of my co-developers has this, too.
I'm about to post ANOTHER big bug re the new SMELLY CODE SMELLS feature... SQL Prompt Log File for typical day available - no ERROR Messages or Exceptions are associated with this 100% CPU eating behavior. / comments
One of my co-developers has this, too.
I'm about to post ANOTHER big bug re the new SMELLY CODE SMELLS feature...SQL Prompt Log File for typical day available - no ERROR Messages or Exceptions are ...
Actually, my preferred behavior would be to have it treated like an exec of any user procedure - expand the signature when I tab after the last letter of sp_executesql
Well aware of the other options re scripting - have only been using the sp for 13 years!
A snippet will do in lieu of preferred behavior and fiddling around to try and get the Ctrl+ keys or right-click-blows-up.
Signing off this thread. Cheers. / comments
Actually, my preferred behavior would be to have it treated like an exec of any user procedure - expand the signature when I tab after the last letter of sp_executesql
Well aware of the other optio...
krzysztofkroczak wrote: »
Hi @PDinCA,
It is still possible to inline execute statement in your script. You can do it from the context menu (right mouse click "Inline EXEC") and the shortcut [CTRL+B, CTRL+I] is still available.
Do you have some issues with this shortcut?
Best regards,
Krzysztof
krzysztof - Yes, v9.0.2.3223 in use. Opened new Query Window. Typed sp_executesql. Tried CTRL+B, CTRL+I and nothing. Highlighted, repeat keys - nothing. Added EXEC, repeat keys - nothing. Right-click context menu features "Inline EXEC" but SQL Prompt Errors on using it- see attached image.[image]
Made it executable:
DECLARE @SQL nvarchar(4000);
EXEC sys.sp_executesql @SQL
No dice, not even an error this time. Maybe I'm just using the feature wrongly, as it isn't in a procedure...? (There's no shortcut key-combo on the right-click menu, BTW) / comments
krzysztofkroczak wrote: »
Hi @PDinCA,
It is still possible to inline execute statement in your script. You can do it from the context menu (right mouse click "Inline EXEC") and the shortcut [CT...
@buinauskas Appears RG started to give us this "Unwrap" sp_executesql ability, but it looks like it stalled back in November 2016 in v7.3. PITY! V9 doesn't respond to the Beta's Ctrl+B+I combo.
Maybe a few more up-votes might kick-start it... https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/4013363-unwrap-sp-executesql / comments
@buinauskas Appears RG started to give us this "Unwrap" sp_executesql ability, but it looks like it stalled back in November 2016 in v7.3. PITY! V9 doesn't respond to the Beta's Ctrl+B+I combo.
M...
Save to a network drive it is... I'll read the post you helpfully provided and see if I can get it to work...
Many thanks! / comments
Save to a network drive it is... I'll read the post you helpfully provided and see if I can get it to work...
Many thanks!
Needed to have our sys admin cook up a .reg script to enable the UNC access and needed to run it on all machines that would access the .chm - after that all is well provided the shortcut uses the UNC file path, not the mapped network drive letter :oops: . / comments
Needed to have our sys admin cook up a .reg script to enable the UNC access and needed to run it on all machines that would access the .chm - after that all is well provided the shortcut uses the U...