How can I check the RegisterAllProvidersIP setting and alter it?

Our issue is that NSLOOKUP for AG Listener Name (ZZZDBAG) returns one IP address, sometimes two, and sometimes nothing, which is unusual.

Is it supposed to return only one or two...

• This reply was modified 9 months, 3 weeks ago by  adisql.

These are example IPs.

it's ...../26

It's not a single subnet.

As part of network-level high availability, if one subnet fails, so do the other subnet's services, which is why we assigned WSFC and Listner two IP...

It's not a single subnet.

As part of network-level high availability, if one subnet fails, so do the other subnet's services, which is why we assigned WSFC and Listner two IP...

Why our DNS resolution for "ZZZDBAG" is returning two IP addresses (11.89.12.54 and 11.89.12.98) instead one IP address ?

This is not Azure.

Its  on prem .

Thank you! It works.

Yes, I tried changing the @dt variable from datetime to another string format, but the script doesn't seem to be able to restore.

To add the datetime to mdf...

Thank you Kaj!

That selects if the table has trigger or not.but I am looking for the table has trigger dependency ? I mean if the table used in other table's trigger definition.

Thanks Kaj.

Actually i would like to add  HasTriggerDependency to the select list.

Can you please suggest .

Thank you.

is it possible to  add  Row_Count and HasTrigger to below select list.

Thank you.

SELECT

CONCAT(SCHEMA_NAME(t.schema_id), '.', t.name) AS TableName

, t.create_date AS CreatedDate

, t.modify_date AS LastModifiedDate

, CAST(CASE WHEN EXISTS (SELECT * FROM sys.indexes...

No.

The table and view are from same database .

The table is used in view .

I just want to know if the table is used in view or not.