Activity overview
Latest activity by gvarol
https://forum.red-gate.com/discussion/85869/sqlprompt-9-5-18-11513-still-misformats-is-rolemember-and-makes-the-sql-statement-invalid#latest / comments
https://forum.red-gate.com/discussion/85869/sqlprompt-9-5-18-11513-still-misformats-is-rolemember-and-makes-the-sql-statement-invalid#latest
SQL Prompt does not recognize IS_ROLEMEMBER function during format (9.5.16.11294)
SQL Prompt formats thisSELECT IS_ROLEMEMBER('db_owner') ;
to
SELECT [IS_ROLEMEMBER]('db_owner') ;Which becomes invalidBelow is some of the other function from https://docs.microsoft.com/en-us/sql/t...
SQL Prompt misformats IS_ROLEMEMBER function (version 9.5.16.11294)
SQL Prompt formats SELECT IS_ROLEMEMBER('db_owner') ;toSELECT [IS_ROLEMEMBER]('db_owner') ;Which becomes invalid.Some other functions from sitehttps://docs.microsoft.com/en-us/sql/t-sql/functions/f...
SQL Prompt misformats IS_ROLEMEMBER function (version 9.5.16.11294)
SQL Prompt formats SELECT IS_ROLEMEMBER('db_owner') ;toSELECT [IS_ROLEMEMBER]('db_owner') ;Which becomes invalid.Some other functions from sitehttps://docs.microsoft.com/en-us/sql/t-sql/functions/f...
it's in the subject of the ticket. / comments
it's in the subject of the ticket.
Also I noticed if there is something wrong in the sql and it fails to format it stull puts square brackets ([]) around ISNULL, QUOTENAME, SCHEMA_NAME etc function, check that out too. / comments
Also I noticed if there is something wrong in the sql and it fails to format it stull puts square brackets ([]) around ISNULL, QUOTENAME, SCHEMA_NAME etc function, check that out too.
SQLPrompt 9.5.18.11513 still misformats IS_ROLEMEMBER and makes the sql statement invalid
SQLPrompt 9.5.18.11513 formatsSELECT IS_ROLEMEMBER('db_owner')toSELECT [IS_ROLEMEMBER]('db_owner') and the sql becomes invalidThe list of sql server functions can be found athttps://docs.microsoft....
Can it be made than we can set a larger timeout if needed and it will not come up with a window in any case. Our servers are remote and metadata is fairly large, over few thousand tables plus views functions and more some having close to 1000 colums each and hundredths of tables with over 3000 partitions each, this is just one database, then there is synonyms etc to resolve. I dont even bother enabling check through linked server option anymore. I might be ok waiting 30 sec or so for it to refresh. A more precise refresh per server/db would be also helpful instead of refresh all. It would be nice to know when refresh is done and how long it took without a popup popup window. I usually have 4 or more seperate ssms running each to work on a different ssms project/solution. I am not sure how the caching works but it seem to be different ssms apps are not sharing the cache. Please consider also this scenario. / comments
Can it be made than we can set a larger timeout if needed and it will not come up with a window in any case. Our servers are remote and metadata is fairly large, over few thousand tables plus views...