- You said that drive C: is 68 GB, but how much disk space was free before running the stored procedure?
- Have you used Sysinternals FileMon or Process Monitor to log disk i/o events and determine which file(s) are growing?
- Does the stored procedure contain just select statement, or it is also inserting or updating as well?
- Is the stored procedure selecting into a temporary table or table variable?
When installing SQL Server, by default, the master and tempdb databases are located on the same drive as the application.
For example:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
Also read this article: Troubleshooting Insufficient Disk Space in tempdb
http://msdn.microsoft.com/en-us/library/ms176029.aspx
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho