try this instead:

declare @SnapshotDBName sysname

Yes, I know.  But are there hidden options that will enable management studio to reconnect once the tlog restore is complete??  Basically it could keep retrying the connection and connect...

1. Developers handle only few tables.  These tables are rebuild/reindexed on a regular schedule.

2. Our raid configuration is kind of bad.  It's still RAID5, and I've been trying to upgrade it, but...

There is no other software running on the same box.  It's a dedicated SQL 2005 installation.

No third party monitoring tools.  Just SQL Management Studio.

Yes, there are XPs and .net assemblies...

The statistics get updated automatically by a process that our developers wrote. 

We haven't experienced the problem with statistics just yet, at least we don't think that's the problem as...

The advice from MS was to turn off auto-update statistics too.  Statistics are independent of indexes so you don't have to create a "pot wad" of them.

If the table has...

All of our machines are dedicated.  Application is .net web site and runs on a different web server/box.

I never recall a restore dialog pointing across the network.  Even in SQL2000 it would let you browse local drives.  Copy SQL2000 backup file across the network to 2005 box...

I think gilbertorosa was thinking of large tables, which would make sense to turn off auto update statistics.  We do have them, the largest table in our db is over...

It's not the statistics problem because the tables get replaced once a week, so their indexes and statistical information is rebuilt.  These tables have no inserts/updates running throughout the week...

No, we do have heap tables as well.  But all the tables on which we do selects on, are basically 1) read-only 2) have clustered index.

Anyway, working with MS on...

Thanks for the tip, but no, we don't backup transaction logs as we run in simple recovery.  We do backups on nightly basis, but the db gets rebuild in the...

How about the certificate password, it has to be the same across all three machines.  Also what about your master key?

Make sure that certs match across all servers participating in the mirror session.  This includes optional witness server.  It's a bit trickier to setup in the workgroup.  We had experienced...

No there are no page splits and the db is not growing.  tempdb isn't growing either.

So no page splits and no full scans happening.  The system seems very normal, it's...