Let's try now to use replication tools to verify that all credentials and proxy stuff are setup properly.

Open Replication monitor

Then Right Click on the Publication and select "Properties"

From there go...

I have yet to see a case where code portability actually solved anything worthwhile for anyone. Doesn't mean they don't exist, just means I haven't seem them, in my...

No that just indicates that the user Does not...

branovuk (1/28/2009)

---

I have query which worked like charm :), 'till they asked for more.

Basically, it looks like:

_____________________

SELECT Item.ItemLookupCode, Item.Description, Supplier.SupplierName, SUM(TransactionEntry.Quantity) AS Sold,

Item.Quantity AS OnHand,

SUM(PurchaseOrderEntry.QuantityOrdered - PurchaseOrderEntry.QuantityReceivedToDate) AS...

I am sure MAXDOP will not help you anywhere there.

You must check the procedure piece by piece. On a first look it seems that too much IO is going on.

I...

TroyG (1/28/2009)

---

Hmm okay well I put those bits and peices into the job step and tried to start the job, but the "unknown security error" jumps up and the job...

MAXDOP is a QUERY option

So you have to specify it per-query (at the end of the query)

I am not sure that in your case you want to do that!

Boss: The company that just bought us loves your application and wants to start using it. The new data will total around 300 GB. How many days will...

If you can't post DDL it will be hard to tell you what the problem is!

SELECT t.ID, t.[Group], COALESCE(x.C,'Colonized')

FROM #mytable t

OUTER APPLY

( SELECT TOP (1) 'Not Colonized' as C

FROM #mytable t2

where t2.[Group] = 'ZGroup' ) x

Jeff Moden (1/28/2009)

---

Your last couple of sentences put that all together very nicely! I was aware of being able to put indexes on calculated columns, but didn't know you...

Jeff Moden (1/27/2009)

---

Haven't tried those yet, Noel... can you give us a quick "how...

colin Leversuch-Roberts (1/28/2009)

---

Just one point that as the data is in cache you don't need indexes - I'd like to meet the person who suggested this gives performance - pah!...

You won't probably be able to use 7.0 UI tools and the best way to set up the subscriber is going to be with TSQL stored procedures.

I have not used...

how do I get the log reader doing it's thing in verbose mode?

You open the SQL Agent Job that is running the LogReader and then add the Following parameters...