I build and...

I strongly suggest you don't go the locking route. If you could lock the entire database, you'd essentially be preventing anyone from doing anything until the first process is complete....

Is that one of the tables you...

I don't see an execution plan anywhere.

Cool. Think your SQL skills are up to using the script...

Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

So you want to drop all tables in the Owner2 schema?

Does this list all the tables that you want to drop?

SELECT s.name, t.name

FROM sys.tables t INNER JOIN sys.schemas s...

May I suggest that you start by looking in Books Online for info on the various commands that you want to run.

There's no need to do SP_RECOMPILE and SP_REFRESHVIEW on...

I think that depends on whether or not the query requested the varbinary(max) column or not.

Locking hints would have to be applied in Process1, since it's the one doing the updating.

May I suggest a check at the beginning of Process2, something to check whether Process1...

We generally don't give interview questions here. It doesn't help anyone to give someone questions and answers so that they can pass an interview they should not have been able...

*edit removed*

The SQL Server service account does not have sufficient rights to access that folder. Note, it's the account that SQL runs under that's inportant. Not whatever you're logged in as.

Check...

Use nvarchar(max) rather than nvarchar(4000)

NText is a deprecated data type, should not be used in new development and will be removed in a future version of SQL.

ALTER DATABASE with the MOVE clause

Take the database offline

Move the files

Bring the database online.