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
- 8978 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 |
What is instead of trigger sql server?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
What is data source view or dsv? : sql server analysis services, ssas
Issues related in upgrading SQL Server 2000 to 2005 / 2008
How to start and end transact-sql statements?
What is normalization and what are the advantages of it?
Can a database be shrunk with users active?
What is difference between index and primary key?
hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?
7 Answers Google, TCS, Unisys,
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
How to see existing views in ms 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)
