sys.partitions reference in SQL causing heidi to abort

gilblais posted 5 years ago in Running SQL scripts
SELECT SUM(rows) FROM sys.partitions WHERE index_id IN (0, 1) AND object_id = object_id('ClerkBase_SandBox..BoardsPositions');

causes this:
computer name : EGIL-PC
user name : george
registered owner : georgesnap@outlook.com
operating system : Windows 8 x64 build 9200
system language : English
system up time : 16 hours 56 minutes
program up time : 8 minutes 53 seconds
processors : 2x Intel(R) Pentium(R) CPU G3220 @ 3.00GHz
physical memory : 2115/4013 MB (free/total)
free disk space : (C:) 422.41 GB
display mode : 1440x900, 32 bit
process id : $16b0
allocated memory : 50.27 MB
largest free block : 131029.99 GB
executable : heidisql.exe
exec. date/time : 2014-08-31 04:22
version : 8.3.0.4813
compiled with : Delphi XE5
madExcept version : 4.0.8.1
callstack crc : $2ef15873, $7160003a, $7160003a
exception number : 1
exception class : Unknown
exception message : Unknown.

main thread ($e70):
00a70f1a heidisql.exe dbconnection 2294 +47 TAdoDBConnection.Query
7ff93314 WS2_32.dll recv
7ff91ecf DBNETLIB.DLL ConnectionRead

Please login to leave a reply, or register at first.