I'm executing sql query on my database. I have SQL Server 2008 installed on my D harddrive which has 55 GB free space.
I have also C drive which has sth like 150 MB free (right now).
While executing that query on quite a big table (16 GB) I have an error:
An error occurred while executing batch. Error message is: Not enough disk space.
I would like to know if there is any possibility that I can make SQL Server to use D drive instead of C
Or maybe there is any other problem with what I'm doing ?
Thanks for help