Are these SP''s still available in 2k8?

Question

Post reply

Are these SP''s still available in 2k8?

Jeff Moden

SSC Guru

Points: 1004339
More actions
August 10, 2007 at 11:03 am

#180270

The following system SP's are available in SQL 2k and 2k5... and the privs for their usage hasn't changed between the two. Are they still available in 2k8? I don't have 2k8, yet, so can't verify myself. Thanks folks...
xp_DirTree
xp_SubDirs
xp_FileExist
xp_GetFileDetails
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Looking at the July CTP:

xp_DirTree Yes

xp_SubDirs Yes

xp_FileExist Yes

xp_GetFileDetails No

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

I can't find xp_GetFileDetails on my SQL Server 2005 SP 2 system.

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 3

Thanks, Lynn...

Heh... I don't have 2k5, either... was going on someone else's word... thanks.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

SwePeso SSC-Dedicated Points: 39757 More actions · Answer 4

http://blogs.conchango.com/jamiethomson/archive/2006/08/24/4400.aspx

See last post here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=54384

N 56°04'39.16"
E 12°55'05.25"

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 5

Thanks, Peter...

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)