Happy New Year all, hope you enjoyed the festivities, and the break (if you got one). I was working most of the days, or otherwise with family, so I can't...

Had to double check that one before I confirmed my answer; trying to be tricky with the first questions of the year, are we Steve? 😉

That doesn't give us a lot to go on. Does this help at all? SQL Server 2019 Installation Error - An error occurred for a dependency of the feature....

Enjoy the New Year all. Got a few friends coming over later, going to play a few games and drink the new year in. Just need to finish getting the...

I really like Thom's answer. I would just consider adding the following to the $Files variable to filter to specific extensions you're looking for:

$Files = Get-ChildItem...

Did you have a question here, or are we missing something?

I agree that Powershell would be far easier, and could easily be executed by an Agent Task in SQL Server if needed. Should look something like this:

$Directory...

SELECT p.ID PRODUCT_ID, 
       p.PRODUCT_NAME, 
       o.ID ORD_ID, 
     ...

Wouldn't you want to use a ForEach loop to process these? You're trying to pass the array to get-sqldbinventory but $ServerInstance is defined as a string, not an array.

I don't...

• This reply was modified 5 years, 10 months ago by Thom A.

Anthony is on the money here. From Servicing Update for SQL Server 2019 RTM:

This Servicing Update for SQL Server 2019 RTM is a non-security GDR release. It is a...

Merry Christmas All, hope you enjoy the holidays (those of you that get them off 😉 ).

Won't lie, I really don't want to go see the latest Star...

Merry Christmas All, hope you enjoy the holidays (those of you that get them off 😉 ).

Won't lie, I really don't want to go see the latest Star Wars film,...

At this stage I have to agree; sounds like you need to invest in a VPN for your clients.

I don't understand what you're asking here. PST is a column already.

hello, my application with vb.net  connect to database though internet, that why ssms can connect though internet. So, i want increase security. I want to disable connect with ssms...