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 count groups returned with the group by clause in ms sql server?

0 Answers  

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

0 Answers  

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

0 Answers  

how to trace the traffic hitting a sql server? : Sql server database administration

0 Answers  

What are the different types of triggers in SQL SERVER?

0 Answers  

How to get number of days in a given year?

4 Answers   ADP,

what is the difference between procedure and function.

4 Answers   Thomson,

Can you insert NULL in unique column?

0 Answers   MCN Solutions,

which backup strategy you are following at ur company

0 Answers  

What is the new security features added in sql server 2016? : sql server security

0 Answers  

How many database files are there in sql server 2000?what are they?

0 Answers  

When we can say that is in BCNF?

3 Answers   BitWise,

For more SQL Server Interview Questions Click Here
Categories