Is this a bug in Profiler or Entity Framework?

Posted by AjarnMark on Server Fault See other posts from Server Fault or by AjarnMark
Published on 2010-06-08T16:12:51Z Indexed on 2010/06/08 16:23 UTC
Read the original article Hit count: 417

Using Entity Framework 4 with stored procedures and SQL Server 2008 SP1... When running SQL Server Profiler (TSQL_SPs template), the lines that show my stored procedure call and its statements say that they executed in DatabaseID = 1 (Master) but it is actually happening in my application database (ID = 8). The procedures execute properly and return the data, and they only exist in my application database, so why does Profiler mark those lines as being in Master? Is this a bug in Profiler? Is it a bug in EF4?

Note that running the same code against a SQL 2000 instance, Profiler correctly shows the application's database ID.

© Server Fault or respective owner

Related posts about sql-server-2008

Related posts about sqlprofiler