SQL trace replay only in master db

Question

I can not replay my trace on testing server - I restored Database from production to testing server also restored master and msdb from production so database ID are same ,users are same and permissions are same.
I receive one and same error every time :Could not find stored procedure "xxx"
it seems that profiler try to execute every procedure in "master" db
but i see same error for system stored procedures too:[Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'sp_readrequest'. (State 42000) (Code 2812)

Answer 1

Hi,

Could you check that whether the procedure exists?

Here is a article about how to find all stored procedures related to table in database will help you find out, see:
http://blog.sqlauthority.com/2006/12/10/sql-server-find-stored-procedure-related-to-table-in-database-search-in-all-stored-procedure/

Hope this helps! If you have any concern, please feel free to let me know.

---

ChunSong Feng
Microsoft Online Community Support

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 2

Hi iv69,

In replaying, profiler will change database according to "DatabaseName" column in trace file, so please assure that you captured this column in your trace, and if the value of this column is what you expected, especially for login event. Apart from this, profiler will execute each event as the login value of "LoginName" column, so please assure that the user launching profiler has enough privileges.

Thanks,

---

Elton

Answer 3

Yes DatabaseName is included, I use TSQL_Replay Template when creating the trace.
And User that started replay is sysadmin.