Good, handy snippet! Thanks for sharing.

Small point... watch your case on names. The code, as is, won't work on Case Sensitive systems.

The function names Fn_trace_getinfo & Fn_trace_gettable are not...

What a great thought experiment! :smooooth:

It was fun to watch the problem solving unfold and the answer develop.

These are the articles that keep me coming back.

Thanks a ton for...

Try parsing the output from the following command:

[font="Courier New"]mx vsql status[/font]

Regards;

Greg

Thank you Ian and George.

As I understand it:

- if we want a full DR test, with read/write capability, perform dual failovers

- if we only want validation of Log Shipping, pause/standby/resume

I'll...

Ian Scarlett (10/7/2009)

---

If you use the system stored procedures sp_change_primary_role and sp_change_secondary_role to switch the roles in the first place, and then use them to reverse the roles when you...

Wayne West (7/10/2009)

---

Not a piece of advice, per se, more of a vendor problem. When I started here, half the production databases were set to auto-close/shrink, most with simple...

I believe this is a worthwhile exercise. Nothing educates like experience.

The fear is that nefarious hackers would get hold of the site and turn it into a weapon against those...

One generic book that I have kept around is Database Management and Design by Hansen & Hansen - 1996. It's a little out of date on some stuff but covers...

Great news!

I was afraid that the log shipping configuration became the defacto backup.

Thanks a ton!

You can also use this for a down and dirty listing:

SELECT DISTINCT Extension

FROM Person

ORDER BY Extension

Regards;

Greg

With VMware you really have to look at a lot of your processor and disk queues to determine if you are getting the perfomance you seek.

VMware is exceptional for web...