I suspect it's a choice that you make for ease of admin or skillsets rather than a technical reason.

There are some procedures for decrypting stored procedures. Search on Google.

Do you need to companre the memberOf and Member fields or can you just replace what's there with the new data? If you did that everyday, that should work.

Alternatively, and...

Are you at the latest service pack? I know there were some leakage issues with the XML stuff. PSS might have a special hot fix for it as well.

No difference really. The job would run a stored proc of a DTS package, but the DTS could run your proc. If you have more than one task or want...

thanks for the update.

Igor,

Thanks. Would you like to post some of these in the script section?

Do you mean the actual server names from each connection? The object model of DTS supports this.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtsprog/dtspothobj_5x7t.asp

There isn't a good way to do this. You could use a stored procedure and run it in batches, say of 100 or 10 or something. That would give you...

Kishore,

The granularity of permissions and number in Yukon has greatly increased. There are schema permissions, definition permissions, etc. The idea is that you probably do not want to grant all...

Thanks for the complement on the writing

I used to hate generating this editorials because they take time and effort, but it's become kind...

Mary,

Yikes , I feel bad. Graduated in '89 with an Economics degree and I haven't heard of Dr. Samuelson.

Or at least I don't...

You can setup triggers to audit things. ApexSQL has a tool to automate this.

Profiler will catch the inserts/updates.

What are the processes doing? Have you run profiler and perf mon on the server when things hang?

It could be. Have you uninstalled other CTPs and reinstalled this one? I saw a thread somewhere on the Beta newsgroupw or Blogs about the fact that some COM components...