I changed the directory to D: in the following line...

SELECT @pdf = 'D:\' + @filename + '.pdf'

Its working fine now.

Great work done by the creator of this sp!!

Hi. I tried this stored procedure and the example given. In Sql Server 2005, it runs fine but i m not able to locate the file("demo2" in this case) created.

I...