In this video you will learn step by step process of starting SQL Server Profiler automatically after SQL Server services restart. It shows how to create a sample trace using SQL Server Profiler (GUI), how to export Trace settings to a file, how to provide trace location, how to create store procedure from the trace definition, how to execute store procedure to verfiy if trace is running on the SQL Server, how to Mark Store procedure to run at startup in SQL Server, how to enable store procedure startup scan in SQL Server Configuration and finally how to check if the settings are working after SQL Server restarts.
Blog post link for the video
http://sqlage.blogspot.com/2015/03/st...
Visit our website to check out SQL Server DBA Tutorial Step by Step
http://www.techbrothersit.com/2014/12...
Watch video SQL DBA 134-Start SQL Server Profiler Trace Automatically After SQL Server Service Restart online without registration, duration hours minute second in high quality. This video was added by user TechBrothersIT 29 March 2015, don't forget to share it with your friends and acquaintances, it has been viewed on our site 14,053 once and liked it 50 people.