August 14, 2016 at 8:55 am
Hi
I enabled service broaker and configured my MVC 5 app signalR properly . but when I run the project . and make changes to the table records . nothing is occurred . it seems it is a SQL server side error ! So how can I fixed it?
August 14, 2016 at 9:56 am
aminsoraya (8/14/2016)
HiI enabled service broaker and configured my MVC 5 app signalR properly . but when I run the project . and make changes to the table records . nothing is occurred . it seems it is a SQL server side error ! So how can I fixed it?
There are umpteen things that could be going sideways here!! But you have given us nothing to go on to see what the problem could be. Some questions:
1) How do you KNOW that EVERYTHING about your setup (whatever it is) is correct and functioning properly? What, exactly, did you do to validate this stuff?
2) Did you use Profiler to track all database activity related to whatever your project/SSB/data modifications?
3) Does ANYTHING happen when you run your project and do DML? What of that is different compared to the stuff you did in item 1) above to verify everything worked correctly outside your project?
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
August 14, 2016 at 9:32 pm
hi again
i checking sql profiler but I dont realize it.I was set the command bellow to current database:
alter authorization on database::[DataContext] to [sa]
alter database [DataContext] set enable_broker with rollback immediate
and also another commands:
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
SET CONCAT_NULL_YIELDS_NULL ON
SET QUOTED_IDENTIFIER ON
SET NUMERIC_ROUNDABORT OFF
SET ARITHABORT ON
before all I logined by administrator premission.
I checked sql dependency fired parts by breakpoints
but still nothing is called after changing values. if you expert in asp.net mvc I can share you an pure source
August 15, 2016 at 8:28 am
Sorry, I am about to leave for an international trip and probably won't be able to assist effectively. Possible things to look into are:
1) Permissions. If this is development or not worried with security make your app log in with SA level access and see if that works.
2) You REALLY need to be able to collect server activity via profiler (or Extended Events) to see what is happening. My seeing your outside-SQL-Server code is useless because it doesn't confirm to me the actual calls or effects or errors being caused inside SQL Server from that code.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply