Viewing 15 posts - 376 through 390 (of 1,292 total)
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...
January 3, 2010 at 8:57 pm
Luke L (12/31/2009)
Bru Medishetty (12/31/2009)
I had few horrific moments :w00t: today morning driving to work. So all those...
December 31, 2009 at 9:56 am
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...
December 31, 2009 at 9:23 am
May be possible using any 3rd party tools.
You can use scripting all objects in a database to achieve this.
December 30, 2009 at 11:45 am
nvkumar12 (12/30/2009)
we can use Attach&Detach methods
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...
December 30, 2009 at 10:23 am
cclancy (12/30/2009)
That returns proj 100 and 101. Only proj 100 uses the colors BLUE, RED and GREEN.
To get tested answers you need to provide the DDL and sample...
December 30, 2009 at 10:16 am
You could also use this way
Where COLOR IN ('RED','BLUE','GREEN' )
December 30, 2009 at 10:00 am
Do you know that "where" clause exists in SQL Server?
Use it, if not look in Books Online for it. 🙂
December 30, 2009 at 8:15 am
Make sure the MDF file is a dummy file you created for this test purpose.
December 30, 2009 at 8:12 am
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.
December 30, 2009 at 6:26 am
kareem007 (12/29/2009)
Thanks Medishetty!
You are welcome !
I tried with normal Restore with backup (overrite existing db)...that worked for me. In what way detach/attach better than restore backup.
A detach/ attach...
December 29, 2009 at 9:45 pm
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....
December 29, 2009 at 2:07 pm
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...
December 29, 2009 at 1:57 pm
Have you tried at the View Dependencies menu option from the popup menu?
December 29, 2009 at 1:41 pm
Viewing 15 posts - 376 through 390 (of 1,292 total)