question

PupaPantananan-9004 avatar image
0 Votes"
PupaPantananan-9004 asked PupaPantananan-9004 commented

why sa account show create_date 2003-04-08

i need to knows why sa account show create_date 2003-04-08

sql-server-generalsql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CarlFan-MSFT avatar image
1 Vote"
CarlFan-MSFT answered

Hi,
Based on my search, it seems that the date the new master database was created at Microsoft for SQL Server 2005.

For SQL Server 2012, 2014 and 2016 and all have the exact same date/time.

It is default databases created date by Microsoft.

For more detailed information about SQL, I suggest that you'd better post the issue to SQL forum. I will help to change your tag.
Hope this helps and please help to accept as Answer if the response is useful.
Best Regards,
Carl

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
1 Vote"
OlafHelper-2800 answered PupaPantananan-9004 commented

i need to knows

Why do you "need" that information?

Every database (incl. system DB) are copies of the "model" database and if you lockup the database principals (= roles & user) of "models", they have all the same create-date 2003-04-08.
I guess that's the date, when the "model" DB was created first.



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

my customer need to knows that but i don't knows :(

0 Votes 0 ·