Click here to Skip to main content
15,434,430 members
Home / Discussions / Database
   

Database

 
AnswerRe: SQL Server 2005 Instance Pin
Mycroft Holmes22-May-09 22:07
professionalMycroft Holmes22-May-09 22:07 
GeneralRe: SQL Server 2005 Instance Pin
εїзεїзεїз22-May-09 22:28
Memberεїзεїзεїз22-May-09 22:28 
GeneralRe: SQL Server 2005 Instance Pin
Mycroft Holmes22-May-09 22:39
professionalMycroft Holmes22-May-09 22:39 
GeneralRe: SQL Server 2005 Instance Pin
εїзεїзεїз23-May-09 0:06
Memberεїзεїзεїз23-May-09 0:06 
QuestionAutomatic primary key start in MS Access Pin
hrishiS21-May-09 19:48
MemberhrishiS21-May-09 19:48 
AnswerRe: Automatic primary key start in MS Access Pin
Mycroft Holmes21-May-09 22:27
professionalMycroft Holmes21-May-09 22:27 
AnswerRe: Automatic primary key start in MS Access Pin
Eddy Vluggen23-May-09 8:13
professionalEddy Vluggen23-May-09 8:13 
QuestionHow to bypass TRIGGERs with no potential concurrency issues? Pin
Rafferty Uy21-May-09 16:34
MemberRafferty Uy21-May-09 16:34 
Hi,

How can I bypass an SQL Server 2005 TRIGGER with no potential concurrency issues? The trigger is executed ON UPDATE, where the table is updated by an ASP.Net web application... so there will be multiple users concurrently using this specific function.


So far I have found 3 possible solutions, but I don't know if there will be concurrency problems with these solutions.
1. Disable the trigger at the beginning of the update procedure, and enable it at the end <-- definitely has concurrency issues

2. Using CONTEXT_INFO() http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=AuditOrBypassTriggerExecution[^] <-- not sure about concurrency problems with this solution

3. Using a #tempTable http://www.mydatabasesupport.com/forums/sqlserver-programming/201598-ignoring-trigger.html[^] <-- see last post by Erland Sommarskog, not sure about concurrency problems with this solution


What do you think? Or are there other better solutions?


Thank you in advance.

Rafferty

QuestionBest insert options. Pin
FISH78621-May-09 15:07
MemberFISH78621-May-09 15:07 
AnswerRe: Best insert options. Pin
PIEBALDconsult21-May-09 15:57
professionalPIEBALDconsult21-May-09 15:57 
GeneralRe: Best insert options. Pin
FISH78621-May-09 15:59
MemberFISH78621-May-09 15:59 
GeneralRe: Best insert options. Pin
ISoftwareDev23-May-09 10:29
MemberISoftwareDev23-May-09 10:29 
AnswerRe: Best insert options. Pin
WoutL25-May-09 3:16
MemberWoutL25-May-09 3:16 
QuestionTrigger in sql server 2005 [modified] Pin
beesan20-May-09 3:53
Memberbeesan20-May-09 3:53 
AnswerRe: Trigger in sql server 2005 Pin
Mycroft Holmes21-May-09 13:40
professionalMycroft Holmes21-May-09 13:40 
Questionminus operation Pin
hrishiS20-May-09 2:17
MemberhrishiS20-May-09 2:17 
AnswerRe: minus operation Pin
Philip.F20-May-09 3:30
MemberPhilip.F20-May-09 3:30 
AnswerRe: minus operation Pin
PIEBALDconsult21-May-09 16:00
professionalPIEBALDconsult21-May-09 16:00 
QuestionBest Traffic Campaign (2385) Pin
Faisal Halari20-May-09 0:36
MemberFaisal Halari20-May-09 0:36 
AnswerRe: Best Traffic Campaign (2385) [As if you hadn't guessed, this is an ADVERT. IGNORE!!! Pin
Henry Minute20-May-09 0:39
MemberHenry Minute20-May-09 0:39 
Questionproblem populating a combo box Pin
Jondo24shoots19-May-09 22:22
MemberJondo24shoots19-May-09 22:22 
AnswerRe: problem populating a combo box Pin
Henry Minute20-May-09 0:41
MemberHenry Minute20-May-09 0:41 
AnswerRe: problem populating a combo box Pin
saanj28-May-09 3:12
Membersaanj28-May-09 3:12 
QuestionMaking the local database to a remote database server Pin
Subin Alex19-May-09 20:14
MemberSubin Alex19-May-09 20:14 
AnswerRe: Making the local database to a remote database server Pin
Mycroft Holmes19-May-09 23:22
professionalMycroft Holmes19-May-09 23:22 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.