Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /homepages/10/d214220746/htdocs/thecrankydba/wp-content/plugins/jetpack/_inc/lib/class.media-summary.php on line 77

Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /homepages/10/d214220746/htdocs/thecrankydba/wp-content/plugins/jetpack/_inc/lib/class.media-summary.php on line 87
Confirming Objects Modified | Mike Hillwig
Warning: count(): Parameter must be an array or an object that implements Countable in /homepages/10/d214220746/htdocs/thecrankydba/wp-includes/post-template.php on line 284

Confirming Objects Modified


November 15, 2011 by Mike Hillwig

I work in a hosting environment, and frequently our clients will ask us to promote a stored procedure (or some other schema object) through the DEV, TEST, Production environments. We have one client that is really big on seeing some type of evidence that we did what we say we did.

I wrote this little nugget that generates enough confirmation for the client’s relationship manager to demonstrate that we did indeed move their code. And it seems to make the client happy.

set nocount on

DECLARE @num_objects INT
DECLARE @object_type VARCHAR(3)

SELECT @dbname = 'userdatabasename' -- Use the database where the objects were moved
SELECT @num_objects = 1   -- Use the number of objects moved.
SELECT @object_type = 'P' -- Use P for procedures, F for functions, U for tables, V for views, etc. 


select @@servername

SELECT @sql = 'select top ' + cast(@num_objects as varchar) + 
' left(name,30) as object, object_id, modify_date from ' + @dbname +
'.sys.objects where type = ''' + @object_type + '''</pre>
<pre>order by modify_date desc'

EXEC (@sql)
  • Hi,I agree this is not something fancy, but, I’ll also quote mylesf I’m going to explain a non often used SQL that came in hand recently . The thing is, that this can help you with let’s say complex menu table (that for example contains n-level menu). Then you avoid the need to pull the menu with more than 1 query.And one more thing This article was intended for beginner to intermediate level of knowledge a simple example And thanks for opinions!

  • By Paul Riddle May 31, 2012 – 6:06 amHi, I am enquiring about sheet music for one of your pieces. A student of mine is wishing to perform ‘Big City’, is there any possibility of purchasing band charts for ‘Big City’?Cheers,Paul Riddle

  • Pauta na corrupção e na justiça (ou injustiça)que atualmente assola o país, graças ao PT e ao FHC (que já está na hora de ir embora da vida pública, para todo sempre).

  • I'm a fan of bags of playground sand or premixed concrete in the trunk, myself. And if I were up the the Great White North and had an over-torqued RWD roadster (but wait– you've got a button for the torque), I'd look into snow cleats. Cheap, and easier to put on than chains. But I live down here in the SW Plains, and drive a little FWD car, so I don't screw with it.

  • que lugar mas hermoso y pintoresco ya que esta nuestra madre,, mirandonos, ademas podemos disfrutar de naturaleza,bebidas tipica de chile el mote con huesillo , mas de alguna vez,, subio hasta la punta del cerro y disgusto este refresco bien heladito,,,chauuuuuuuuu.

  • Christophe;Très jolie fable, mais tu oublies de préciser qu’il fait monter une multinationale car les petites entreprises sont, peut-être, encore plus contrôlées que les petites fourmis et ne sont pas mieux lotis.