I suppose you could also reduce the risk by mapping commands to queries and not allowing anything ad-hoc. Kind of like how yubnub[/url] works.

I guess what I meant to say was that SPNs are a "something outside of SQL" thing. Thanks for keeping me honest Brian.

As MarkusB indicated, the built-in reports (which you were originally asking about) are not stored on disk; Manu was referring to the performance dashboard reports which are a seperate download...

I believe you're talking about sp_processmail, but in general it's not really recommended that you do this because you could blindly execute malicious code that does nasty things to trash...

I'm betting you're using the default distribution agent profile. That profile uses a "HistoryVerboseLevel" setting of 1 which continually overwrites the most recent history message of the same status type....

You are correct in your order of events. You can avoid resynchronizing by applying the same PK change on your subscribers and then resubscribe without synchronization. If you go that...

Oh and the syntax is the same for SQL2000 as it is for SQL2005; a SPN is an AD thing so it's not specific to a SQL version.

Mike,

Check out these two blog posts for more info about SPNs. You run setspn on the command line and typically your domain admin does it (or you, if you've got...

What you're describing is a central subscriber model that sounds more appropriate for transactional replication. If you're using identity columns as your primary key then you have two choices to...

So the B servers don't need to know anything about the data that's been entered at the other B's?

Are you bound to a particular schema, or do you have the...

Repeating what I think you want to make sure I understand: Server A only holds the data that was entered at Server A, but data can be inserted\updated\deleted on A...

This script generates a script to grant server role memberships and permissions. I don't remember where I got it from or I would give credit.

[font="Courier New"]SET NOCOUNT ON

SELECT  'USE' + SPACE(1)...

This script generates a script to create database users, roles, permissions, etc. for the database you're currently in. It's based on this script from Narayana Vyas Kondreddi.

[font="Courier New"]

SET NOCOUNT ON

SELECT  'USE'...

Check out SQLPermissions from Idera. It's free and should give you what you're looking for.

http://www.idera.com/Products/SQLpermissions/Default.aspx

I'll post some scripts that show you this also. Tools are great but it's also good...

In mixed mode with a SQL login credentials will be transmitted to the linked server in clear text. You will also have to deal with password management, i.e. changing passwords...