Haw large are the differentials?

It must be Friday, and I must be tired.

We have a few Azure SQL databases in an Elastic Pool. Not a managed instance.

I have to execute scripts on all of...

My son uses that for his live gaming feeds.  It has given me the willies from day one

Can you post the table definition?

Your original post list the columns you want included in your clustered primary key and that looks like a very wide clustering key and...

Thank you Mr. John for the reply

I will first stop the front end application so user cannot change anything on the database. Then will take a back up file...

Can this be done with a populated table with 24MM rows and 130 fields? I keep getting errors that the tempdb is full (?) I tried copying the table,...

You do  not have to pause the availability group to make a backup.   Are you currently taking backups, in which case you can simply send them your most recent backup?

Once...

Well, considering that PL-SQL and T-SQL are different especially from a perspective of built-in functions, this will not work.

I copied and pasted this code into SSMS, and checked the syntax....

Ah... didn't see Mike post while I was typing.  I also meant to say that once you're sure the code it produces is correct, change the PRINT @sql to...

Maybe this?

DECLARE @SQL nvarchar(max)
SELECT  @SQL = 
STRING_AGG( 
CONVERT(NVARCHAR(max), 'GRANT EXEC ON [' + S.name + '].[' + O.name + ']  TO [udr_db_FocusOneUserRole]'), ';'  ...

Well, you can.  You will need to select each SQL statement generated into a variable, and execute that.

That can be done by building one large string of commands, and executing...

Thanks, Michael,

The query works fine, and it shows my list of Stored Procedures. It does not seem to 'execute' this Query as a part of my script though.

What am...

Generate the code with a query

SELECT  
'GRANT EXEC ON [' + S.name + '].[' O.name + ']  TO [udr_db_FocusOneUserRole];' 
FROM sys.objects O
INNER JOIN sys.schemas S...

Seems crazy but it's gotten to the point for a whole lot of folks where they need a "conductor" for the "symphony of automation" they've constructed to make sure...

Yes, the query looks exactly like you mentioned, Michael. I like the idea of splitting by usage scenarios, especially where there seem to be a couple of the more...