Welcome to Sign in | Help

Re: SQL Express Trigger

  •  02-02-2009, 10:07 PM

    Re: SQL Express Trigger

    Va multumesc tuturor pentru raspunsuri !

    Incerc sa folosesc MSMQ pentru a trimite mesaje.Am gasit aici : http://www.codeproject.com/KB/database/SqlMSMQ.aspx un exemplu interesant. Am facut cred ca tot ce scria acolo (de fapt am executat scriptul,am schimbat numele bazei de date si calea catre SqlMSMQ.dll).Scriptul se executa corect,dar cind incerc sa execut functia uspMSMQSend primesc urmatoarul mesaj de eroare :

    Msg 6522, Level 16, State 1, Procedure uspMSMQSend, Line 0
    A .NET Framework error occurred during execution of user-defined routine or aggregate "uspMSMQSend":
    System.Messaging.MessageQueueException: Invalid queue path name.
    System.Messaging.MessageQueueException:
    at System.Messaging.MessageQueue.ResolveFormatNameFromQueuePath(String queuePath, Boolean throwException)
    at System.Messaging.MessageQueue.get_FormatName()
    at System.Messaging.MessageQueue.SendInternal(Object obj, MessageQueueTransaction internalTransaction, MessageQueueTransactionType transactionType)
    at System.Messaging.MessageQueue.Send(Object obj)
    at WJeziorczak.Sql.SqlMSMQ.Send(SqlString queue, SqlString msg)

    Ma poate ajuta cineva ?

     

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems