Awsome, exactly what I was looking for! My thanks to the original poster for adding his solution and all respondents for their suggestions.

James.

I use to think that "wide" experience, such as I have, made me a better DBA and overall better asset for my organization. I would not trade my wide...

As long as you...

Anything over 40 hours I'm "asked" to work gets compensated, either as Over Time or Comp Time. I usually have my choice, and depending on the amount of hours...

Andeavour (6/29/2009)

---

Well James, your position sounds prety perfect to me. In fact if you want a replacement I'd be only too happy to step in (20 years working with a...

I'm nearly 50 now so retiring in the next year is highly unlikely 😀

However I think I'm in the perfect job now (I've had to work to get here) but...

Thank you for answering your own question, It assisted me greatly. To answer your second question simply run the stored procedure without the second paramer (example: sp_fulltext_service 'verify_signature') and...

The backup is not complete until I've restored it on a test machine. I know not everyone has this capability but since I've always been on small teams that...

bob.willsie (1/5/2009)

---

Thirty Now, n+ languages later, and 30 years wiser, I document the hell out of anything but the simplest code.

Why?

Because at 3:00am, after you've been burning your...

I work for the US Government and have for 15 or my 20 years programming. When I was first starting I hated documenting anything other than the inline comments...

I don't know about using a View and a Trigger but you might look into using a Stored Procedure. In theory it could take all the data and perform...

Your Welcome, I still pop in every day and review several posts but have not had the time to...

Nice article Jeff. Great "how to" without being to pushy. Nothing puts me off answering a post like having to much "up front" work so I can test...

Patrick, as far as I know Enterprise Edition will run on anything Standard Edition will run on, but like anything else you'll get better performance with better equipment and...

Colin, I don't think I missed the point (maybe didn't articulate it well) but the point was "What...