I have to save all the access to the SQL server, so I'm using traces. I use stored procedures (xp_trace_addnewqueue,xp_trace_setqueuedestination , etc...). I want to save all data in a remote table in other server. I have spent a lot of time trying it by I cant do it, the stored procedure xp_trace_setqueuedestination don´t create the table in the remote server. Need I a special account to do this in the remote server?
Other question: SQL Server is too expensive to buy another license Can I use another sever to saves this data, as PostgreSQL or MySQL ?