RESOLUTION: Yes regular sql or  even as powershell hardcoded without parameters it works. However, just found resolution. Use pure powershell. While i couldnt find an exact example, i just tried...

Thank you Jeffrey. Your last paragraphs are exactly what i'm trying to do.  I will test those. I"m copying ps scripts to the server on which they need to run....

Thank you so much. I'm trying to automate sql server configurations. Part is already done by powershell. The powershell executes several scripts. The objective is to have a standard ssis...

ok. Thank you!

Good afternoon!

I was able to get the attached PS somewhat working. It does insert data into my table, however, gives me the below error messages.

Would you happen to know how...

My apologies. I will send as soon as i can. i did come a bit closer with different parts i've found here and online. I'll post what i have soon.

Hi!

I'm no really sure I am doing this correctly. I am not running anything by database and already have an existing table. The first one attached is what I tried...

Thank you! I will try this out today!

No login codes or passwords.

I am receiving the same error with Windows 2012. The below link referencing a KB helped with one server but not another.

https://www.mssqltips.com/sqlservertip/2492/why-is-sql-server-configuration-manager-missing-services/

Hi Johnny,
All transactions take as long to rollback as it did to run. How big is the database?
I would check to see if anything is blocking it...

Thank you. How do the targets know which the master is? The targets show the named server as master. However, when they will failover, the master may be unavailable and...

Ok. Thank you so much for your help! 🙂

Ok. Thank you.

I was trying to change the IF to a CASE.

CASE WHEN @Variable IN ().

Thanks again!

Ok. I'll try that. Thank you!

When I run it on a mirrored server in which it has a mixture of Principal and mirrored databases, it brings back only the names...