Excellent job Theo. However, when I execute 1st version I get a nice html page but executing version 4 gives only the range of dates with no details as follows:

nice and useful idea.It helps a lot, thanks for your hard work

Very nice work, I agree with you on the fact we always need this type of functions even though EF and other tools exist.

I ran your functions and it works...

Please ignore this thread, I notices the comment inside the article now.

I don't agree with the response as far as SQL doesn't alow more than 1 tempdb. The response would be correct if we can have multiple tempdbs in one instance

Nice  article and usefull way to get information about tables

I forgot to ask at the sametime how in performance tool, use the SQLServer : Usersettable object. I saw I can add conter1, 2 but what is the use of...

Thanks everybody, I was in vacation so that's why I didn' respond, I liked the fgettoken and fgettable functions, it works fine.

Also the...

Thanks for all of you

In the distribution agent history, the error stated : a delete operation on a non existant line.

It was trying to delete an article on the subscriber that dosen't exist anymore

Thanks

Hi,  wonderfull articl, however, I read haif of it. I will let you know my opinion about it as soon as I finish

Problem solved, thansk so much. I might write an article about it

Hi and thanks the idea is exactly what I want to do, however, the sp you use is called without parameters. The one I should call is omething like that

create...

Let me be more clear and accurate so you get the image, here is the problem :

Sp1 :

Create SP1

@V1,

@V2,

@V3,

@V4 = 'tempTable' (assigned dynami cally,...

Hi, thanks for your response. The insert is done inside the the SP2 as foolows

SP1 is called with ther 4 params

SP1 'C', 'TEST', 'fdfdfd', 'myTableName',

As you can see the 4th...