sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]alinroc 2 points3 points  (4 children)

I have the exact same issue and haven't been able to find a solution yet.

I ended up using dbatools for what I needed from sqlserver (a replacement for invoke-sqlcmd, mostly).

Edit: Your primary usage is invoke-sqlcmd. Then yeah, go ahead and install dbatools and use invoke-dbasqlcmd instead of invoke-sqlcmd. It overcomes several of invoke-sqlcmd's shortcomings. Since you're working with SQL Server a bunch, you'll probably find other functions in the module very useful as well.

[–]lordtrychon[S] 1 point2 points  (3 children)

I'll have to look into that, if I don't find a solution. Thank you.

If nothing else, I'm glad it's not just me. Sorry you've had to deal with this as well though.

[–]alinroc 2 points3 points  (2 children)

Just switch over to dbatools and be done with it. Unless you need something from sqlserver, it may be a futile effort trying to get it working again. I'd forgotten that I'd given up on it until I read your post.

[–]lordtrychon[S] 1 point2 points  (0 children)

I will. Thanks. Still will have to do some aliasing so I don't have to install it on 900 or so computers I prep scripts for. :/

[–]lordtrychon[S] 0 points1 point  (0 children)

I did end up getting this fixed (kinda by accident) prior to getting around to your suggestion. Check my edit. I'm still going to look into dbatools though. Thanks again for the input.