Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How To Find That One Week Change in My DataBase we Have Done
Like We Have A database Test I Change Table,Stored Procd.
Then I Find Which SP,Table We Have Edit/Change in Seven
Dayes

Question Posted / dinesh sharma


How To Find That One Week Change in My DataBase we Have Done Like We Have A database Test I Change ..

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

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How to bind a view to the schema of the underlying tables?

0 Answers  

What is difference between process and thread? Explain lazy writer funcationality.

2 Answers   Microsoft,

In join, which clause in not used?

4 Answers   HCL, NIIT, TCS,

What is standby servers? Explain types of standby servers.

0 Answers  

What is single-user mode?

0 Answers  

What are the features of Embedded SQL

0 Answers   HCL,

Why do we need different type of parameter?

0 Answers  

If user is owning any SQL Objects, can we drop that user

0 Answers  

what type of indexes physically sort data?

3 Answers  

Explain difference between cross join and full outer join?

0 Answers  

Do you know the cursor types?

0 Answers  

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

0 Answers   Microsoft,

For more SQL Server Interview Questions Click Here
Categories