Trackking使用GetTrackingProfile存储过程的修复模式 [英] Trackking uses fix schema for GetTrackingProfile stored procedure
问题描述
我在名为[workflow]的模式中生成了跟踪和持久性表/ view / sp。我使用默认架构作为工作流在数据库上设置用户。除了sp GetTrackingProfile,一切都还可以。我测试了这个在dbo模式上创建这个sp以及在模式工作流上创建其他模式。
我猜SqlTrackkingService的GetTrackingProfile方法将sp称为"dbo.GetTrackingProfile"。而不是"GetTrackingProfile"
我不想使用dbo架构。如何更改sp调用,如"无模式前缀"?
atmuc
在此查看我的帖子有关更改用于连接到跟踪数据库的SQL Server登录ID的默认架构的线程:
http://social.msdn.microsoft.com/Forums/en-US/windowsworkflowfoundation/thread/15a8236b-ecec-4963-bac1-b561fa4f4e17/
i generated tracking and persistence table/view/sp in a schema named [workflow]. i set a user on database with default schema as workflow. Except sp GetTrackingProfile everything is ok. i testted this as creating this sp on dbo schema and others on schema workflow.
i guess GetTrackingProfile method of SqlTrackkingService calls sp as "dbo.GetTrackingProfile" istead of "GetTrackingProfile"
i dont want to use dbo schema. how can i change sp call as with "no schema prefix"?
atmuc
See my post in this thread about changing the default schema for the SQL Server login id you're using to connect to the tracking database:
http://social.msdn.microsoft.com/Forums/en-US/windowsworkflowfoundation/thread/15a8236b-ecec-4963-bac1-b561fa4f4e17/
这篇关于Trackking使用GetTrackingProfile存储过程的修复模式的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!