Activity overview
Latest activity by rohan02
Hello, It isn't a permissions issue and when I see a monitoring error I issue a ping from the SQL Mon server to the one it cannot monitor and vice versa and the pings are retuning results. We are monitoring other servers as well and those are all fine so it isn't an issue with the server running SQL Monitor. https://forum.red-gate.com/discussion/87267/monitor-error I hope this will help you. / comments
Hello,It isn't a permissions issue and when I see a monitoring error I issue a ping from the SQL Mon server to the one it cannot monitor and vice versa and the pings are retuning results. We are m...
Hello, To filter out only the GUIDs containing upper case symbols in MS SQL Management Studio, you can use the COLLATE clause with a case-sensitive collation. Here is an example : SELECT YourGUIDColumnFROM YourTableName
WHERE YourGUIDColumn COLLATE Latin1_General_CS_AS LIKE '%[A-Z]%'; Replace YourGUIDColumn with the actual column name and YourTableName with the table name. The Latin1_General_CS_AS collation makes the comparison case-sensitive, and the LIKE '%[A-Z]%' condition ensures that only values with at least one upper case letter are selected.
I hope this helps!
/ comments
Hello,To filter out only the GUIDs containing upper case symbols in MS SQL Management Studio, you can use the COLLATE clause with a case-sensitive collation.Here is an example : SELECT YourGUIDColu...