Both DBDesc and SQLSpec will cost me some bucks.

Aren't there any freewares for "Database Server Documantation" available?

Bhavesh

Thanks for the help.

Yes Siddartha, that is the solution what I am looking for.

A particular user account can connect to SQL Server via ASP.net but should not be able to use SSMS to...

Actually I have got SQL SERVER 2005 as ‘dump’ of 2 CDs. I can install all the components from dump of CD1 (SQLSRVRS) without any problem.

But the trouble...

anyone out there???

I have a huge table with 1 million records with binary tree structure:

The simplified Table (tbl_tree1) with Binary Tree data is given below:

ID Name ParentID Age

1 A 0 21

2 B...

I got it guys .... Thanks every one

Bhavesh

Hello Friends,

I have a new problem now.

I want the children count on left side and right side of the parent...

Here is my procedure code which solved my problem:

#############

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

GO

-- --------------------------------------------------------------------------------------------------

-- Procedure : USP_BinaryTree

-- Parameters : @parentid

-- Description : Procedure to...

Finally I got it .... Thanks every one

Bhavesh

I don't think it can be solved by recursive CTE! I referred the MSDN site but it is not very helpful.

What I want is that procedure should return the child...

How to use maxrecursion??

The procedure should store all the childrens of a parentID in a new table for a Binary Tree data.

The procedure is as shown below:

ALTER PROCEDURE [dbo].[USP_BinaryTreeChild]

(

@parentid INT

)

AS

BEGIN

SET...

Many thanks Lowell. It works perfect now 😛

hi Lowell

When i print the @sqlquery it is -

UPDATE Allotuser SET ([Acc5])=hello where userid = 10000

where as correct query should be --

UPDATE Allotuser SET Acc5='hello' where userid='10000'

How should...