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
- 9156 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 you can minimize the deadlock situation?
Explain the etl (extraction, transformation, and loading)?
How dts is used to extract, transform and consolidate data?
How many types of Cursor in SQL SERVER?
How to retrieve error messages using odbc_errormsg()?
What is read uncmmited?
Does union all remove duplicates?
What is WITH CHECK OPTION
3 Answers Karur Vysya Bank KVB,
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
How many partitions a clustered index has by default in sql server 2012?
What does this statement do @@rowcount?
How many types of subqueries are there in sql server?
-
Oracle (3253) - 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)
