One method I've seen is to have a column in each table that holds the name/id of the user making the update/insert.  Then that column will be available to you in the trigger.

Of...

Yes, you can do this with backup and restore. Backup database_1 then in enterprise manager right click database_2/all tasks/restore.

In the restore dialog you'll see a drop down with the option to...

I'm on sql2k and its hard to find.  Do a serach on SELECT and in the topics listed you should see Parts of a SELECT Statement.  Within this...

From Books Online:

ORDER BY order_list [ ASC | DESC ]

The ORDER BY clause defines the order in which the rows in the result set are sorted. order_list specifies the...

Paul,

If you are still having a problem then please post the statement you are trying and the error message you are getting.

ron

Of course if the coulmn is nullable then you would need something like:

Select custId, lName, fName from dbo.Customers

where CanceledOrder <> 1

OR      CanceledOrder is NUll

Edited to note the converion to Exclusive Lock:

UPDLOCK will not help in the situation presented by Chris.  UPDLOCK will allow SELECT statements (not requiring UPDLOCK or HOLDLOCK) by other...

By default you will not be able to select rows that are being inserted/modified until the transaction completes.  Just put all modification statements between a BEGIN TRANSACTION and a...

Gerry,

You might be better off starting a new thread that kind of just asks for a solution to your performance/locking problem as this thread seems to be more focused on...

...Question: quite a few tables in those queries are lookup tables, rarely modified. Would it help to use WITH (NOLOCK) for these tables.

I'm not sure but my guess is it would...

... its better to have alternates like indexing some columns so that data can be fetched faster.

I think Kishore has a good point.  Maybe the better solution is retry to...

For lots of great info on this and more check out Frank Kalis' excellent article on SQl Server dates at

http://www.sql-server-performance.com/fk_datetime.asp

Here's another option (with obvious drawbacks).

READPAST Skip locked rows. This option causes a transaction to skip rows locked by other transactions that would ordinarily appear in the result set,...

From Books Online

NOLOCK Do not issue shared locks and do not honor exclusive locks. When this option is in effect, it is possible to read an uncommitted transaction or...

Yes!  From Books online.

FROM

Specifies the tables, views, derived tables, and joined tables used in DELETE, SELECT, and UPDATE statements.

Syntax

[ FROM { < table_source > } [ ,...n ]...