Using SQL Profiler on shared ISP

As I'm just starting to work with Entity Framework I realise you have to spy on the sql to have any chance of knowing what's going on, my question is though, my db is hosted by a commercial ISP, I've got no chance of running 'Use Master/Grant Alter Trace To xxx', is the only way to switch between my own local db and the remote?
Who is Participating?
Marten RuneConnect With a Mentor SQL Expert/Infrastructure ArchitectCommented:
Unless you can ask for a trace from your ISP, I think your'e right. You'll need to redirect it to use a database where you have control. Then use the Profiler.

Im not sure about the question. You seem to have grasped everything and I can only confirm.

The only way around is to build triggers in your database, and use them to store information in some sort of log table.

Ryan McCauleyConnect With a Mentor Data and Analytics ManagerCommented:
Without implementing a layer of logging in your application (and the overhead that brings), I think you're stuck. Your best bet is to set up a dev/test environment somewhere that you have control over (like your local machine), and then run profiler there. Most hosts wouldn't want you connecting profiler anyways because of the extra overhead involved, so it's highly unlikely that they'd allow it.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.