How to get last system shutdown time in Sql server when
restarted system?
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 |
What is trigger in salesforce?
What is database replicaion? What are the different types of replication you can set up in SQL Server?
5 Answers Aptech, HCL, Perpetual, SAIC,
Data table as parameter in sql server?
How to download and install microsoft .net framework version 2.0?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
what are default? Is there a column to which a default cant be bound?
can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?
What do you mean by COLLATION?
Name few of the dcl commands in sql?
which backup strategy you are following at ur company
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
How display code or Text of Stored Procedure using Sql query 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)