login distributor_admin problem

Hi I am trying to disable a transactional replication on a server but its giving this error message.Login 'Distributor_admin' is aliased or mapped to a user in one or more databases. drop the user or alias before dropping the login.Thank you for your help

Query question

**EDIT wow, just noticed that chopped off half my post and my whole question....here's goes again... Well you guys hooked me up before so I return with another question. This is much like my last question just using different tables.I have the following query, which returns all the groups a particlular user is in. The 3 […]

RE: Adding column/Table in Transactional Replication

I've never had a problem with sp_repladdcolumn!As for adding a new table to the replication process, you will have to add it to the publication and either redo the snapshot so that the subscriber gets the new publication or just create the table on the subscriber so that you don't have to perform the snapshot […]

RE: DB Design Question

1) Is 3rd normal form a good goal to shoot for when designing a DB?  Or, is that probably "too normalized" in practice because it's probably "asking for trouble" later on when trying to optimize?I would personnaly say the goal is all normal forms that can be reached. I have studied and studied these to […]

What is the minimum permissions you would need...

You would like to grant all access on...

RE: Cannot reinstate jobs on Master Server ...........

Is there a need to update the sysjob table?It is obvious the master server uses this. Mike

Need a company to manage our database in their location

I am an intern and new to this business. I need to find a reliable company to manage our database in their location and give us a remote access.Any suggestion?

RE: Ignoring INSERT errors in job steps

Cheers Jonathan I'll have a look

RE: How to Compute Actual Space Used In Datafiles

Just another trick for you...if you turn on profiler and filter on your Windows account you can then capture anything that is done on your behalf by EM.  For instance, displaying the taskpad view of a database in EM is accomplished by running some 'code' against the master and other database tables.  By profiling yourself […]