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 |
How do I open port 1433?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
What is a Join in SQL Server?
Can we have more than one NULL in a column having unique constraint?
What is enhanced database mirroring in sql server 2008?
How to convert binary strings into integers in ms sql server?
Wht is Stuff in sql ser
How to install sql server 2005 express edition?
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
What do you do in data exploration
What is a cursor, index in sql?
Do you know what are different types of replication in sql server?
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)