Failed to initialize sqlcmd library with error number 2147467259 ошибка

I am getting error of Failed to initialize sqlcmd library with error number -2147467259
while running below query, I tried with giving database name also but it is not working getting same error again and again. Can someone help me out in this regards.

declare @subject_line varchar (200)
  declare @sql_query varchar (8000)
  set @subject_line=(select 'Find Highest - ' + convert 
  (varchar(25),getdate(),120))
  set @sql_query=(select 'select a.productname, a.groupid, c.productstatus, 
  releasedate from #tmpa a
  join #tmpb b on a.productname = b.productname and a.prodgroupseqnr = b.maxpg
  left join [Repository_PROD].[dbo].[Product_Info] c on a.productname = 
  c.product_EDP
  order by 1')

  EXEC msdb.dbo.sp_send_dbmail
  @recipients=N'abc@gmail.com',
  @subject= @subject_line,
  @body= 'Hi ,

  Please find attached output of given query .


  Regards,
  SQLDBA_TEAM
  ',
  @execute_query_database = 'Repository_PROD',
  @query_result_header = 1,
  @query= @sql_query,
  @profile_name ='SQLDBA',
  @query_result_width=6000,
  @query_result_separator ='    ',
  @query_no_truncate = 1,
  @query_result_no_padding = 1,
  @query_attachment_filename ='Find Highest.xls',
  @attach_query_result_as_file = 1 ;

I’m trying to update some maintenance plans to make use of Ola Hallengren’s IndexOptimize,
but also mail the result of the operation using msdb.dbo.sp_send_dbmail.

Old T-SQL:

declare @indexQuery nvarchar(1000);

set @indexQuery = 'USE [MyDB];
    SELECT i.index_id, i.name, s.avg_fragmentation_in_percent 
    FROM sys.dm_db_index_physical_stats (
      DB_ID(), 
      OBJECT_ID(N''MyTable''),
      DEFAULT, DEFAULT, DEFAULT) s, sys.indexes i
    WHERE s.object_id = i.object_id
      AND s.index_id = i.index_id;';

exec msdb.dbo.sp_send_dbmail
    @profile_name = 'Local Mail Profile'
   ,@recipients = 'someone@somewhere.co.uk'
   ,@subject = 'Re-index Started'
   ,@query = @indexQuery
   ,@attach_query_result_as_file = 1
   ,@query_attachment_filename = 'Reindex BEFORE.txt'

…and this works perfectly fine.

But if I modify @indexQuery thusly:

set @indexQuery = 'IndexOptimize ''MyDB''';

…to make use of the IndexOptimize procedure, the result is:

Failed to initialize sqlcmd library with error number -2147467259.

I can’t seem to find anything related to the error number anywhere to work out what the problem is.
Can anyone please shed any light on it for me?

Skip to content