with NewTree (intValOptionDetailID,strDescription,intParentOptionDetailID,intTreeDepth)

as

(

Select

A.ID,

A.Description,

A.ParentID,

A.Depth

from dbo.Table1 A

where A.ID = 1

Union All

Select

A.ID,

A.Description,

A.ParentIDID,

A.Depth

from dbo.Table1 A,

NewTree B

where A.ParentID = B.ID

AND A.Depth >= B.Depth

)

Select * from NewTree

The above qry...

When I was talking to this MS Support and they said that MS Analysis Service uses 2Gb as  its max!!!. Even If we need to use the whole 2GB then...

I didn't enable the /3gb switch.After I installed the Hotfix from MS.

I beleive that MS-Analysis Service uses 1GB as a Max (Default) until unless we enable the 3gb switch. Do...

Hi Guys,

I ran the Hotfix from MS and It works fine now.

The server is using 4.44GB as a Max memory.

I enabled the /3Gb switch Still the server using the 49% of memory. Do you guys have any idea? Could you...

I have allocated 5GB for SQL Server and 1GB for OS and 2 GB for Analysis Server. But the SQL Server only using 4GB.

Do I need to TURN ON...

I didn't say that the developer should exec the Backup cmd.The DBA knows that how often sp exec and he could schedule a job in sql to take care of...

Why don't you take the Transaction log back up periodically.

When ever you run the sp,Chk the trans log size before and after and exec the backup log and truncate the...

I havn't tried before.

We don't allow the NT a/c to execute the DTS pkg.Anyway I will try.Could you tell me the Syntax for using /E in the DTSrun utility?

Hey this is the SQL proc which backs up all the DBs

/*******************************************************************************************************************************************************************************************************************************************************/

-- Name:Proc_AllDB_Daily_DiskBackup

-- Description:

--Basicly, this script just loops thru all the databases on a given server and...

I have a SQL proc which takes all the DB full back up on weekly and Diff. backup on daily.

I have a Active x script on DTS which deletes the...

Don't create table on SQL.

Set up the DTS job to create the SQL table for the excel data.When you do that it creates the table with the default data type...

Do you have any other SQL jobs which execute the DBCC and Create Index stmts.B'caz I had the same problem with my backup software and I wrote a generic proc...

It is good idea to create the Temp table and Drop at the end of the process.

--Create the temp table.

--Populate the data to the temp table.

--Exec The UPdate Statement

--Exec the...

Could you chk the SQL Server agent connection.Is it running under windows authentication or SQL Server authentication.Try with the SQL Server SA a/c or the SQL A/c who has the...