#DateForumTypeThreadPost
424 Feb 2011 @ 04:39 PSTDatabaseReplyHow to test a table for a Loader LockBy the way, meant to say, anyone got any ideas on how to trap the error successfully?
324 Feb 2011 @ 04:38 PSTDatabaseTopicHow to test a table for a Loader LockHi. I'm trying to create a store proc that counts how many rows are in the ET table if it exists. I can trap for table not exists but I can't see to trap for when the table is 'loader locked'...
221 Jul 2009 @ 07:02 PDTAnalyticsReplyWill MLOAD able to Insert data into Global Temporary Tables !!!We are also trying to do a similar thing.We have a common error table. We have internal and external processes that want to load into that error table to do common reporting. The internal process c...
125 May 2007 @ 08:09 PDTDatabaseTopicreturning an identity value when doing a single insertHi,I have a table with a field which is an identity column. Its the unique identifier of the record.When a record is inserted via a stored proc, I want to return whatever that new id is to the call...