If it's not possible then I guess I'll stop trying to find a way and let the requester know. Thanks, this was quick 🙂

Changing permissions is the best way to handle this I agree, but a surprisingly slow battle. A large chunk of people run with SysAdmin even though only DBA's should...

Thanks for the quick answers.

If DDL triggers run after, why does the trigger I have that prevents someone from dropping a database work?

Hi I have the same problem, and I would like to find the error instead of ignoring it with the agent profile option. I have gotten as far as...

Hi I have the same problem, and I would like to find the error instead of ignoring it with the agent profile option. I have gotten as far as...

Thanks,

I have already found this stored procedure and set the shouldalert to 1. I have deleted a table in the subscription so that they would become out of sync...

Figured something out. The CMS machine's agent runs under service_account_1, but many of the servers that I am evaluating run under service_account_2. Not all the databases being evaluated...

I have a policy that checks for backups within the last 8 hours, and the EPM solution sounded very cool for this. Well it's not working out so well,...

I did try it out. I got that error below. So far it's been a good book. However the code examples are formatted a little strange. ...

Ok well that's just annoying.

I failed over one more time before tearing down replication to start again and now it's working. I hadn't changed anything. Thanks for the...

Well shoot. I guess I will have to try following it again for the third time. The example uses four servers, I only have 3 to work with.

I...

Well shoot I hate it when I post too soon! I found it was returning double because there where two agent types per publication, so a where clause on...

Not quite that simple, you have to also put a step in between the oldb connections to select the tables you want.

The transfer object task is pretty defunct. It will work the first time but anything after that if the table exists it will fail when trying to overwrite or...

Yes, if I put that path in explorer it goes to the rss file.