How to update the Created Date on a table in SQL 2005 ?

Question

Post reply

How to update the Created Date on a table in SQL 2005 ?

theflyingdutchman

SSC Enthusiast

Points: 186
More actions
April 4, 2008 at 5:11 pm

#74872

Hello,
In SQL 2000, I was able to issue a SQL statement like this to update the Create Date:
update sysobjects
set crdate = getdate()
where name = 'CUSTOMER'
How would I issue a similar command in SQL 2005 ?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004318 More actions · Answer 1

Not sure what you're after... didn't you just use a single command?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

RBarryYoung SSC Guru Points: 143329 More actions · Answer 2

Generally speaking, direct manipultation of the System Tables is no longer possible in SQL 2005.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Jeff Moden SSC Guru Points: 1004318 More actions · Answer 3

Wow! I totally missed the fact that the object of the update was a system table.

Updating the system tables directly is "Death by SQL". Don't do it... period.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 4

I agree with Jeff and Barry, but what interests me is why would you want to change the date created of a table ?

[font="Verdana"]Markus Bohse[/font]