Post reply

Failed to initialize sqlcmd library with error number -2147467259

  • March 5, 2015 at 3:24 am

    #315167

    Hi

    When running the following query

    EXEC msdb.dbo.sp_send_dbmail @profile_name = 'Profile'

    ,@recipients = 'EMAIL@EMAIL.COM'

    ,@Subject = 'TEST EMAIL'

    ,@Body = 'TEST EMAIL'

    ,@Query = 'SELECT GETDATE()'

    I get the following error...

    Msg 22050, Level 16, State 1, Line 0

    Failed to initialize sqlcmd library with error number -2147467259.

    However it works fine from another user.

    Both users are sysadmin.

    Is there an obvious issue I am missing?

    Using SQL 2014 Enterprise.

    Thanks

    Sam

  • March 9, 2015 at 12:28 pm

    #1782677

    Are you running it from the SSMS? If you are check to see if the studio opens by default into SQLCMD.

  • March 10, 2015 at 5:55 am

    #1782853

    Hi Kevaburg

    No it does not.

    Sam

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply