Posts
Sort by recent activity
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...
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...