When i run your query against my database i have got this as output.

Input

EID = 3

Output:

MID EID ...

Is it possible to achieve the same using 'JOINS'?

Hi Mike,

By using your query i can able to get only the immediate childs of the parent.

For example when i gave 1 as input to that query, i have retrieving...

When i execute exactly as u said, i got this following error

Msg 2714, Level 16, State 3, Procedure TestSpForAllDBs, Line 1

There is already an object named 'TestSpForAllDBs' in the database.

Msg...

Thanks arun.

Your third option works for me.:-)

Thanks, it satisfy my needs exactly. why the previous sp which use 2 single quotes doesn't work. Isn't any reason behind this?

sp_MSforeachdb

'USE ?

IF DB_ID(''?'') > 4

BEGIN

EXEC (''

ALTER PROCEDURE [dbo].[spg_TotalSizePerUser]

@Type nvarchar(50) = ''DashBoard''

AS

BEGIN ...

Haines, Eventhough it is executed against all the database in my server , it show me this error,

Msg 102, Level 15, State 1, Line 7

Incorrect syntax near 'DashBoard'.

Msg 102, Level...

But when i use spMSforeahdb to alter this procedure i got problem , i don't know what the reason.

sp_MSforeachdb

'USE ?

IF DB_ID(''?'') > 4

BEGIN

EXEC (''

ALTER PROCEDURE [dbo].[spg_TotalSizePerUser]

@Type nvarchar(50)...

Thanks

To open the software dtSearch from my windows applications, this coding line is used by me.

System.Diagnostics.Process.Start(@"C:\Program Files\dtSearch\bin\dtSearchw.exe");

but what the problem i faced is: i want to pass search...

Can u help me by furnishing the details regarding the products version of dtSearch.