Background
Data for the statistics object are gathered using a statement of the form:
SELECT
StatMan([SC0], [SC1], [SB0000])
FROM
(
SELECT TOP 100 PERCENT
[SC0], [SC1], STEP_DIRECTION([SC0]) OVER (ORDER BY NULL) AS [SB0000]
FROM
(
SELECT
[TextVa...
You're triggering my trying to get dimensions on may cardiac measurements into my data dictionary. There's not Unicode for every superscript. Also, they decided there is a ^2.7 in some cardiac measurement
@JukEboX could use a little more context mate. Which database system? Do you have an example query? (I'm not sure what is meant by "Trigger for the WHEN Statement".)
@J.D. Sorry. New to this chatroom. Writing a SQL Trigger for amount of user connections. in the If statement for each WHEN I can put in a user and a connection count
But the example someone sent me only shows "domain\user" THEN 20 for the connection count
Is there a way to use "Domain GROUP" because I don't want to have to make a line for everyone one of our DBA admins and users
@JukEboX no worries. It sounds like your question is a little involved and probably would be best served if you want to ask it on the main site instead. Tagging which database system and version you're using, and providing the example you were provided would be helpful there.
As a general insight, if you're using Microsoft SQL Server as your database system, then likely whatever reference is being made to the domain User can be done to a domain Group instead.
I am creating a trigger in SQL Server 2019 to secure the amount of connections users can have into my SQL server. I am having an issue getting my SYSDBAs access using the domain group. I would rather do this instead of identifying every single user in the trigger.
How do I identify the group in t...
Background
Data for the statistics object are gathered using a statement of the form:
SELECT
StatMan([SC0], [SC1], [SB0000])
FROM
(
SELECT TOP 100 PERCENT
[SC0], [SC1], STEP_DIRECTION([SC0]) OVER (ORDER BY NULL) AS [SB0000]
FROM
(
SELECT
[TextVa...
