Geeks With Blogs
John Workman The Workdog's weblog.... a brain dump, of sorts. September 2006 Entries
Objects Search in SQLServer 2005 - part 2
Last week I wrote about how to search for tables and columns in SQLServer2005, since they removed the Objects Search. After I posted it, I realized that it didn't link the columns to the tables, which doesn't make it very helpful. Thanks to my DBA buddy James Rogers for pointing me in the right direction, here's a more helpful query. You can leave either COLName or TBLName blank by commenting out the set command. DECLARE @COLName NVARCHAR(50), @TBLName NVARCHAR(50) SET @COLName = 'bu_id%'SET @TBLName ......

Posted On Tuesday, September 19, 2006 8:31 PM

Objects Search in SQLServer 2005 - work around
The other day someone saw me hit F4 and bring up the Object search in a SQLServer 2000 Query Analyzer. They only had SQLServer 2005 installed and wanted to know how to use it there. After some research, I realized that it no longer exists. I'm not sure why they took this away. I found it quite useful, although I 'fat fingered' the f4 key more times than I hit it on purpose. Although the UI made it easy, this information is still available in SQLServer 2005 through these two tables: sysobjects and ......

Posted On Thursday, September 14, 2006 7:14 PM

Splitting tabs in Visual Studio
I wrote a short time ago about the use of Visual Studio for xslt development. One of the things that I failed to mention was that I didn't like how I had to flip back and forth between my xslt and my xml files. Well, thanks to Chris Breish's blog entry today, that problem has gone away. He mentioned that docking tabs was available in Visual Studio. This got me started, and I was able to figure it out quickly. I have since shown it to three other folks who didn't know about it, so I'm sure there are ......

Posted On Friday, September 1, 2006 1:21 PM

Copyright © John Workman | Powered by: