How did you get to SQL 2008? Was this a fresh install?

Also, what are your reasons for wanting to upgrade to 2008R2? Its worth noting the server restrictions differ...

I dont think we have enough information. What are you trying to run?

You can use 3 part naming to reference something in another database like this.

database.dbo.object

Or you could create...

I generally use this to generate the TSQL.

select 'exec sp_dropsubscription @publication = N''' + sp.name + '''' + ', @article = N''' + sa.name + '''' +...

Except in servers under extreme load the performance hit caused by mirroring is negligable. Data loss can be zero with syncronous mode.

You dont need an identity column to replicate a table. You do require a unique identifier or primary key so that replication can keep track of the rows

Alexander Chacon (7/26/2011)

---

Hello all, resolution of this appears to be not related to hardware at all but actually from going to SQL Server 2008 R1 to R2 and differences with...

Alexander Chacon (7/26/2011)

---

Hi as2higpark, how can I pull those statistics during the execution of a query?

Thanks

Alex C

as2higpark (7/26/2011)

---

Alex,

When you are seeing issues on the new server, what is the...

I contacted our account manager who raised the call with the sql server support team.

Hi guys,

I probably should have said that my system was also responsive all of the time but on what appeared to be random occasions a random query would take an...

This is the one

http://support.microsoft.com/kb/979149

You can implement a work around by setting a min and max memory setting and "lock pages in memory" security policy. I had a call with...

The are a couple of things I had to do to resolve a similar issue an AMD server I introduced a while ago.

1. I disabled cool n quiet in the...

I would have guessed the easiest answer is the page size would be a legacy from the engine's Sybase days.

Why Microsoft havent changed this or implemented adaptive pages sizes I...

Since this is a published view i'm not sure it will be delivered successfully without the orders object existing first.

Mh-397891 (7/14/2011)

---

Create view dbo.Orders

as

Select col1,col2,col3,col4...

I'm not entirely sure I follow you. DDL might be useful showing us the source articles and what you want to see at the subscriber.

If I understand you correctly...

winash (7/14/2011)

---

I'm not sure about the behaviour.

From this link:

Problem 2: Updates to Primary Keys

1) Every row updated on the publisher can also...