May 7, 2019 at 7:26 pm
It isn't honoring the line feeds, carriage return betweeen code chunks - adding into the editor or if pasted from SSMS.
Try one pasted from notepad:
SELECT
sp.state_desc,
sp.permission_name,
p.name,
sp.class_desc
FROM sys.server_permissions AS sp
JOIN sys.server_principals AS p
ON sp.grantee_principal_id = p.principal_id
WHERE permission_name = 'VIEW SERVER STATE'
--after some cr lf...
SELECT
p.[name],
sp.permission_name,
sp.state_desc,
sp.class_desc
FROM sys.server_permissions AS sp
JOIN sys.server_principals AS p
ON sp.grantee_principal_id = p.principal_id
WHERE p.[name] = 'YourTestLogin'
May 7, 2019 at 10:13 pm
It's compressing line feeds into one, removing blank lines.
When you write that it's not honoring them, I think of lines being combined. It does honor a line feed, but removes empty lines, which is a bug.
May 7, 2019 at 10:18 pm
Thanks, yes that's what it's doing. My bad for using the term "honoring", should have phrased that differently.
Sue
May 7, 2019 at 10:35 pm
No worries, I figured it out. This migration has made me painfully aware of how poorly I sometimes describe things to developers. I'm more empathetic to users struggling to express themselves.
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply