The great thing about SQL Profiler is that it will allow you to see what an application is doing from a SQL Server point of view even if it is a 3 rd party application and you do not have access ...

The two that really stand out for me here are SQL Agent, so fundamental for scheduling anything with SQL server, and Profiler, which, particularly for an in-house developed application, is like trying ...

Let me preface this by saying my SQL experience is intermediate at best so if I'm usung the wrong terminology or not clear just let me know and I'll try and rephrase my question.We have a SQL 2005 ...