Answer / sandeep modapathi

just run this query

SELECT * FROM SYS.OBJECTS
WHERE TYPE='P' AND (CREATE_DATE>'<Date>' OR
MODIFY_DATE>'<Date>')

This query will return all the SPs modified or created
after the date specified. You can change the filter
condition according to your purpose.

For Tables ... use this query

SELECT * FROM SYS.TABLES
WHERE CREATE_DATE>'<Date>' OR MODIFY_DATE>'<Date>'

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

7 Answers   IBM, TCS,

---

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

0 Answers  

---

What happens if time-only values are provided as date and time literals?

0 Answers  

---

How do clustered indexes store data?

0 Answers  

---

List some advantages and disadvantages of stored procedure?

0 Answers  

---

Does partitioning improve performance sql server?

0 Answers  

---

What is 2nf example?

0 Answers  

---

What is tablesample?

0 Answers  

---

What is master database? : SQL Server Architecture

0 Answers  

---

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

0 Answers  

---

What is dbcc updateusage?

0 Answers  

---

Is BCNF better than 2NF & 3NF? Why?

0 Answers   Akamai Technologies,

---