<p>How can i query on the client mirrored database as it is always in recovery mode and i am not able to query on it is there any way from which i can query on it. I just want to confirm that is mirroring is working or not so how can i check the data on mi...

<p>I want to generate row numbers in SQL 2000, there is a great function in SQL 2005 and onwards to generate row number by a simple function, but i get stuck into this, is there anyways to generate row numbers in SQL Server 2000.</p>...

<p>I want to join the results given by two queries and avoid duplicates in this is there any way to do so.</p>...