I do not know what your stored procedure prc_myremoteproc is doing other than returning results, but if it is not updating or inserting, you can probably get around this problem...

With asynchronous triggers in SQL 2005, you could do this.  I would still agree that it is probably not a great idea.  You could also se the isolation level of...

I would tend to agree, SSIS, DTS, or a custom application.  T-SQL is not really designed for looping processes like this.

I think SSIS is a great option.

My first thought is that you probably should not be doing this operation in a stored procedure.

Sorry.

Next, I would say to make the cursors forward only / read only cursors.  They...

You may get 20 responses and 20 different answers and all of them will be right.  It is really situation dependant.  The first thing to note is that until sp2,...

For truncating all of the tables, you are going to either have to drop all foreign keys, or get everything in the correct order before you delete / truncate each...

The last post is right - you should really normalize your database a bit more, but we all know that this is not always possible.

Since the update used to only...

Usually, in a warehouse, you would want to combine the data from your sources into a single place for reporting.

For instance, all of your accounts may come from your finance...

It is somewhat difficult to get a database file and log file to work re-attaching it if you copied it while it is still attached and in use.  If you...

The answer is yes, but you should really get some books on SQL replication or some help with what you are doing.  I can think of a few things that...

The last post is probably correct.  You cannot see AWE memory use through any of the normal memory indicators.  The best way to see if it is being used is...

You can "cheat" if you really need this.  Your view can contain a TOP operator that is higher than the number of rows the table will ever have. 

SELECT TOP...

I cannot remember if you can do with this a replicated table, but it is worth trying.

Rather than moving your existing file, create a second file and filegroup on the...

You can set the recovery model to simple (truncate log on checkpoint), but the transaction log will still be used and can grow significantly.

This option will truncate the transaction log...

That is a bit of a vague question.  Database mirroring has a few of the same "problems" as log shipping.  What behavior are you specifically referring to?