Viewing 12 posts - 1 through 12 (of 12 total)
When i run your query against my database i have got this as output.
Input
EID = 3
Output:
MID EID ...
December 5, 2009 at 1:52 am
Is it possible to achieve the same using 'JOINS'?
December 4, 2009 at 8:45 pm
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...
December 3, 2009 at 8:40 pm
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...
September 15, 2009 at 6:08 am
Thanks arun.
Your third option works for me.:-)
April 30, 2009 at 1:25 am
Thanks, it satisfy my needs exactly. why the previous sp which use 2 single quotes doesn't work. Isn't any reason behind this?
April 2, 2008 at 10:31 pm
sp_MSforeachdb
'USE ?
IF DB_ID(''?'') > 4
BEGIN
EXEC (''
ALTER PROCEDURE [dbo].[spg_TotalSizePerUser]
@Type nvarchar(50) = ''DashBoard''
AS
BEGIN ...
April 2, 2008 at 5:22 am
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...
March 30, 2008 at 10:09 pm
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)...
March 29, 2008 at 7:14 am
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...
March 13, 2008 at 5:02 am
Can u help me by furnishing the details regarding the products version of dtSearch.
March 10, 2008 at 11:34 pm
Viewing 12 posts - 1 through 12 (of 12 total)