Answer Posted / guest

in standby mode the database exists to access for readonly
purpose
we can use the database for read only we can not able to
modify

in no recovery mode the database is not accessible

How to display a past time in days, hours and minutes?

1003

---

What is the difference between count and distinct count?

869

---

What is the sql profiler?

927

---

What are system databases in ms sql server?

1024

---

How to create new databases with "create database" statements?

998

---

What are the default system databases in sql server 2000?

997

---

what's the maximum size of a row? : Sql server database administration

1061

---

What is the difference between local and global temporary tables?

1125

---

What is a synonym for manipulation?

968

---

How to read data in a table with "select" statements?

950

---

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1146

---

How to get a list of all tables with "sys.tables" view in ms sql server?

1020

---

Explain for xml explicit mode?

958

---

The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

998

---

How you can change the database name in SQL SERVER?

1171

---