April 18, 2003 at 9:54 am
I have a vender supplied vb/com/SQL package. I make changes to a test system, troubleshoot,then make the same changes to a live system. The changes I make are via their forms that hit lots of stored procedures and update numerous tables... Is it possible to record (similiar to the trace process) what is happening to the test system and to "replay" these actions in the live system? Something similiar to recording a macro on a mainframe emulator.
Thanks
Brian
April 19, 2003 at 6:58 am
Yes. You can use SQL Profiler to do this. Profiler gives you the ability to capture all the events going to your SQL Server. You can filter the events as appropriate and then save as a SQL script.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
April 22, 2003 at 3:17 pm
In trying to run the trace, I need to limit it to just events in the test database. When I set a filter on database name, it seems not to function - I still get activity from the live database, and get many events that do not have a database id or name. How can I limit events to the test database on the same server?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply