Figured.  Thank you.

Last Physical Hardware environment has to be close to 6-7 years ago!  Do sometimes miss the 'old' days of installing OS and settting up and configuring the boxes. Currently running...

This was resolved. It was an open port issue and the order of it.  All good.

Just following backup on this.  I still don't have any resolutions on it.  Again, trying to setup Transactional Replication in SQL Managed Instance from DatabaseA to DatabaseB in the same...

SELECT

CASE

WHEN

FULLTEXTSERVICEPROPERTY('IsFullTextInstalled') = 1

THEN

'INSTALLED'

ELSE

'NOT INSTALLED'

END

Can just loop through the DBs

Thank you for your response and totally agree with it.  Always goes back to improving slow running queries and to decrease the amount of logical reads.  I haven't seen -5 ...

Hello, it can be an option.  The current process is to bring the XML into a SQL table first and then parse the XML into our data model with some...

We currently insert into a table the XML file into an XML column data type field.

Thank you.  I will check on the Business Critical tier.  Currently trying to resolve to resolve, "2021-11-16 16:15:35.08 Failed to connect to Azure Storage '' with OS error: 53.' with...

I am looking to replicate most or all of the tables from Database1 in SQL MI Instance 1 to Database2 in SQL MI Instance 1 (same instance).  We want to...

I end up removing all the SQL Views before creating the Extract .dacpac.  I found about 20 older DB Objects that wouldn't compile because of schema changes.  I was able...

Is there a way to continue on errors?

I was finally able to restore most of the databases from SQL Managed Instance to a Local SQL 2019 Instance.

I used Visio Studio 2019 to 'Extract Data-tier Application (.dacpac).  I...

• This reply was modified 3 years, 7 months ago by  DanielP.

Thanks Steve. This is Daniel P.  I am using Visio Studio to generate the .DACPAC file because you can uncheck 'Verify extraction' so it doesn't error on other database dependencies. ...

• This reply was modified 3 years, 7 months ago by  DanielP.

I found an article that states to create a 'Scope' Credential but I think this applies only to Azure SQL Database.  The workaround I have is to use Microsoft Azure...