You should check dynamics filter in merge replication. You can use functions likes @@SERVERNAME in the filter to apply changes.

Check in BOL for dynamic filters

If you mean that QA or EM won't open, then you should re install the client tools from the CD again.

I don't think you can.

You should bulk insert into a temp table, and then insert into the staging table adding the department id.

The stored procedure AddLogin will only have the exec of the sp_grantdbaccess @loginID line, because the GO marks the end of the sp.

The other two commands (grants) are not part...

You should always backup the distribution db, but depeding of what type of replication are you using it will change the strategy  you use.

 the most critical should be if you...

Are you running the xp_sendmail from a Job?

Can you post the code you used?

We are using MOM for our 100+ servers.

For me it was a good solution. Every time I need to be notified by any process, and just save the message, or...

You shold run the merge agent from the command line to get the log of what is happening. You can check all the parameters in bol by searching for "Merge...

First you should try DBCC INDEXDEFRAG, because this one won't lock the index while defragmenting it.

With DBCC ShowContig you can know wich indexes are fragmented. I have decided that if...

You are both right, but if you use a variable to catch the status you can confirm the error.

Try;

DECLARE @status AS INT

Insert Into #size EXEC @status = Master..xp_getfiledetails 'c:\bogus_file.txt'

PRINT @status

If...

You could create your own stored procedure wich have the same parameters of sp_Addlogin.

Pass the encripted password to your sp, desencript it and then from with in the sp, call...

Try executing sp_who2 or sp_who

The files are OK and the contest is OK too.

If anybody doesn't like it, then don't participate.

Do you have any recent backup?

DELETE Pipes

FROM Item a INNER JOIN Pipes b

ON a.ItemNo = b.IPartID

AND a.SWCode = b.SPostID

WHERE a.SWCode = @Variable

This will delete from pipes all the records that exists on both tables.