Finding Version of SQL Server

posted in: Uncategorized | 0

Always forget what number is what version of SQL Server so here’s list of the ones I commonly run into SELECT SERVERPROPERTY(‘ProductLevel’)GO or SELECT @@VERSIONGO SQL 2005 Release 9.00.1399.06SP1 9.00.2047Hotfix918222 9.00.2153SP2 9.00.3042 SQL 2000 release 8.00.194sp1 8.00.384sp2 8.00.534sp3/3a 8.0.760sp4 8.00.2039  

Off to Tech Ed

posted in: Uncategorized | 0

 We’re off to Tech Ed in Sydney tomorrow afternoon, for 3 jam-packed days of information overload.  So probably no news from us till next week.  Hope to catch up with quite a few people in the next fews days.  Looking … Continued

List T.Find

posted in: Uncategorized | 0

When i started using the finder in the new generic lists I couldn’t find a good e.g of how to write the find function.  So here’s a cut down version of one that i ended up writing. First I needed … Continued