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

Francisco,

I haven't seen may good cases, but a few interesting ones were check constraints on tables. Trying to be sure that an IP address was valid, or that a...

I'd agree that MySQL and others will start to integrate other languages into the RDBMS engines, but I don't think SQL will die. For what it can be used for,...

Check the netstat command from a command prompt. Be sure that there is a listener running for your server on that IP. Also, this could be because the SMTP service...

If that gives you problems, be sure you close the object browser in QA. It uses it's own connection.