Archives: February 2013
Finding database creation time is simple if database has not been detached from server. You can find database creation time using below methods.
You can find the creation time of database using sp_hepldb system procedure.
EXEC sp_helpdb 'SqlAndMe'
This will return database creation time along with other… Read more
SQL Server error logs can fill up quickly, and when you are troubleshooting something you may need to go through huge log. However you can cycle the error log to manage the amount of log you need to go through. When you cycle error log the current log file is… Read more