Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kumar1248
Starting Member
20 Posts |
 Posted - 2009-06-24 : 17:19:23
|
| Hi Team,I am looking for solution that can chagne Database create_date value. I tried on web but no luck, so putting in the forum. I know its not advisable to touch system tables/values, but i want to tweak it if it is possible. Say for example. I created a database MyWORKS last month. But i want to change this value to Today's date for Create_date.Please advice.Thanks,Kumar. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-24 : 18:50:22
|
Hide someones track?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
kumar1248
Starting Member
20 Posts |
Posted - 2009-06-24 : 19:34:00
|
| Yes. I know this dangerous and absurd. But i am just curious about "can we change these types of properites?" Team, If you feel this is something that comes under Hacking something and not a discussion under this forum , then please forgive me and dont answer.Thanks,Kumar. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2009-06-24 : 19:50:55
|
this should work. has a side-effect of losing all data though.use mastergodrop database MyWORKSgocreate database MyWORKSgo
elsasoft.org |
|
|
|
kumar1248
Starting Member
20 Posts |
Posted - 2009-06-25 : 11:48:16
|
| Hello Jezemine,This forum is not for humor. |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2009-06-25 : 12:07:10
|
| Ooh, you done been SERVED, jez!No more funny stuff, ya hear?________________________________________________If it is not practically useful, then it is practically useless.________________________________________________ |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
|
|
|
|
|
|
|
How can overwrite created date of a database ?