in sql 2005

Use sys.dm_tran_locks DMV in SQL Server 2005 to get the locks information.

for more information:

http://technet.microsoft.com/en-us/library/ms190345.aspx

example:

SELECT resource_type, resource_associated_entity_id,

request_status, request_mode,request_session_id,

...

you have two solutions

1) you have to create a table alternative_products

with product_id , alt_prod_id , and fill that table with with alternative codes and use it in queries

2) you have...

if databases are in the same server

===========================

select * from mydb1.dbo.product where product_id =99999

union

select * from mydb2.dbo.product where product_id =99999

union

select * from mydb3.dbo.product where product_id =99999

if the database are in...

Is there windows script, that one can run to create alias for the sql server.

i want to run it in more than one machine.

Excellent newsletter