if you bother to look at the results of the index definition you will discover why its null.

and get used to use alias on the tables - makes your life...

if you do your clustered index as you...

you really need to read the manuals for MySQL - datediff in Mysql is totally different of that for SQL Server hence the error you get.

in mysql you would need...

all the SP's on...

Cyberark if used...

there is documentation for it - https://docs.cyberark.com/Product-Doc/OnlineHelp/AAM-CP/Latest/en/Content/CP%20and%20ASCP/Net-Application-Password-SDK.htm?tocpath=Developer%7CCredential%20Provider%7CApplication%20Password%20SDK%7C.NET%20Application%20Password%20SDK%7C_____0

as in powershell you can use any .net dll's its just a question of setting up a script to do it.

I may be able...

Hello @bobrooney.81 the solution to your problem is quite easy: Start thinking by your self. Then switch to https://ola.hallengren.com. There you find every necessary information about your problem.

But hey:...

I believe your only solution for this is to setup a SQL Agent job that executes the SSIS package (with a defined proxy) and introduce a SP to allow your...

what will that package do?

• Access file system (on another server or locally to the server - if remote it won't work)
• access remote database (if so it will require...

what is that proc doing?

and what are you trying to accomplish (end target)

as it resides on SSISDB I would suspect you are trying to start a package execution - and...

@databases = 'USER_DATABASES,db1,db2', -- USER_DATABASES will do all user db's including db1 and db2 - if your intention is to backup only db1 and db2 then your strings should be

@databases...

as you have been advised on other similar queries you need to implement a storage of these metrics onto a table at a point in time - and then build...

you need to dig through all tables, views and functions that query uses.

it is highly possible that one of them has a filter on the users (common for MS CRM...

while the package is running its normal that the row counts is different - writing to a file is a lot faster than loading to a remote oracle database.

counts that...

Oh, I get...