Just wondering if anyone knows of a way to get Work Item names from the TFSWarehouse database?
They are inserted with what I can only really describe as a TFS GUID which I cant seem to translate to a table to get the WI name.
Trying to do this via T-SQK direct on the database rather than using WIQL via Visual Studio as its not really that clued up for the information that the people want on the reports.
Any help is appreciated.
How to post data/code for the best help - Jeff ModenNeed a string splitter, try this - Jeff ModenHow to post performance problems - Gail ShawManaging Transaction Logs - Gail ShawTroubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger