Q&A: Can I use system procedures like sp_help with a schema bound object name ?

Wednesday 13 July 2005Written by Julian Kuiters

Q: Can I use system procedures like sp_help with a schema bound object name ?

When I run exec sp_help HumanResources.Resumes I get the error:

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ‘.’.

A: Yes you can.
You need to quote the object name as in:

exec sp_help ‘HumanResources.Resumes’

No tags for this post.