FISQL: DB-LIBRARY error: Data conversion resulted in overflow

• OracleBoy

  Right there with Babe

  Points: 743

  More actions

  April 12, 2013 at 6:45 am

  #273332

  I use fisql to query my SQL SERVER with this script

  SELECT TOP 10 SUBSTRING(qt.text,1,100), qs.total_elapsed_time/1000000 Elapsed_time , qs.total_physical_reads Disk_reads

  FROM sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) qt

  ORDER BY execution_count DESC

  GO

  but i received this error

  DB-LIBRARY error:

  Data conversion resulted in overflow

  Operating-system error:

  Success

  If i Remove "SUBSTRING(qt.text,1,100)" it's ok :/

  Someone can help me please ?

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  April 12, 2013 at 7:05 am

  #1605943

  The code runs fine in SSMS on my system. Haven't tried it using sqlcmd yet.

  Have you been able to find a site that supports fisql? Your two posts here are the first time I heard of this utility.