How to pace another path of Tempdb Database

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

How to pace another path of Tempdb Database

Author

Topic

vedjha
Posting Yak Master

228 Posts

Posted - 2009-10-02 : 07:31:00

Hello,

Please tell me How to change the path of installed TempDB database path.

when i am changin its path , system says me it is a system database . you can't change path.

please help...

Ved Prakash Jha

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-10-02 : 07:33:41

http://www.databasejournal.com/features/mssql/article.php/3379901/Moving-the-Tempdb-and-Master-Database-in-SQL-Server.htm

vedjha
Posting Yak Master

228 Posts

Posted - 2009-10-02 : 07:35:31

I have stopped database server
backup to tempDB database
and delete it
re-connect to database then it makes automatically create a new tempDB database.
then how to change its path

Ved Prakash Jha

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-10-02 : 07:39:50

did you refer to link?

vedjha
Posting Yak Master

228 Posts

Posted - 2009-10-02 : 07:47:39

yes , it works
Thank you..

sir, I have send u a mail which i have discussed you a case study.
have u got any solution for it.....

Ved Prakash Jha

vedjha
Posting Yak Master

228 Posts

Posted - 2009-10-02 : 07:52:04

case study:

Hello Sir ,

I have to find Downline details of User such as

UserID Placement Sponsor UnderPlacement Reffered

M2 L M1
M3 R M1
M4 L M2
M5 R M2
M6 M2 L M4
M7 M1 L M6
M8 M1 L M7

it means
M1->M2
M1->M3
M2->M4
M2->M5
M2->M6
M1->M7
M1->M8

Graphical Image as:
M1
M2 M3
M4 M5
M6
M7
M8

Note: Every user can make(sponsor) infinity no of user . Bt every user having their two hands Left and Right. If user make two user it means his both hand is full. if he wants make(sponsor) more than two user then he will make user under his downline. it will be said as spilling. Users can sponsor or make infinty no of user under his downline.

some question to clearify this example as,

Q) To find Users, Sponsored by M1
Ans.
M1
~~~~

M2
M3
M4
M5
M6
M7
M8

Q) To find Users, Sponsored by M2
Ans.
M2
~~~~
M4
M5
M6
M7
M8

Q) To find Users, Sponsored by M3
Ans. NO USER AVILABLE

Q) To find Users, Sponsored by M4
Ans. SINCE M4 HAS NOT SPONSORED ANY USER, BUT USERS ARE SPONSORED BY M4'S SPONSOR(UPPER USER OF M4) AND COME(SPILL) UNDER M4. SO M4 HAVING 3 USERS AS,
M4
~~~~
M6
M7
M8

Q) To find Users, Sponsored by M5
Ans. NO USER AVILABLE

Q) To find Users, Sponsored by M6
Ans. SINCE M6 HAS NOT SPONSORED ANY USER, BUT USERS ARE SPONSORED BY M6'S SPONSOR(UPPER USER OF M6) AND COME(SPILL) UNDER M6. SO M4 HAVING 2 USERS AS,

M6
~~~~

M7
M8

Q) To find Users, Sponsored by M7
Ans. SINCE M7 HAS NOT SPONSORED ANY USER, BUT USERS ARE SPONSORED BY M7'S SPONSOR(UPPER USER OF M7) AND COME(SPILL) UNDER M7. SO M7 HAVING 1 USERS AS,

M7
~~~~
M8

Q) To find Users, Sponsored by M8
Ans. NO USER AVILABLE

===================================

now my question is, How to find users which is made by M2

Ved Prakash Jha

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-10-02 : 07:52:52

welcome