Hi All,

Sorry for the extremely late response.

Your suggestion ended up leading me to the solution. I had actually already tried it against the DB and wasn't going to...

Lowell (4/15/2014)

---

well i can think of two things that might explain this:

1: you are not a sysadmin, and the object in question is outside of your permissions scope. ie the...

Jeff Moden (4/14/2014)

---

It sounds like either you're in the wrong database when you're looking for things or the things are in the wrong database. They didn't get copied to...

Thanks for the suggestion but no luck, in my opinion it is not in the sys.objects view.

Hi Lowell,

Thanks for the response, tried your query but no luck.

Even just a simpler version didn't work:

SELECT * from sys.procedures where name = 'XXXX'

SELECT * from sys.procedures where name like...

--

Hi Mate,

Thanks heaps for the reply!

I was using the sa account, so I don't think permissions are an issue - happy to be told otherwise.

I found this article...