Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

What's changed recently? Expand / Collapse
Author
Message
Posted Friday, May 31, 2013 10:39 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, October 18, 2016 2:55 AM
Points: 56, Visits: 1,037
Comments posted to this topic are about the item What's changed recently?
Post #1458794
Posted Monday, July 1, 2013 6:56 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, February 29, 2016 9:46 AM
Points: 555, Visits: 465
SQL 2000, at least from what I can determine would be.

SELECT TOP 22 * FROM sysobjects ORDER BY refdate DESC
Post #1469036
Posted Saturday, November 15, 2014 8:54 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, December 2, 2016 1:42 PM
Points: 2,940, Visits: 3,702
Thanks for this! But why select the top 22 only?

- webrunner


-------------------
"I love spending twice as long and working twice as hard to get half as much done!" – Nobody ever.
Ref.: http://www.adminarsenal.com/admin-arsenal-blog/powershell-how-to-write-your-first-powershell-script

"Operator! Give me the number for 911!" - Homer Simpson

"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Post #1635328
Posted Sunday, November 16, 2014 2:21 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, October 18, 2016 2:55 AM
Points: 56, Visits: 1,037
Hi

Typically only a small number of rows have changed recently (unless there's been a table defrag), I want a small number of rows, so 22 seems appropriate... 11 or 33 etc are also good

Ian
Post #1635335
Posted Wednesday, November 19, 2014 2:05 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, December 2, 2016 1:42 PM
Points: 2,940, Visits: 3,702
ianstirk (11/16/2014)
Hi

Typically only a small number of rows have changed recently (unless there's been a table defrag), I want a small number of rows, so 22 seems appropriate... 11 or 33 etc are also good

Ian


Ah, OK - thanks!

- webrunner


-------------------
"I love spending twice as long and working twice as hard to get half as much done!" – Nobody ever.
Ref.: http://www.adminarsenal.com/admin-arsenal-blog/powershell-how-to-write-your-first-powershell-script

"Operator! Give me the number for 911!" - Homer Simpson

"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Post #1636494
Posted Tuesday, October 20, 2015 2:53 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, November 28, 2016 10:13 AM
Points: 154, Visits: 281
IS SQL 2012, add "where object_id > 0" to exclude temporary objects
Post #1729220
Posted Tuesday, October 20, 2015 6:29 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 8:52 AM
Points: 4,792, Visits: 7,358
Short and sweet!

______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1729297
Posted Tuesday, October 20, 2015 6:41 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 29, 2016 7:14 AM
Points: 17, Visits: 126
Object schema is sometimes good to know.
select "Schema" = object_schema_name(so.object_id), * from sys.objects as so
where so.modify_date > dateadd(month, -2, getdate()) and so.object_id > 0
order by "Schema", so.modify_date desc;

Post #1729300
Posted Wednesday, October 21, 2015 6:45 AM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 7:49 AM
Points: 8,308, Visits: 854
What a great little script, thanks.
Post #1729662
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse