Copy a generic list, List<>, by ref, by value wierdness

Here is my latest weird problem. I had a generic list, I wanted to  make a copy of it. So the aproach I used was to make the new list = the first one. Enter the wierdness; any mods to the second list showed up in the first one. So I guess it used a pointer or passed it by reference instead of  making a copy like I expected. Live and learn I guess. The work around was to initialize it blank and call...

October 19th, 2009 by B.Harding 
Comments Off on Copy a generic list, List<>, by ref, by value wierdness

Search your entire server for a string across all databases! MSSql 2000

You can use this query to search your entire server for a string. It will search views, stored procs, triggers, everything. All the sql text in your database is stored in system tables under each database. There are a few hardships to overcome in order to search. 1.) Text is split into 4000 character chunks. So every 4k chunk has a colID to note its position in the stack of rows .  The names are stored...

October 9th, 2009 by B.Harding