14,494 questions
Hi Erland, hi Cathyji,
We've reinstalled Python services in SQL Server and that resolved the issue, SSMS now consistently returns results of Python scripts.
Python in Management Studio - print statement - missing result
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 10%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPK%3C/text%3E%3C/svg%3E)
piotr krudysz
16
Reputation points
Hi all,
I'm running the simplest Python script in SQL Server Management Studio:
exec sp_execute_external_script
@language = N'Python',
@script = N'print("hello")
'
but the results are outright inconsistent.
Sometimes I get:
"STDOUT message(s) from external script:
hello"
other times I get:
"Commands completed successfully."
It's totally random.
Why is this so? This compromises any hopes for running Python in SQL Server for us.
SQL Server 2017
SSMS v 18.2
Many thanks in advance.
SQL Server Other
{count} votes
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator2022-05-23T21:46:17.803+00:00 That's quite an old version of SSMS. Download the most recent version here.
What does "SELECT @@version" report?
-
piotr krudysz 16 Reputation points
2022-05-24T11:05:21.537+00:00 Thanks Erland,
I've installed SSMS version 18.11.1 and there's still exact same issue.
I am connecting to a remote SQL Server, select @@version reports:
Microsoft SQL Server 2017 (RTM-CU29) (KB5010786) - 14.0.3436.1 (X64) Mar 18 2022 13:21:03 Copyright (C) 2017 Microsoft Corporation Developer Edition (64-bit) on Windows Server 2012 R2 Datacenter 6.3 <X64> (Build 9600: ) (Hypervisor)
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
2022-05-24T21:00:43.317+00:00 I asked about @@version, since it is far too common to see posters who run very old builds, but you are on the latest CU, so that is good. I did not really expect the version of SSMS to matter, but I pointed it out nevertheless.
I am not able to reproduce this, but I'm running against my local instance, and I don't really have a remote instance at hand here at home to try with.
I can't say why you get this inconsistent result, but I guess it is some timing issue.
But I'm curious why you find this to be a concern. Normal use of a Python script from SQL Server is that you pass it a data set and you get a data set back. Print statements would possibly be for debugging.
Sign in to comment
2 answers
Sort by: Most helpful
-
-
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff2022-05-24T08:09:25.84+00:00 Hi @piotr krudysz ,
I test this in my environment, it works well in my environment. Run this scripts many times, only get one result. I am using SSMS 18.11 and SQL server 2019.
Suggest you using the latest SSMS 18.11.1 as Erland mentioned. If it is still not work, please let us know.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
-
piotr krudysz 16 Reputation points
2022-05-24T17:45:33.16+00:00 Thanks Cathyji-msft,
I've upgraded to SSMS 18.11.1 and still the same.
-
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff
2022-05-26T08:23:37.747+00:00 Hi @piotr krudysz ,
I could not reproduce your issue. Could you share us a screenshot about your issue?
Sign in to comment -