I've got a server set up with a smaller c: drive for applications and a huge d: for storage. I've recently run a SQL Server trace using SQL Server Profiler and stored the results to file on the d: drive. When attempting to open the results though I am running out of free space on the c: drive before it can finish opening so that I can actually do anything with it.
Is there any way I can convince SQL Server Profiler to create its temporary files, or whatever it thinks it needs all that disk space for, on d: where there's plenty of room?
Thanks in advance.