in SQL 2012 running this you will get a syntex error near ","

Look at the reference you sent, in it it states:

It is strongly recommended that you do not create any stored procedures using sp_ as a prefix. SQL Server always looks...

Char(1) should be correct since this will never be empty or NULL

I found that when I turned off the windows firewall the error went away, so there is something with in the firewall that did not like the analysis services.

Thanks for the information, keeping just a reference in the database I think would be the best. But the developers are pushing to have the PDF inside SQL so they...