Thanks John

I've also just found this

It looks like quite a good approach

What do you think?

Thanks

Do you mean view all the scripts collectively?

Right click on the database

Tasks -> Generate Scripts

Just pick Stored Procedures

Thanks all

Very useful as, collectively you gave very good pointers regarding parsename, truncate vs delete and quoted identifiers

I am still wondering what the logic behind the original ']' was

Also,...

Excellent, works perfectly

Thanks

I'll investigate a bit further re the version.

Thanks for letting me know.

Damian.

My version is Office 365 which provides 2013 for local use

I've done a bit of digging (including ringing MS) and found that its available on earlier versions but not this

What...

Thanks for responding, Phil

Seems to have been a security issue

Yesterday, still having the problem

Today, my account password expired

After resetting this password, all works fine

Really don't know why the imminent expiry...

Thanks for the response

Unfortunately, it seems as though the home version does not get Powerpivot or view

I would have to buy the full blown Excel product

Would have thought MS would...

ok, I've found the answer and it seems to be a combination of things.

Via Reporting Services Configuration Manager Add an additional HTTP identity for both the web Service URL and...

Thanks for the response

I finally got this to respond i.e. something other than a blank screen, by applying encryption through RS configuration manager.

I now get:

The permissions granted to user ''...

Thanks

I'll look further into SSMS although doesn't that dynamically modify the table?