Is it possible to create a deadlock with read only access I think there are a number of possibilities in the answers already provided here. MS-SQL-Server-Import-Data-from-Excel.png' alt='Microsoft Sql Server 2008 Error 1222' title='Microsoft Sql Server 2008 Error 1222' />Since you only take shared locks, the deadlock cant be due to lock escalation, and must simply be acquiring locks that are incompatible with those acquired in another process, and acquiring those locks in a different order. Your shared locks are incompatible with another process taking exclusive locks. The scenario might run something like this. You take shared lock on resource AOther process takes exclusive lock on resource BOther process tries to take exclusive lock on resource A, and blocks waiting for you to release your shared lock on A. You try to take shared lock on resource B, and would block waiting for the other process to release its exclusive lock on B, except that youre now in a deadlock situation, which is identified by the server and it chooses a process to kill. N. B. deadlocks can have more players than just 2. InformationWeek. com News, analysis and research for business technology professionals, plus peertopeer knowledge sharing. Engage with our community. I have a VB6 application accessing a single table on a MSSQL2000 server via ADO. Im using readonly access adOpenStatic, adLockReadOnly There are other. This section is aimed to help troubleshooting Microsoft SQL Server problems. Its increasingly difficult to do anything on your phone nowadays without sharing your geolocation information. Certain Snapchat filters, Facebook status updates. Written by Mohit Gupta, Microsoft Premier Field Engineer. Every now and then we have deadlocks taking place in SQL Server. Most go unnoticed, either. I am working in a database where I load data in a raw table by a data loader. But today the data loader got stuck for unknown reasons. Then I stopped the data loader. Sometimes theres a whole chain of interwoven activity that results in a deadlock, but the principle is the same. Often, if multiple applications access the same database, there is a DBA that manages all access via stored procedures, so he can ensure resources are always locked in the same order. If youre not in that situation, and the other applications use ad hoc SQL statements youd have to inspect their code to find out if they might conflict with your app in the way Ive described. Microsoft Sql Server 2008 Error 1222' title='Microsoft Sql Server 2008 Error 1222' />Introduction Here I will explain how to insert registered user details in database and how to get output parameters returned by SQL Query in asp. Its that time of year when Intel, the largest maker of laptop and desktop processors in the world, announces the guts of your future PC. These CPUs are always a. That doesnt sound like fun. A pragmatic solution might be to catch the error when your transaction is killed as a deadlock victim, and simply re try the transaction several times. Depending on how much activity the other apps are generating, you might achieve acceptable results this way. Robin Keirs Software The Giant Port List. Giant Port List. Down to the UDP port list. TCP Ports. TCP 0 Reserved. TCP 1 Port Service Multiplexer. TCP 2 Management Utility. TCP 3 Compression Process. TCP 4 Unassigned. TCP 5 Remote Job Entry. TCP 6 Unassigned. TCP 8 Unassigned. TCP 9 Discard. TCP 1. Unassigned. TCP 1. Active Users. TCP 1. Unassigned. TCP 1. Daytime RFC 8. 67. TCP 1. 4 Unassigned. TCP 1. 5 Unassigned was netstat. TCP 1. 6 Unassigned. TCP 1. 7 Quote of the Day. TCP 1. 8 Message Send Protocol. TCP 1. 9 Character Generator. TCP 2. 0 File Transfer Default Data. TCP 2. 1 File Transfer Control. TCP 2. 2 SSH Remote Login Protocol. TCP 2. 3 Telnet. TCP 2. TCP 2. 5 Simple Mail Transfer. TCP 2. 6 Unassigned. TCP 2. 7 NSW User System FE. TCP 2. 8 Unassigned. TCP 2. 9 MSG ICP. TCP 3. 0 Unassigned. TCP 3. 1 MSG Authentication. TCP 3. 2 Unassigned. TCP 3. 3 Display Support Protocol. TCP 3. 4 Unassigned. TCP 3. 5 any private printer server. TCP 3. 6 Unassigned. TCP 3. 7 Time W3. Sober. I virus. TCP 3. Route Access Protocol. TCP 3. 9 Resource Location Protocol. TCP 4. 0 Unassigned. TCP 4. 1 Graphics. TCP 4. 2 Host Name Server. TCP 4. 4 MPM FLAGS Protocol. TCP 4. 5 Message Processing Module recv. TCP 4. 6 MPM default send. TCP 4. 7 NI FTP. TCP 4. Digital Audit Daemon. TCP 4. 9 Login Host Protocol TACACS. TCP 5. 0 Remote Mail Checking Protocol. TCP 5. 1 IMP Logical Address Maintenance. TCP 5. 2 XNS Time Protocol. TCP 5. 3 Domain Name Server. TCP 5. 4 XNS Clearinghouse. TCP 5. 5 ISI Graphics Language. TCP 5. 6 XNS Authentication. TCP 5. 7 any private terminal access. TCP 5. 8 XNS Mail. TCP 5. 9 any private file service. TCP 6. 0 Unassigned. TCP 6. 1 NI MAIL. TCP 6. 2 ACA Services. TCP 6. 3 whois. TCP 6. Communications Integrator CI. TCP 6. 5 TACACS Database Service. TCP 6. 6 Oracle SQLNET. TCP 6. 7 Bootstrap Protocol Server. TCP 6. 8 Bootstrap Protocol Client. TCP 6. 9 Trivial File Transfer. TCP 7. 0 Gopher. TCP 7. Remote Job Service. TCP 7. 2 Remote Job Service. TCP 7. 3 Remote Job Service. TCP 7. 4 Remote Job Service. TCP 7. 5 any private dial out service. TCP 7. 6 Distributed External Object Store. TCP 7. 7 any private RJE service. TCP 7. 8 vettcp. TCP 7. Finger. TCP 8. 0 World Wide Web HTTP. TCP 8. 1 HOSTS2 Name Server Bagle AZ worm Win. Rbot worm. TCP 8. XFER Utility. TCP 8. MIT ML Device. TCP 8. Common Trace Facility. TCP 8. 5 MIT ML Device. TCP 8. 6 Micro Focus Cobol. TCP 8. 7 any private terminal link. TCP 8. 8 Kerberos. TCP 8. 9 SUMIT Telnet Gateway. TCP 9. 0 DNSIX Securit Attribute Token Map. TCP 9. 1 MIT Dover Spooler. TCP 9. 2 Network Printing Protocol. TCP 9. 3 Device Control Protocol. TCP 9. 4 Tivoli Object Dispatcher. TCP 9. 5 SUPDUP. TCP 9. DIXIE Protocol Specification. TCP 9. 7 Swift Remote Virtural File Protocol. TCP 9. 8 Linuxconf TAC News. TCP 9. 9 Metagram Relay. TCP 1. 00 unauthorized use. TCP 1. 01 NIC Host Name Server. TCP 1. 02 MSExchange. MTA X. 4. 00 ISO TSAP Class 0. TCP 1. 03 Genesis Point to Point Trans Net. TCP 1. 04 ACR NEMA Digital Imag. Comm. 3. 00. TCP 1. Mailbox Name Nameserver. TCP 1. 06 3. COM TSMUX. TCP 1. 07 Remote Telnet Service. TCP 1. 08 SNA Gateway Access Server. TCP 1. 09 Post Office Protocol Version 2. TCP 1. 10 Post Office Protocol Version 3. TCP 1. 11 SUN Remote Procedure Call. TCP 1. 12 Mc. IDAS Data Transmission Protocol. TCP 1. 13 Authentication Service. TCP 1. 14 Audio News Multicast. TCP 1. 15 Simple File Transfer Protocol. TCP 1. 16 ANSA REX Notify. TCP 1. 17 UUCP Path Service. TCP 1. 18 SQL Services. TCP 1. 19 Network News Transfer Protocol. Installing Linoleum Flooring Over Existing Linoleum Block. TCP 1. 20 CFDPTKT. TCP 1. 21 Encore Expedited Remote Pro. Call. TCP 1. 22 SMAKYNET. TCP 1. 23 Network Time Protocol. TCP 1. 24 ANSA REX Trader. TCP 1. 25 Locus PC Interface Net Map Ser. TCP 1. 26 Unisys Unitary Login. TCP 1. 27 Locus PC Interface Conn Server. TCP 1. 28 GSS X License Verification. TCP 1. 29 Password Generator Protocol. TCP 1. 30 cisco FNATIVE. TCP 1. 31 cisco TNATIVE. TCP 1. 32 cisco SYSMAINT. TCP 1. 33 Statistics Service. TCP 1. 34 INGRES NET Service. TCP 1. 35 DCE endpoint resolution. TCP 1. 36 PROFILE Naming System. TCP 1. 37 NETBIOS Name Service. TCP 1. 38 NETBIOS Datagram Service. TCP 1. 39 NETBIOS Session Service. TCP 1. 40 EMFIS Data Service. TCP 1. 41 EMFIS Control Service. TCP 1. 42 Britton Lee IDM. TCP 1. 43 Internet Message Access Protocol. TCP 1. 44 Universal Management Architecture. TCP 1. 45 UAAC Protocol. TCP 1. 46 ISO IP0. TCP 1. 47 ISO IP. TCP 1. 48 Jargon. TCP 1. 49 AED 5. 12 Emulation Service. TCP 1. 50 SQL NET. TCP 1. 52 Background File Transfer Program. TCP 1. 54 NETSC. TCP 1. NETSC. TCP 1. 56 SQL Service. TCP 1. 57 KNETVM CommandMessage Protocol. TCP 1. 58 PCMail Server. TCP 1. 59 NSS Routing. TCP 1. 60 SGMP TRAPS. TCP 1. 62 SNMPTRAP. TCP 1. 63 CMIPTCP Manager. TCP 1. 64 CMIPTCP Agent. TCP 1. 65 Xerox. TCP 1. Sirius Systems. TCP 1. Network Post. Script. TCP 1. 71 Network Innovations Multiplex. TCP 1. 72 Network Innovations CL1. TCP 1. 73 Xyplex. TCP 1. 74 MAILQ. TCP 1. VMNET. TCP 1. 76 GENRAD MUX. TCP 1. 77 X Display Manager Control Protocol. TCP 1. 78 Next. Step Window Server. TCP 1. 79 Border Gateway Protocol. TCP 1. 80 Intergraph. TCP 1. 81 Unify. TCP 1. Unisys Audit SITP. TCP 1. 83 OCBinder. TCP 1. 84 OCServer. TCP 1. 85 Remote KIS. TCP 1. 86 KIS Protocol. TCP 1. 87 Application Communication Interface. TCP 1. 88 Plus Fives MUMPS. TCP 1. 89 Queued File Transport. TCP 1. 90 Gateway Access Control Protocol. TCP 1. 91 Prospero Directory Service. TCP 1. 92 OSU Network Monitoring System. TCP 1. 93 Spider Remote Monitoring Protocol. TCP 1. 94 Internet Relay Chat Protocol. TCP 1. 95 DNSIX Network Level Module Audit. TCP 1. 96 DNSIX Session Mgt Module Audit Redir. TCP 1. 97 Directory Location Service. TCP 1. 98 Directory Location Service Monitor. TCP 2. 00 IBM System Resource Controller. TCP 2. 01 Apple. Talk Routing Maintenance. TCP 2. 02 Apple. Talk Name Binding. TCP 2. 03 Apple. Talk Unused. TCP 2. 04 Apple. Talk Echo. TCP 2. 05 Apple. Talk Unused. TCP 2. 06 Apple. Talk Zone Information. TCP 2. 07 Apple. Talk Unused. TCP 2. 08 Apple. Talk Unused. TCP 2. 09 The Quick Mail Transfer Protocol. TCP 2. 10 ANSI Z3. TCP 2. 11 Texas Instruments 9. CG Terminal. TCP 2. ATEXSSTR. TCP 2. 14 VM PWSCS. TCP 2. 15 Insignia Solutions. TCP 2. 16 Computer Associates Intl License Server. TCP 2. 17 d. BASE Unix. TCP 2. 18 Netix Message Posting Protocol. TCP 2. 19 Unisys ARPs. TCP 2. 20 Interactive Mail Access Protocol v. TCP 2. 21 Berkeley rlogind with SPX auth. TCP 2. 22 Berkeley rshd with SPX auth. TCP 2. 23 Certificate Distribution Center. TCP 2. 24 masqdialer. TCP 2. 42 Direct. TCP 2. 43 Survey Measurement. TCP 2. 44 inbusiness. TCP 2. 46 Display Systems Protocol. TCP 2. 47 SUBNTBCSTTFTP. TCP 2. 48 bhfhs. TCP 2. RAPCheckpoint SNMP. TCP 2. 57 Check Point Secure Electronic Transaction. TCP 2. 58 Check Point Yak Winsock Personal Chat. TCP 2. 59 Check Point Firewall 1 telnet auth Efficient Short Remote Operations. TCP 2. 60 Openport. TCP 2. 61 IIOP Name Service over TLSSSL. TCP 2. 62 Arcisdms. TCP 2. 64 BGMP Check Point. TCP 2. 65 X Bone CTL. TCP 2. 66 SCSI on ST. TCP 2. 67 Tobit David Service Layer. TCP 2. 68 Tobit David Replica. TCP 2. 80 HTTP mgmt. TCP 2. 81 Personal Link. TCP 2. 82 Cable Port AX. TCP 2. 83 rescap. TCP 2. 84 corerjd. TCP 2. 86 FXP 1. TCP 2. K BLOCK. TCP 3. 08 Novastor Backup. TCP 3. 09 Entrust. Time. TCP 3. 10 bhmds. TCP 3. 11 Apple. Share IP Web. Admin. TCP 3. 12 VSLMP. TCP 3. 13 Magenta Logic. TCP 3. 14 Opalis Robot. TCP 3. 16 dec. Auth. TCP 3. 17 Zannet. TCP 3. 18 PKIX Time. Stamp. TCP 3. 19 PTP Event. TCP 3. 20 PTP General. TCP 3. 22 RTSPS. TCP 3. Texar Security Port.