I am not aware of any size limits on Snapshot Replication.

What is the error that you are seeing?

The snapshot files are applied at the Subscriber by Distributor right from the...

Luke L (12/31/2009)

Bru Medishetty (12/31/2009)

I had few horrific moments :w00t: today morning driving to work. So all those...

Wishing you all a Very Happy, Prosperous and Safe New Year 2010.

I had few horrific moments :w00t: today morning driving to work. So all those where snow is predicted...

May be possible using any 3rd party tools.

You can use scripting all objects in a database to achieve this.

Detach / Attach requires the primary database to be offline. Which may not be a good way of doing this. :w00t:

Moreover the OP has not...

To get tested answers you need to provide the DDL and sample...

You could also use this way

Where COLOR IN ('RED','BLUE','GREEN' )

Instead of using AND use OR.

Do you know that "where" clause exists in SQL Server?

Use it, if not look in Books Online for it. 🙂

Make sure the MDF file is a dummy file you created for this test purpose.

Have you tried intsalling the update KB955706 manually?

Failure of that has stopped the installation to move forward.

Try installing that individually and when successful retry SP3 installation.

You are welcome !

A detach/ attach...

If you are going to overwrite the mdf and ldf files at the secondary server (new server) the reportserverDB existing on that server will be overwritten and will be lost....

It looks like you have not tested to run the query you posted.

I tried and found few errors. Firstly, the tables do not have Identity Columns so Set Identitiy...

Have you tried at the View Dependencies menu option from the popup menu?