How can I run a trace on some SP's in my database, I get an error that I must be sysadmin fixed server role or have the ALTER TRACE permission?
It is not possible to run a trace against the databases we host as this requires administrative rights that cannot be granted on our shared servers.