Old thread, I know, but...

I ran into this same issue recently, with a SQL Server 2008R2 instance. We recently had network "issues" and had an agent job that was failing,...

Actually, Paul's blog was the first place I went, but I browsed through a little too quickly, it seems. Steve, I have backups that are failing when they get...

Mr. Factor wrote a really good article on administering SQL Servers with CMS. In the article, he writes of the tables that you can use to manage your registered servers:

https://www.simple-talk.com/sql/sql-tools/registered-servers-and--central-management-server-stores/

I...

That may be where I go with it. While the common configuration may be convenient in the respect that we can indicate several configurations with one config filter, it is...

It was desired to have the ability to update the connection string to the...

We are using a SQL Server configuration. We have the env. variable pointing to an XML config that holds the SSIS database connection string, and the EnvType. For database connection...

I guess I'm more looking at is what happens to the SSIS package when the DBA does that. When the DBA opens the package, the configs are loaded from the...

Thanks Koen, that is pretty much the same conclusion that I came to.

We certainly do not want to disable logging, in fact, we are using logging quite extensively throughout...

Sorry for the delay in this reply...

I changed the account my SQL Server service uses to logon to use my network ID, restarted the service, and the TableDiff worked! I...

These are my machines that I use to test, develop, etc., so changing the service account isnt a big deal. We have designated service accounts in our Production environments, so...

Thank you for your reply, Lowell. What you describe in your post makes perfect sense. My services are running as Local System on both source machines. I will make the...

It would be a semi-colon. I misspoke earlier when I said comma. Use the ;

You would just use the profile that you were using before. All you need to do is edit the operator that you are sending the mail to now, and update...

When you create the operator, you can supply a list of email addresses, each separated by a comma. Set up your addresses there, and use that operator as your notification...

Lately, I have seen more and more applications create Agent jobs for "grooming" the database. Mostly re-index jobs, and "clean-up" jobs, they are typically created by the application, and invoked...