开发者

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.

UPDATE: I have now tested this on a new installation of SQL Server 2008 R2 and it still displays t开发者_运维知识库his 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.


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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜