Answer / narasimha

Select redo_start_lsn from sys.master_files where
database_id = db_id('SecondaryDatabaseName') and type = 0

Answer / sunil

Narasimha, Thank you So much

I will very appreciate if you will send some daily usage
SQL DBA Queries like this. My mail ID is sqldba29 @
gmail.com

write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car

12 Answers   Cognizant, TCS,

---

Is sql server free?

0 Answers  

---

How to provide values to user defined function parameters?

0 Answers  

---

How to delete a database in ms sql server?

0 Answers  

---

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

0 Answers  

---

---

what are the limitations of parameters in a storedprocedure

1 Answers  

---

how can you move the master database

1 Answers   IBM,

---

UPDATE statement can on a single table or on the multiple table?

7 Answers   iGate, TCS,

---

How would you add a section to a table?

0 Answers  

---

select name of emplyoee whose total salary is 130 from following table. id name salary 1 a 100 2 b 20 3 c 50 1 a 30 2 b 70 Post the resulantant Query?

7 Answers  

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

0 Answers   MCN Solutions,

---

What is the difference between Stored Procedures and triggers?

0 Answers   HCL,

---