Why does SQL 2008 Profiler indicate that Stored Procedure run from EF4 is in Master?

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 this happened in DatabaseID = 1 (Master) but it is actually happening in my application database. 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?

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

  • SQL Server: add values of small tables to the values of big table without losing the dimensions of the big table?
  • How can I create two commands in one connection?
  • Logins created in SQL Server Management Studio are not able to log in
  • using SQL Server Management Objects (SMO) Developer Machine 32 bit - SQL Server 64 bit
  • Max int value in t-SQL
  • How to insert data if not in between in sql server 2008?
  • UPDATE: I have now tested this on a new installation of SQL Server 2008 R2 and it still displays this as if it happened in Master.

    UPDATE 2: This has been logged to Connect at https://connect.microsoft.com/SQLServer/feedback/details/572246/profiler-reports-ef4-queries-as-occurring-in-master.

  • Select one records from three tables based on latest date
  • How do I retrieve decimals when rounding an average in SQL
  • drop rows in a user defined table type
  • Regarding delete a record
  • Database removal of old entries
  • How to remove duplicates in one column and select the first top one only
  • One Solution collect form web for “Why does SQL 2008 Profiler indicate that Stored Procedure run from EF4 is in Master?”

    Contains youir connectionstring the option ‘MultipleActiveResultSets=True’? If yes, try to remove it and look at sql profiler.

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.