using exec sp_help with a different schema then dbo
using exec sp_help with a different schema then dbo
(OP)
When I try to use sp_help with any other schema besides dbo, I get an error: Incorrect syntax near '.'. So when I try exec sp_help Reports.TableA I get the error above.
Does the syntax have to be different when using a non-dbo schema?
Thanks
Does the syntax have to be different when using a non-dbo schema?
Thanks
RE: using exec sp_help with a different schema then dbo
CODE
-George
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
RE: using exec sp_help with a different schema then dbo
Could not find stored procedure 'Reports.sp_help'.
RE: using exec sp_help with a different schema then dbo
If you are trying to look something up in a different database, you can use:
sp_help Database.schema.sp_help ProcedureName
Anyway.... for your case, you should use single-quotes around the object name, like this:
CODE
-George
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
RE: using exec sp_help with a different schema then dbo