Hi I tried the above query on the MS SQL server database. This created a trigger. After that I could not add any login to server.

Below is the Error message.

"An exception occurred while executing a Transact-SQL statement or batch.

(Microsoft.SqlServer.ConnectionInfo)

Implict conversion from data type xml to nvarchar(max) is not allowed. Use the convert function to run this qury.

the statement has been terminated. (Mocrosoft SQl Server, Error:257)"

Can anyone please help me. This needs to be resolved asap.