You have to let it complete. Do not try to do anything to speed it up because you will only slow it down. Sorry for the bad news but recovery...

There is nothing you can do while the database is running recovery, but wait. Those times are not 100% accurate, so it may finish sooner (or later) then it is...

Look at this blog post:

http://blogs.msdn.com/b/sqlserverfaq/archive/2010/10/27/troubleshooting-specific-login-failed-error-messages.aspx

Good luck! Hope all goes well.

I before Pivot I would use case based pivoting. Here is an article that describes some different options:

http://pratchev.blogspot.com/2007/04/pivoting-data-in-sql-server.html

That exam is scheduled to retire on Jan. 31st not July of next year.

http://www.microsoft.com/learning/en-us/exam.aspx?id=70-450

Transactional replication is designed for read-only subscribers, but it is not enforced. So, you can still write to the database, but then you could have conflict issues.

I forgot to mention two other options:

CDC

Change Tracking

Here is a great article describing these options (compared to Transactional Replication):

http://www.brentozar.com/archive/2013/09/transactional-replication-change-tracking-data-capture/

Usually you can just restart SSMS and it works, but this is a known issue:

http://connect.microsoft.com/SQLServer/feedback/details/557402/ssms-can-no-longer-create-or-edit-job-steps

And depending on which version you are on (the name of the question and the forum...

Well that limits your options to:

1. backup and restore nightly (not a great option with a 10TB database)

2. Replication (Transactional)

3. SAN Replication if applicable

4. 3rd party tool (like Red...

Does the dev database need to be read-write or read-only?

I'm not sure how this is even working when you run it manually. A 4 part object name is ServerName.DatabaseName.Schema.Object so in your example dbo is in the database name...

So just to make sure that I understand your question. Before inserting a record into Table1 you want to verify that Table1.Col2 exists in Col3 from Table2 and that Col1...

I would think you could use a windowing function to accomplish this, but without table structures and sample data I'm not sure. Is there a reason the following wouldn't work?

select...

I'm not sure exactly what this query should be doing, but if you question is how to use insert with row_number then just do this:

INSERT INTO [ReceiptRepository].[Lkup].[BillingGroups]

select M.RowNum, M.BillingGroupNumber

from

(

select BillingGroupNumber,...