I want is_published and is_subscribed to work. I have p2p replication for this one DB which also populates to another DB downstream but someone it's not setting the is_subscribed flag...

p2p works for is_published but if it just a regular transaction replication someone that flag isn't set. Thanks

Why I'm not also able to see INclude first-level subfolder options?

Here's the db info:

Microsoft SQL Server 2005 - 9.00.2153.00 (Intel X86)

May 8 2006 22:41:28

Copyright (c)...

except if explicitly enabled track changes in the background? Thanks, Dex

I totally agree on all your response.  Trust me, I've done a lot of development also in my days and I told them that this is not doable even in...

It's both.  We're trying to protect the data of course because it's very sensitive.  Sys Admin should not know what those data are even in the clients end.  Second is...

I just came on board with this company so I don't really know the health of those dbs.  Thanks!

Thanks Don.  Client shouldn't have the right to change anything on the DB and app.  If they change anything that has abnormal effect then we'll not support it. 

We are...

I truely agree on you but how can I control it when the DB is setting on the client's environment and have no control over it. Clients build the server, install...

Well some of our clients don't have full-time DBA and we just want to safeguard the clients from doing harm on the DB. 

To safeguard the data, we're implementing encryption...

I agree on you but I was looking for any functionality on 2005 that would disallow access to SA and give specific logins/access to DBAs.  We are trying to release...

If this is 2005 db, there's an online rebuild of index that you can use.  The only down fall is that it uses a lot of tempdb space so be...

Yea I would agree to use db mirroring.  FYI - mirroring is now supported on SP1. 

One issue that you'll probably encounter is that when you uninstall 2005, SQL 2000 won't work anymore since SQL 2005 will replace SQL 2000 binaries.  That's what I encountered so...

Setup will not balk if you don't configure MS DTC.  Actually you don't have to configure MS DTC if you don't do distributed transactions.  That will probably saves you disk...