Dear,

If it is on the different domain, try using the sql user instead of domain user account (windows login).

Gavin Lilley posted the solution... read it care fully...

I copied the same...

1 - On the remote server (Subscriber server) run the following sql statement

SELECT CONVERT(char(20), SERVERPROPERTY('servername'));

and...

Hi Brian,

Very nice article. I was able to configure the auditing but I am not getting the parameter values in the audit.

Ex. If some executed a query as follows:

select...

Hi Brian,

Very nice article. I was able to configure the auditing but I am not getting the parameter values in the audit.

Ex. If some executed a query as follows:

select...