• it's probably permissions then...the service account does not have access to the C:\ drive.

    if you change it to just the file name , without the C:\, the file would get created in one of the folders under C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn, for example...your specific path would depedn on your installation.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!