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 is sub query and its properties?

0 Answers  

---

define and explain the differences between clustered and non-clustered indexes.

0 Answers   Microsoft,

---

What is a Join and explain its types?

0 Answers  

---

How to fetch the next row from a cursor with a "fetch" statement?

0 Answers  

---

difference between select column name from table name where serviceid=2; and select max(column name) from table name where serviceid=2; IN ORACLE

3 Answers   Intel, Wipro,

---

What are the steps to follow to configure SQL*Net?

0 Answers   Tech Mahindra,

---

Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

2 Answers   Techno Solutions,

---

Define the term DML, DDL and DTL?

1 Answers  

---

What are the different ways you can create databases in sql server?

0 Answers  

---

What is Extended user-defined?

0 Answers  

---

What is surrogate key? : sql server analysis services, ssas

0 Answers  

---

How to handle error or exception in sql?

0 Answers  

---