OK, I figured the answer. Can't have a dash in the object name. Thank Enterprise Manager! With friends like this, who needs enemies?

Thanks a lot people! I was pondering over these different approches and it's encouraging to hear that they are all legit.

It's a nice way to convert my dates into a desired character format. However, my question is about achieving this date-only format WITHIN the database. Like a "DATE", not DATETIME...

Thanks!

I don't like working Saturdays either...

ok, I checked BOL for Convert and Cast functions. They allow me to covert one datatype to another. However there is no "date-only" datatype in SQLServer that I am aware...

Thanks!

Thank you. That worked as far as telling me when the database was created on THAT COMPUTER. However, it turned out, that the database was moved there from the old...