Let Me Know Abt Table Locks In Ms-sql - ASP / Active Server Pages

Similar topics

by: rkusenet | last post by:

I have written a stored procedure to list out all tables in which rows or the table itself is locked. The only information I am not able to get is...

Microsoft SQL Server

Update statement performing table lock even though where condition on clustered primary index?

by: M Wells | last post by:

Hi All, I have a database that is serving a web site with reasonably high traffiic. We're getting errors at certain points where processes are...

Microsoft SQL Server

NOLOCK and READPAST on same table?

by: laurenq uantrell | last post by:

Is it possible to use With (NOLOCK) and With (READPAST) in the same SELECT query and what whould be the syntax? @param int SELECT myRow FROM...

Microsoft SQL Server

Does REINDEX TABLE lock the table?

by: G.W. Lucas | last post by:

I apologize if this is a RTFM question, but I have not been able to find a definitive answer elsewhere. Does a "REINDEX TABLE" lock the table...

PostgreSQL Database

Table Locks and Preventing Deadlock

by: EoRaptor | last post by:

I`m exporting data from many Lotus Notes databases to a DB2 database using LotusScript. The LotusScript agents commit after EACH update/insert....

DB2 Database

Unlocking DB2 table/row locks

by: boris.litvak | last post by:

We are looking for a command/SQL statement that cancels all table/row locks in DB2. The reason for this is: 1) computer A was a sole client of...

DB2 Database

BIZZARE MQT-BASE Table Locking Behaviour

by: Zri Man | last post by:

I have come across a bizzare behaviour with DB2/UDB 8.2 on SuSE Linux 2.41 When I have a MQT Refresh going on (complete refresh) it appears to...

DB2 Database

Network access - table locks up

by: Noni Ledford | last post by:

Hi - I have a database on a network, and each user logins using a shortcut from his PC to the shared database. There is a table created by a...

Microsoft Access / VBA

Jet database engine and table LOCKS

by: leon | last post by:

Hi all, I have an .mdb file (access database) which has been set to table level locking (i.e. not just records in question, but the whole table)....

Microsoft Access / VBA

How do I prevent records from being created in a related table?

by: jbrumbau | last post by:

Hello, I have been successfully using a database I've created for several months to populate an equipment list for a project we've been working...

Microsoft Access / VBA

Discuss your understanding of the Java platform.

by: better678 | last post by:

Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...

General

List of Topmost 8 Electronics Engineering Forum Websites

by: teenabhardwaj | last post by:

How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...

General

how to collapse a custom toolbar in VBA

by: CD Tom | last post by:

This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...

General

Basic concepts of WebLogic Admin training?

by: Naresh1 | last post by:

What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...

Oracle Database

Hyperconverged All-in-One Streaming Engine, ushering in new age for distributed database

by: antdb | last post by:

Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...

General

How to layout php header location with a variable as the location?

by: Matthew3360 | last post by:

Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...

PHP

How to use http requests (Get function) to get variable value?

by: Matthew3360 | last post by:

Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...

Python

by: WisdomUfot | last post by:

It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...

General

PHP Curl Not wanting to connect to localhost.

by: Matthew3360 | last post by:

Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...

PHP