Don't know if it helped the original poster, but that link you posted sorted out our FTS as we had exactly the same issue. Many thanks.

Seems odd though that MS...

Unfortunately, I don't think there is anything you can do because, as you rightly point out, the names can exist in many places with no guarantee that they are actually...

No worries. Glad I can help out and give something back to the community for a change!

Steve

Hi

Assuming you have the right fields in your customer table, then getting the notes is a simple matter of joining on your unique identifier (the aggregate key of ID and...

Are you certain that the permissions on the linked server are correct? When you run the SP manually, it may be that your personal credentials (or whatever you've used to...

I forgot to mention that the userAccountControl <> 514 condition filters out all users flagged as inactive but not users who have just been disabled, for example. If you want...

Right.

My memory is a little hazy as it was a while ago that I did this and stupidly, when I left the company last year (in a hurry because I...

Been there and done that - but haven't got the code on me! I'll look it up tonight after work and see if I can't post a solution for you...

Hi Mark

We checked the accounts and they were correct so we added the verbose logging as suggested and it was just the ticket. As a result, we discovered firstly that...

Just to check, are you trying to create a database using an account that is a member of the sys admins group? If not, that'll be your problem so you'll...

Thanks for the reply but if you read my previous post, you will see that we know how to add the scripts to the replication job but the issue we...

Further to my last post, whils searching for DtsRunDec (the decoder app), I found this thread on sqlforums.com. One chap (jamespua, near bottom of page) says that if you...

It is possible to decrypt the name as I once found a utility written by a Russian dude which did it. It was a bit scrappy and errored but it...