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>'

What do you need to connect php to sql server?

0 Answers  

---

What is Peer to peer Replication?

1 Answers   CarrizalSoft Technologies, HCL,

---

If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 Answers  

---

What is awe?

0 Answers  

---

How to use group functions in the select clause in ms sql server?

0 Answers  

---

---

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

---

Is there any difference between primary key and unique with the not null condition?

0 Answers  

---

What is the difference between windows authentication and sql server authentication

7 Answers   HCL,

---

What is save transaction and save point?

0 Answers  

---

How many ways to create table-valued functions?

0 Answers  

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

0 Answers  

---

How does normalization work?

0 Answers  

---