Hi!<br /><br />Thanks for your reply! Yep, this C/SIDE & C/AL stuff is somewhat tricky ... it's designed by Microsoft, actually from the former...
quote:Couldnt SPID 51 simply SET DEADLOCK_PRIORITY LOW ? Unfortunately not. The situation I have is this: There are about 20 to 150 NAV Clients;...
Dear Satya, thank you for your reply. So this means that there is no chance to set the DEADLOCK_PRIORITY for a "remote" SPID?! Pity ... [V] So I'll...
Hi all! Well, I want to prevent that a specific process/client - a MS Dynamics NAV Application Server (NAS) - is selected as deadlock victim. I know...
Yep, that helped - this is what I got now: update dbo."CRONUS International Ltd_$Item" set [No_] = upper([No_]) where (patindex('%[a-z]%', [No_]) >...
Hi! Thanks for your reply! Well, I need this just for troubleshooting: The application is MS Dynamics NAV, which has its own development...
Hi all! I would like to filter on a varchar(20) field in a table to get only records which include at least one lowercase character; records where...
Hi Mark! Nice to meet you here, too! [8D] Could you give me some more info about this "SQL Shield"? Best regards, Jörg --- Edit --- Not necessary...
Ahhhh! Yeah, the EXEC did the trick - works perfect! [<img src='/community/emoticons/emotion-4.gif' alt=':p' />]<br /><br />Thank you very much!<br...
Hi again! Thanks a lot for your advice. But I'm afraid, I still can not get it going [xx(] use [SSI] -- this is the db from where the...
Now I tried this, but it still doesn't work [V] use [SSI] -- this is the db from where the installation should start go declare @stmt...
Hello Gordon (Haywood)!<br /><br />Thanks for your advice! Well, I browsed your postings - and there were a lot [<img...
Hi all!<br /><br />Thanks a lot for your replies. Hmm, seems to be tricky business [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br...
Hello SQL-Server-Performance.com!<br /><br />This is my first posting in this forum, so I would like to briefly introduce myself:<br /><br />My name...
Separate names with a comma.
