Exactly.  And that's what I meant too.

Jeff said that he'd "still" "say NO".  But, once you've made your objections known, and in writing for the record, and management still decides...

Maybe?:

,(sum(isnull(sc.numberofprocedures, 1))) 'ProcCount'

Your own login must not have SHOWPLAN permissions.  Check to see if someone will GRANT you that permission.

As a DBA, I give that permission to everyone.  I don't see how...

Hmm, ran fine for me, but I'm on SQL 2016.  I think that code should work all way back to 2008, or at least 2012.

We could join to the entire...

;WITH cte_test_data AS(
    SELECT * FROM ( VALUES
        (1,'Not Paid', CAST('7-1-21' AS date)),
    ...

Hi,

I'm in the process of doing a comparison of all the options available:

Scripts Integration Services 3rd Party Tools

We will have hundreds of instances and thousands of databases so need...

Personally, my answer to my boss would still be "NO (with an explanation as to why) but I'll be happy to execute any query under direct supervision after I've...

Sorry, I thought I had posted some possible solutions.  I coulda' sworn I posted that and my response to Jeff earlier but it's obviously not here now.  Wish I'd kept...

The DBA would not be in direct control of any genuine audit process.  It's too much of a potential conflict of interest.  Think about it: the company is/may be doing...

Don't know, since we can't see the code.  Just adding ROW_NUMBER() to a query should not increase the number of rows.

Best would be to create the proc so that it runs as "OWNER", if SQL allows you to do that.  Then the auditors wouldn't need separate permissions of their own.

Otherwise,...

Columnstores perform better because they compress data extremely well.

If you a rowstore that's totally uncompressed, the difference will be massive.  If the rowstore is page compressed, at least it has...

Hi ScottPletcher, I have not seriously considered page compression instead of (N)CCI's as not using any columnstores would require us creating B-Tree indexes to keep query performance sane. In...

Thank you for your answers.

The EXEC command returns the same error, I had already tried this.

I don't want to create the object on the second database, cause my query...

EXEC('SELECT * INTO [SecondDatabase].[dbo].[object_name] FROM [FirstServer].FirstDatabase.dbo.object_name') AT [SecondServer]