Help On This Sp, It Should Be PERFECT!!!!

Apr 19, 2007

Hi there, could someone tell me what is the wrong with the below SP's CURSOR.I exec this sp through a table when update a filed value like this :
EXECUTE THROUGH TRIGGER
exec SP_ALOCATE_PAT_CREDIT @patid, @creditno, @totalamount, @userid, @sdesc ,@creDate,'C'

When i run execute this sp, I got this error :
ERROR:
Another user has modified the contents of this table or view;the database row you are modifying no longer exists in the database.Databse error: '[Microsoft][ODBC SQL Server Driver][SQL Server]A cursor with the name 'INVOICE_LIST' does not exist.[Microsoft][ODBC SQL Server driver][SQL Server]The statement has terminated.'


==============================
THANX GUYZ, ALREADY SOLVED IT FINALLY:beer: , ON TODAY EARLY MORNING.WELL, I GUES U GUYS R RITE, I NEED MORE PRACTISE BUT I DID GOOD AT THIS STAGE TOO EVENTOUGH IT IS NOT SO STANDARD..HAHA ,THNX ANYWAY, WILL WORK TO BE BETTER! :angel:

View 6 Replies


ADVERTISEMENT

Which Server Is Perfect For Installation ?

Jun 12, 2008

Hi ,
DBA's i just want to know that one of our customer want to add services like ssis,ssrs and ssas .but i want to know that on which server they need to install these services.
1. web server
2. application server
3. database server
which server is perfect for these services .

plz w8ing for ur suggestions .

Thaxxx
Regards
Jagpal Singh



jagpalsingh

View 4 Replies View Related

SQL Server:Perfect Dev; Nightmarish Download/install. Help!

Dec 9, 2007




My team has finally delivered my project in SQL/.net. Everything is great: database, charts€¦ it functions exactly how I envisioned. However, there is a nightmarish challenge: The download & Install process is ridiculous! I don't mind the other runtime stuff one has to download (.net 2.0 etc, which we were able to package and automate), but SQL takes 2hrs to download and then there's a server/client installation set-up that just makes it impossible for regular folk (non-techies) to configure. My SQL developers say there's nothing they can do, so I'm working on converting this to a web version in SQL, while simultaneously redoing the entire desktop version in Adobe Air, which incidentally has a light SQL database embedded - all at great cost to time, resources & my "sanity€?. But I'm saying to myself, if Adobe has a solution for SQL, why doesn't Microsoft have a solution for SQL? Any thoughts, ideas, help?



Cheers,

Charley

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved