Activity overview
Latest activity by ggeier2
is_srvrolemember not returning correct suggested values
In SQL Prompt, the function is_srvrolemember is not returning the correct suggested values (and sadmin isn't valid).It should suggest:
sysadmin
serveradmin
dbcreator
setupadmin
bulkadmin
securityad...
I've tried to use the SQL History for quite some time now, but it just doesn't work. The tab history was perfect. But in History -- I can't find anything, it's a mess. Will there be any issues with me downgrading? I am using ssms 18.12.1 and SQL Prompt 10.13.15.3135. / comments
I've tried to use the SQL History for quite some time now, but it just doesn't work. The tab history was perfect. But in History -- I can't find anything, it's a mess.Will there be any issues with ...
Thank you for the response. What I was looking for was a little different. I took a screenshot so it can be seen easier: [image] / comments
Thank you for the response. What I was looking for was a little different. I took a screenshot so it can be seen easier:
How to align datatypes with spacing in a table, stored procedure, or variable declarations?
How can I align data types? For example, SQL Prompt currently formats this table as:<div>create table dbo.some_table</div><div>(</div><div> some_id int identity(1, 1) primary key clust...
Using SQL Prompt with multiple windows logins
I have a few logins that I use to connect to different types of systems. I have a different windows login that I use for for dev, preprod, and prod. I run SSMS by using the "run as" and enter my cr...
Awesome! This works perfectly. Thank you! / comments
Awesome! This works perfectly. Thank you!
Thank you! / comments
Thank you!
Yes, that's correct. There are no more valid suggestions after typing "set statistics time". But also, there are incorrect suggestions, so I end up typing the wrong SQL unless I remember to hit "esc" to close out of SQL Prompt. / comments
Yes, that's correct. There are no more valid suggestions after typing "set statistics time". But also, there are incorrect suggestions, so I end up typing the wrong SQL unless I remember to hit "es...
The SQL is:
set statistics time, io on; / comments
The SQL is:
set statistics time, io on;