Database stopped updating

[Bruce Sorge-3]

Good morning,
I am using SQL Server 2005 and am working on my development environment.
Recently, for some reason, SQL Server is not updating tables from forms
or SQL Server Management Studio.
I have tried to run the SP and ran a straight update. Using SQL Server
Profiler, it shows that the stored proc is running using my web based
form and server management studio. When I am looking at the profiler, I
get the batchcommand starting and completed. But in the completed line,
I get 7 reads and no writes. I am really at a loss as to what is
happening here. My production environment (which is identical to my dev
environment) is working fine. Any insight would be much appreciated.

Thanks,

Bruce

--
Throttle Jockey -
Why golf courses should be motocross tracks


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:3021
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.6

[Bruce Sorge-3]

OK, for some reason it started working again. Not sure what was going on really. Strange SQL Server.

Bruce

>Good morning,
>I am using SQL Server 2005 and am working on my development environment.
>Recently, for some reason, SQL Server is not updating tables from forms
>or SQL Server Management Studio.
>I have tried to run the SP and ran a straight update. Using SQL Server
>Profiler, it shows that the stored proc is running using my web based
>form and server management studio. When I am looking at the profiler, I
>get the batchcommand starting and completed. But in the completed line,
>I get 7 reads and no writes. I am really at a loss as to what is
>happening here. My production environment (which is identical to my dev
>environment) is working fine. Any insight would be much appreciated.
>
>Thanks,
>
>Bruce
>
>--
>Throttle Jockey -
>Why golf courses should be motocross tracks

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:3022
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.6