With 2005, you can use "Schemas" to achieve a little bit of that.

To a large extent, working with flat files for each object also helps a lot.

You could put these scripts in folders and use any text based tool to search, which is a lot easier (no offence...) than TSql.

I have done that for years... (please, don't ask) and was extremely pleased to see that Microsoft finaly decided to do that sort of thing too: Visual Studio Team Edition for Database Developer... which is unfortunately far too expensive :crying: