Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 1 year ago. Improve this question Table get locked when called an SQL Server SP from pyodbc Python I have a table I made for testing called test. I just want
Tag: tsql
Does not detach database by sp_detach_db in pyodbc
I am trying to detach the database, but for some reason it does not detach with no error, am I missing something? SQLServer 2012 version: 11.0.2100 pyodbc version: 4.0.31 Answer Thx for Gord Thompson for the tip. Fixes: SET SINGLE_USER WITH NO_WAIT -> SET TRUSTWORTHY ON Remove from connect params “Trusted_Connection=yes;”, It associates the system user instead of “sa” user.