Answer Posted / gaurav.verma4210

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.

What is field with example?

914

---

What is the purpose of optimization?

985

---

How we can refresh the view?

1102

---

How to execute stored procedure in select statement sql server?

1045

---

What is built-in function?

993

---

How to convert a unicode strings to non-unicode strings?

1092

---

System requirements for sql server 2005 express edition?

1001

---

Can we write trigger for view?

998

---

What are the different sql server versions?

970

---

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1096

---

What is the recommended total size of your memory optimized tables?

959

---

How to run queries with sql server management studio express?

1076

---

What does the not null constraint do?

1070

---

What are the different authentication modes in sql server?

1100

---

How to connect to SQL Azure Database by using sqlcmd?

136

---