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.

20 isn't that many. You might spend more time figuring this out than just installing.

Lumigent, ApexSQL, LogPI, all have transaction log reader products.

I don't believe that you can do this.

We got lost in the employee shuffle at Microsoft when our old contact moved on and it took awhile for a new one to appear. I spoke with him last...

Why was it poorly worded? The snapshot agent is an agent needed for replication and the security that should be assigned is important. Reducing your attack surface is something that...

Red Gate software has a low cost compare tool, advertised in the footer, which is highly rated and there is a review on the site. ApexSQL also has one.

You should probably schedule the reindexes for very, very low use times or setup the application to try reconnecting after a few minutes.

The DTS copy Objects task might work. If you don't have a direct connection, create a small db, copy just those procs in it and send the (small) backup to...