From the SQL Server 2000 BOL:
"Values with the datetime data type are stored internally by Microsoft SQL Server as two 4-byte integers. The first 4 bytes store the number of days before or after the base date, January 1, 1900. The base date is the system reference date."
You should be able to get the julian value with
SELECT CONVERT(int, datevalue)
-Mike