Here is what my table looks like:

CREATE TABLE [schema].[census_date](

[id_col] [int] IDENTITY(1,1) NOT NULL,

[start_dtime] [datetime] NOT NULL,

[end_dtime] [datetime] NOT NULL

I'm fairly sure I have the format correct.

When I run your select...

No trigger.

This is a 2008 sql server. I accidentally posted under 2005 forum.

Pretty sure you get an email (with a Cert ID)...then you can sign onto the mcp.microsoft.com site and print your certification.

Congrats, nice work! 🙂

I got a chuckle...nice.

Been there done that...struggle all day, come in the next day and, D'oh, I should have thought of that. 😀

Ah...thanks!

I passed mine a couple of days ago too! I'm planning to take 70-450 next.

Yes, it gave me just what I was looking for. Thank you!

Understood. You are absolutely correct and I will definitely apply this lesson learned in the future.

Thank you very much for assisting me despite my short sightedness.

Yeah, I realized it looked like crap and I was just reviewing the Forum Ettiquettes to correct it. Sorry

I thought it would be a quick an easy select for the...

See if this script helps:

http://www.sqlservercentral.com/scripts/backup+restore+recovery/70539/

Thanks for your reply.

We do have nightly Full Backups and hourly log backups from 8 am to 6 pm.

😀 Awesome

Thanks for your response, that is a good idea.

But do you think my ReOrg Maint Job would be sufficient?

If it is ReOrg'ing all the indexes in all the tables of...

Dave Ballantyne (1/10/2010)

---

I recently went to buy a simple car of all things. I went into the showroom and said "I want a car!".

God , you would not believe...

Check out: "The Dude"

No not the Big Lebowski...the monitor software: http://www.mikrotik.com/thedude.php

It is free. We use it. Like the others said...you wouldn't install it on the SQL...