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...

You'd have to build something or use a product like SQLCentric, BMC's Patrol, etc.

Sorry that you didn't like the topic. It's hard to write about SQL everyday .

While I did focus on the US and it's H1-B...

Your example can handle some things, but it's not as clean, not does it easily work with non-US phones, etc. Using a CLR language and regular expressions, it's more flexible...