I have spent nearly a week on this issue, searched far and wide, read every book I can get my hands on, and learned far more than I expected about everything but the problem I am experiencing.

Here is the situation:

Windows 2000 server sp3
X86 Family
327,208 RAM
80 GB HD

SQL server 2000 sp3
User Databases
sbb ~ 300 megs
aw ~ 150 megs
Both db's Are:
Status=ONLINE,
Updateability=READ_WRITE,
UserAccess=MULTI_USER,
Recovery=FULL,
Version=539,
Collation=SQL_Latin1_General_CP1_CI_AS,
SQLSortOrder=52,
IsTornPageDetectionEnabled,
IsAutoCreateStatistics,
IsAutoUpdateStatistics,
IsPublished

Configured as publisher and distributor
Push Publishing to
SQL server 2000 sp3 configured as subscriber on identical machine in same subnet.
User Databases
sbb
aw
Both db's Are:
Status=ONLINE,
Updateability=READ_WRITE,
UserAccess=MULTI_USER,
Recovery=FULL,
Version=539,
Collation=SQL_Latin1_General_CP1_CI_AS,
SQLSortOrder=52,
IsTornPageDetectionEnabled,
IsAutoCreateStatistics,
IsAutoUpdateStatistics

Logins for both are identical:
Name Type Server Access Default Database
affwiz Standard Permit aw
larry Standard Permit sbb

Affwiz is a system admin (sql)
Larry is a system admin (sql)

Two publications

Sbb - Working
push transactional continuous
not updateable
default expiration
native sql snapshot format
default snapshot folder
pull subscriptions not allowed
all rows/columns of all tables published

snapshot agent runs fine - owner is sa
log reader runs fine
distribution agent runs fine - the profile is verbose history

AW - Not Working
push transactional continuous
not updateable
default expiration
native sql snapshot format
default snapshot folder
pull subscriptions not allowed
all rows/columns of all tables published

snapshot agent BREAKS - owner is sa
Error is "Invalid object name 'sysarticles'"
log reader runs fine
distribution agent runs fine - the profile is verbose history

I've deleted the distribution database and recreated it. No luck
I've killed publishing , distribution, and subscriptions and rebuilt them. No luck.
I've looked at the AW database to ensure that the table 'sysarticles' is indeed there. It is.

Still, I get the same error "Invalid object name 'sysarticles'".
It is error 208.
My question is this.

How does the snapshot agent know where to look for 'sysarticles'?

And, how can I watch this process more closely than in EM?

Regards

Njama Braasch