The only reason to add the GUID to the clustered index is to make it unique...is that the reason for adding this column to the clustered index.

I GENERALLY prefer to...

Here is a starting point...I use this to restore databases to my DR server...

Good Luck

ALTER PROCEDURE [dbo].[P_RestoreDatabase_DBName]

AS

SET NOCOUNT ON

DECLARE @DBName VARCHAR( 64 ) = 'DBName'

DECLARE @DirName VARCHAR( 256 )

DECLARE @FileName VARCHAR( 256 ),

@FileDate DATETIME,

@MaxFileDate DATETIME,

@DBRestoreSize BIGINT,

@DBRestoreLSN NUMERIC( 25, 0 )

DECLARE @SQL VARCHAR( 5000 )

SELECT @DirName = 'L:\' +...

Here is the simples solution:

1. Have two separate databases and two separate web servers servicing the requests

2. Have the users login to a third common website

3. Redirect the users to...

1. Do the restore to a different database name

2. then rename/drop the old database

3. Rename the new database to the correct DB name

Getting events in the default trace saying missing column statistics on a column...

1.The column is the primary key column ( identity ), with a primary key

2. Auto Create statistics is...