using exec sp_help with a different schema then dbo 1

[sds814]

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

 

[gmmastros]

try...

exec Reports.sp_help TableA

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[sds814]

Got the error:

Could not find stored procedure 'Reports.sp_help'.

 

[gmmastros]

My mistake. Sorry.

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:

exec sp_help 'Reports.TableA'

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[sds814]

Thanks, George. It worked.