Why would this not work?<br><br>import pymssql<br><br>con = pymssql.connect(host='server name',user='username',password='pwd',database='Database')<br>cur = con.cursor()<br><br><br>query="TRUNCATE TABLE Consolidatedmsgs;"
<br>cur.execute(query)<br>print "Table Truncated: %d rows deleted" % cur.rowcount<br>-----------<br>The return I get is that the program runs through but it doesn't actually truncate the table. <br>The user that runs this has all the rights (read, write, truncate, etc...)
<br><br>Any ideas? And yes, I am using a pymssql extension module. <br>