So... You're trying to debug an application that is using a large (100> tables) database and for a reason or an other, you don't understand where this darn Id is coming from! Here's a simple Sql Script that browses your database for this darn Id... Just change the @Id = '' for the id you're looking for! declare @id as varchar(50) -- idToRemove.ToString() "" String select @id = '2eda82d8-9dcb-dd11-965a-00... set nocount on declare @template as varchar(5000) set @template = 'declare @id ......
A long time ago, I wrote a very simple log method. It was used to print the number of times a function/method was called. I just changed it a bit and added an optional dumpAll parameter for printing the whole results. It tracks 3 things: the name of the method, the number of times it was called, and stack level. Private Sub log(Optional ByVal dumpAll As Boolean = False) Static Dim h As New Generic.Dictionary(Of String, Integer)() If dumpAll Then For Each d As Generic.KeyValuePair(Of String, Integer) ......