I am happy to tell you that the schemas do not have to be the same.  In fact, you can replicate from several databases into a single database and also...

The other option is to open Query Analyzer for SQL 2000 and press F4.

You will get a search utility that can search for columns.

Not that I want this thread to go on anymore, but here is my last post.  Yes - you are correct, the same spid can lock the same resource multiple...

If you use a global temp table, you could also log in the table information as the procedure processes (what step it is at, who ran it, etc) and you...

A select with a HOLDLOCK or using transaction isolation levels will work if the select command is held open.  The procedure is running more than one command so the lock...

Before I get beat up, I want to add that the above post was not a full description of how parallelism, or transaction isolation levels work.  I was just trying...

MAX DOP prevents multi-threading within a single process, and that is not really what he is trying to do.  With MAX DOP set to 1, you can have two users...

I think you will have to make some adjustments to not use a transaction within the stored procedure.  I do not think the app lock can be called with an...

The message was telling you that you were trying to run the restore operation while you were in the database.  If you have enterprise manager (or query analyzer for that...

Just a term issue, I think everyone has caught on that you want to prevent more than one person from running the same procedure at the same time.  This is...

Ok, a couple of things.  First, all of the white space you have in your posted procedure syntax is making it hard to read.  Second, have you run sp_helptext on...

I think RS installs using ananymous access by default.  This means that the IIS user IUSR_<ServerName> is the context that the application is going to run under.  This user may...

I have seen this with trust relationships between more than one network. 

It is possible to create a job on a server that is part of one network and the...

Log shipping is always going to give you some sort of delay or data loss.   You can reduse the time between log backups and restores to a minimal, but when...

To do this through transactional replication, you will need to include the view and all of the tables the view uses.

Transactional replication reads the transaction log of your database and...