powershells remove-item

"Expanding the table"

Do you mean in SSMS, in object explorer when trying to expand the table to get the columns/indexes etc

If so what timeout did you actually get?

Was it the...

Depending what you need you could look at the default trace.

It captures object:created object:altered object:deleted events, but it doesn't give you the T-SQL used to do the creation or alter.

You'd...

First question in any and all auditing requirements is

Does this audit need to be legally binding?

Like if it's related to HIPPA / GDPR etc etc data, and you have to...

If its all installed right you can see the IS Catalog folder

Ensure you have all the BI stuff here selected.

Any issues with SSMS need to be reported to that link otherwise Microsoft won’t know of the bug.

As for 15.0.2120 that’s your build number of the version of SQL you’re...

Make sure you are reporting this on the MSFT feedback page so that they have visibility of the bugs you're encountering also.

https://developercommunity.visualstudio.com/SSMS

aka.ms/ssms-feedback

Secondaries cannot do differential backups either.

So if you have failed over to a secondary and a differential backup hasn't occurred yet on the secondary, it won't report as having done...

Some reason the site didn't like me posting both bits of information together in the same post, had to split them.

It is also worth upgrading to the latest copy of VS 2022 and SSIS 2022 projects.

https://marketplace.visualstudio.com/items?itemName=SSIS.MicrosoftDataToolsIntegrationServices

The action plan would be to upgrade to VS2022, SSIS2022 projects and swap all your...

SQLNCLI11.1 is now depreciated, it is advised to switch to MSOLEDBSQL instead.

https://learn.microsoft.com/en-us/sql/relational-databases/native-client/applications/installing-sql-server-native-client?view=sql-server-ver15

The old SNAC and new OLEDB can be found in the link above.

Yes, the CDC job should be running 24x7x365 if it is in continuous mode so it is always reading the T-LOG to keep it as trim as possible.

Ensure that the SQLAgent has been setup correctly also to use mail.

If you have not set the Agent properties Alert System to use DBMail and the profile and restarted the...

DECLARE @SQL NVARCHAR(MAX)

SELECT @SQL = (
SELECT 
'USE ' + QUOTENAME(name) +';' + CHAR(13) + CHAR(10) +


/*Put you per DB query in this segment*/
'SELECT ' + CHAR(13) +...