tag:blogger.com,1999:blog-37819735.post4347682873274912320..comments2023-11-02T16:16:25.855+01:00Comments on JBs Powershell: SQL queriesJakob Bindslethttp://www.blogger.com/profile/15991115017499294057noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-37819735.post-32215131967119563962009-10-02T00:57:29.670+02:002009-10-02T00:57:29.670+02:00Thanks so much. This was a huge help for me!Thanks so much. This was a huge help for me!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-37819735.post-11858706285829400442008-08-29T17:29:00.000+02:002008-08-29T17:29:00.000+02:00Sorry, I left out a semicolon in the connection st...Sorry, I left out a semicolon in the connection string. Try this instead:<BR/><BR/>$ConnectionString = "Server=$Server\;$Authentication;Database=$Database;"<BR/><BR/>Anyway, thanks again.Kibi78704https://www.blogger.com/profile/07546186956351090202noreply@blogger.comtag:blogger.com,1999:blog-37819735.post-50628184826813241492008-08-29T00:51:00.000+02:002008-08-29T00:51:00.000+02:00Jakob,Thank you so very much for this blog. I hav...Jakob,<BR/>Thank you so very much for this blog. I have adapted several of your functions for use in my QA libraries.<BR/>I have reason to connect to a remote SQL Server, and used your code as a springboard to do so. I am using PowerShell 1.0, .Net 2.0, SQL Server 2005, Terminal Services, and Microsoft(R) Windows(R) Server 2003, Standard Edition (on the client).<BR/>I thought you might be Kibi78704https://www.blogger.com/profile/07546186956351090202noreply@blogger.comtag:blogger.com,1999:blog-37819735.post-20645673580676142602008-08-10T13:07:00.000+02:002008-08-10T13:07:00.000+02:00SQL Server 2008 PowerShell (sqlps.exe) gives us In...SQL Server 2008 PowerShell (sqlps.exe) gives us Invoke-SqlCmd. But one have to install sqlps.<BR/>Still the subject is relevant - several non-PS colleagues has asked about access to data from SCOM command prompt.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-37819735.post-55469841702612990972008-07-28T16:11:00.000+02:002008-07-28T16:11:00.000+02:00Thanks for the suggestion Stephen - however, the p...Thanks for the suggestion Stephen - however, the purpose of the scripts was simply to provide the building blocks for larger scripts.Jakob Bindslethttps://www.blogger.com/profile/15991115017499294057noreply@blogger.comtag:blogger.com,1999:blog-37819735.post-16892504457811473242008-07-25T19:44:00.000+02:002008-07-25T19:44:00.000+02:00You might want to combine all the scripts into one...You might want to combine all the scripts into one larger script. By reusing the connection object, you could easily start a transaction in a query, have it exit the query without committing it (or have an error that leaves it open), and then go to lunch. Since the connection is still open and the transaction is also still open, you might be somewhat annoyed with yourself for blocking other Anonymousnoreply@blogger.com