Thx guys

Hi richard,

"Im aware that I need to recreate this FK each time I re-intialise replication" you stated is not true. The process you went through to create your publication will...

view the "Uncommitted Command" tab in Replication Monitor, it will show was is pending and estimated time for delivering these updates to subscriber.

"This will not be applied to the subscribers unless you reinitialise the subscriptions"

I find the above not to be true, if the distribution agent is continuosly running everything should be...

First off, you can use the replication monitor to see the status of ur transaction.

Where as you want to view it's status after 1 sec, all you have to...

K, thx for the help

Thanks guys, i opted to use Developers edition instead.

ok i passed 70-229 today.....

70-228 to go

thx man

i already hold MCSA 2003 with 1 other elective, so i only require 228-229 to become MCDBA. I never said anything about BI.......doesn't matter at this point wut i'll have...

Well i'm close to finishing up studying for these two, I hope to write these two exams by next week. I plan to just do an upgrade after to sql...

i agree, something terribly wrong with this site

Thx allot Matt

much respect

>>pregnancy history table contain pregnancies (or delivery dates) that might not be in Current pregnancy table. The history table has delivery dates as Years only while the current table has full (day,month,year)...

ok, well there are two tables one with pregnacy hist and the other with current pregnacy.

What i want to do is the count the total number of pregnacy greater than...