Forum Replies Created

Viewing 12 posts - 1 through 12 (of 12 total)

  • RE: correlated subquery

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

    Input

    EID = 3

    Output:

    MID EID ...

  • RE: correlated subquery

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

  • RE: correlated subquery

    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...

  • RE: sp_Msforeachdb

    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...

  • RE: Problem with Select Statement

    Thanks arun.

    Your third option works for me.:-)

  • RE: sp_Msforeachdb

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

  • RE: sp_Msforeachdb

    sp_MSforeachdb

    'USE ?

    IF DB_ID(''?'') > 4

    BEGIN

    EXEC (''

    ALTER PROCEDURE [dbo].[spg_TotalSizePerUser]

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

    AS

    BEGIN ...

  • RE: sp_Msforeachdb

    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...

  • RE: sp_Msforeachdb

    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)...

  • RE: sp_Msforeachdb

    Thanks

  • RE: Connect dtSearch from windows application

    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...

  • RE: dbSearch

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

Viewing 12 posts - 1 through 12 (of 12 total)