how to check the db schema?

Sorry, I am newbee DBA

Hi room,

Thank you for your responses.  I am setup Transactional Replication using snapshoot.

Thank youuuuuuuuuu

I figure it out!! and it works now. 

But run into different problems!!!  My mail did not show up iin the Notification dropwdown box.

After applying SP3, it works!!!!!!!!!!!

Thank youuuuuuuuuu.

The sweetwater_log.ldf  1,024KB and the sweetwater_data.mdf 25.2 GB.

C drive has available space 37.7 GB.

The replication will be failed when sweetwater_log.ldf grow until 37 ++ GB.

Thank you.

Ed 

The SQL Server 2000 sweetwater database is already set to RECOVERY SIMPLE mode.

Here are the way I confirmed the database model:

1. Open Enterprise Manager

2. Right click the sweetwater database

3. Click...

Hi Jeff,

Thank you for your response.  I did not intially setup the database.  It was setup by our Senior DBA. 

Agreed!! that the SQL Server 2000 at least should...

Hi I am newbee DBA.  I run into a problems that everytimes I run a setup replication from Server A to replicate Server B.

The Server B SQL Server 2000...

The Server B database currently set  Recovery mode to be SIMPLE!!!!

Did it cause the log file keep increasing?

Thank you.

Ed

Microsoft SQL Server 2000 - 8.00.194 (Intel X86).

Thank you  JG.

Edwin

The SQL Server 2000 version 5.2 and build 3790 with SP1.

Thanks

I am working a company that I am the only IT guy as SQL DBA.   There is a guy gave me a hard time since I jointed by smashing his...