Multiple distribution DB's , i dont think so.

Placing distributor DB will depend on which type of

replication you opt for Push or pull.

Hi

check this link

http://www.windowsecurity.com/articles/SQL_Server_2000_Authentication.html

sys and information_schemas are impartent, keep them and remove the guest. By default guest will have acess to all databases.

Do you mean to say each database for indivisual client on the same instance???

In Enterprise Manager, when you create a login, you can create and map it to a user.

Go to properties of login choose properties--> mapping then map to perticular...

Try this

DBCC freeproccache

Dbcc dropcleanbuffers

Try to limit PF usage between 4gb as a min and 6GB as a max.

Set AWE enabled.

NET START MSSQLSERVER

NET START MSSQLSERVER -m // Single user mode

NET STOP MSSQLSERVER

select * from TABLE order by DATE desc

Are you using SQL Server 64bit ??

PF usage will be more due memory issues.

If you have the problem with the user permissions you better use sp_change_user_login autofix option.

Yup, Better to check deadlocks in process @ subscriber level.

--> Check uncommited trans on subscriber end using repln monitor

--> I faced same issue but mine was little bit different i...

I hope we can change sync mode from continuosly to scheduled.

Thanks Gail(GilaMonster/Gail Shaw) for updating Me

YUp,

You are on SP3