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.
| Author |
Topic |
|
nguyen
Starting Member
8 Posts |
 Posted - 2004-10-05 : 17:34:39
|
| Get current free space for all drives in megabytes (Documented)EXEC master.dbo.xp_fixeddrivesDetermine if file exists (UnDocumented Procedure)DECLARE @i intEXECUTE master.dbo.xp_fileexist '\\myServer\c$\boot.ini', @i OUTPUTSELECT @i |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-06 : 03:04:47
|
these are cool, i created some exe's just to get these data...imagine my amazement that there are existing sp's for the job. |
 |
|
|
kselvia
Aged Yak Warrior
526 Posts |
Posted - 2004-10-06 : 03:14:38
|
| sp_helpextendedproc will show you all xp's documented and undocumented.--KenI want to die in my sleep like my grandfather, not screaming in terror like his passengers. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-06 : 03:28:06
|
tnx Ken, i'll check them out, i won't be surprised if i see some of the tools i made are in ext sp's  |
|
|
|
|
|
|
Useful Extended SPs