This content has been marked as final. Show 3 replies
I know that for Oracle I can query created in v$database.
Do you know for SQLSERVER in which db table I can find it ?
I ran select LASTREFRESHDTTM from PSSTATUS on SQLSERVER db but it displays date of first creation. And if DB is refreshed in between ? Where is the last real refreshed time ?
Thanks and regards.
For SQL Server try
select name, crdate from master..sysdatabases where name = 'YOURDBNAME'
Edited by: RCC on Apr 4, 2013 9:53 AM
Any data in the tables is going to be refreshed down from production, so if you want to use a table to store this info I recommend building it into your refresh process. Sometimes it's nice to create a table outside of the PeopleSoft database such as in a administration schema or consolidated admin database that you insert into each refresh, it's nice to have the history sometimes.