Thanks for the link. It works perfect with Database Trace Listener. The data is being saved in "Log" table through "WriteLog" procedure. But if I want my onw custom data to be inserted in my custom table, then how to configure this? Say I want to log the data in my table "ErrorLog" ErrorLog table: ------------------- ErrorID INT ErrorMessage VARCHAR(1500) And my procedure may be say "pr_LogErrors" which accespts one parameter say "@ErrorMessage"? I tried changing the proc name in listener property "writeLogStoredProcName" but this does not work and gives error like the stored proc has too many arguments. any idea? Thanks.

Hi Try the following: Link 1 : sql-server-get-the-list-of-object-dependencies-sp_depends-and-information_schema-routines-and-sys-dm_sql_referencing_entities/[^] Or DECLARE @StringToSearch NVARCHAR(MAX) SET @StringToSearch = 'ENTER_SP_TO_SEARCH' SELECT [name], ( SELECT OBJECT_DEFINITION(obj2.object_id) AS [text()] from sys.all_objects obj2 where obj2.object_id = obj1.object_id FOR XML PATH(''), TYPE ) AS Obj_text, [type] as ObjType FROM sys.all_objects obj1 WHERE OBJECT_DEFINITION(object_id([name])) LIKE '%' + @StringToSearch + '%' Thanks Md. Marufuzzaman I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.

Thanks all for your inputs.. I ended up using an OBJECT tag with data attribute pointing to the desired URL. This works smoothly in all browsers except IE :( Right now searching for fixing this for IE.

A M SOMAN wrote: My question is that why does this class need to implement the interface _application if it is already implemented by interface application? Good question. I would expect that the answer is because it's autogenerated so don't actually expect it to do anything clever there. Deja View - the feeling that you've seen this post before.

You only need IIS, which comes with Windows Do your best to be the best

A M SOMAN wrote: Does that mean, when we include say System.Data.SQLClient namespace on the top of our class, it copies all the classes inside this namespace at runtime and allocates memory accordingly It will allocate memory once you create instance for it. class1 c1; won't allocate any memory. But class1 c1 = new class1() will allocate memory space. My Website | Ask smart questions

Thanks man! it was helpful.

Joe, Thanks! That was a nice article. That solved my Worksheet("abc") problem. Regards, Anil

I hope, this article may help you http://msdn2.microsoft.com/en-us/library/ms253138(VS.80).aspx Good Luck Neeraj

Additional information: Web application is installed on different server. SharePoint is on different server. When the user open the SharePoint Portal page first time, an authentication popup comes. Here the user enters usre id and the password to log in into the sharepoint. After that when the user clicks on my application's link, again the authentication popup comes as the application is on different server. But after changing the User from Sharepoint, no authentication popup is displayed for the application and the application shows the old user id only. this may help you to understand the scenario better. anil

thanks for the suggesion. i finally found out that there was one tag which was not being accepted by the webservice. there was no syntactical problem with the tag. but after removing that tag, the request went successfully! this is strange. but i am trying to find the real casue. any way.. thanks for your help. -- modified at 2:45 Monday 28th August, 2006

Thanks Rizwan. I will check out the information.