They do not really do the same thing, right?

I think Vault is a password safe, and CyberArk...

If I misunderstood and you want the alarm noticiation flag to control the selection criteria, then it's best to use two separate queries instead of trying to cram everything...

If you have created an availability group, then you would typically be connecting to the listener, not the individual server.

You are not going to be able to name more than...

If you are connecting to the AG with the linked server, then you simply connect to the listener. If the AG is connecting to other servers, then you set up...

• This reply was modified 4 years, 1 month ago by Michael L John.

Did you check out this thread?

https://www.sqlservercentral.com/forums/topic/memory-optimized-tables-cross-db-access

Make that user sysadmin, and see what happens.

If it runs, then it's something with permissions,

If it fails, then it's something with the configuration of SSRS/SSAS

Thanks for the feedback, Grant.  I am concerned.  While I wouldn't expect such a thing to be "radical" in a test and development environment, seeing "some" thrash...

At more than passing ability in most of these areas, this says $150k a year.

Not...

Well, it seems like you would need the max date/time for the checkin, and the same thing for the checkout on a per user basis.

If the check in date/time is...

This is the same person...

• This reply was modified 4 years, 1 month ago by Michael L John.

This may give you what you want, or get you close.

SELECT 
MAX(QS.last_execution_time) LastExecution,   
COUNT(*) ExecutionCount, 
DB_NAME(ST.dbid) DatabaseName, 
OBJECT_SCHEMA_NAME(ST.objectid, dbid) as [Schema_Name], 
   ...

I'd go with either Extended Events (much less overhead than Trace AND can be filtered on capture which Trace can't do) or Query Store. If you want to capture...

The parms and values where concatenated into a string...

Add code to the start of the proc to log to table.  While you're at it, you might as well log all the parameter values as well,...

Add code to the start of the proc to log to table.  While you're at it, you might as well log all the parameter values as well, if you...