Interested to Buy Any Domain ? << Click Here >> for more details...
How to get last system shutdown time in Sql server when
restarted system?
- 1 Answers
- 9056 Views
- I also Faced
- E-Mail Answers
SELECT * from
sys.databases
is used for find the id of database.
SELECT create_date
FROM sys.databases
WHERE database_id = 2
Tempdb db is recreated each time SQL Server is restarted so
the created date time of TEMPDB will also give you the date
and time of the last restart of the instance.
| Is This Answer Correct ? | 8 Yes | 6 No |
How many index keys possible for a table
What is a result set object returned by mssql_query()?
Is it possible to update the views? If yes, how, if not, why?
What are locks in sql?
what is package configuration variable?How to change file name in folder dynamically?Plz help me
Is index a datbase objects in sql server?
what stored procedure would you use to view lock information? : Sql server administration
What are the difference between clustered and a non-clustered index?
What is a non equi join?
What is serializable?
How do you drop an index?
How to find the date and time of last updated table?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
