Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
using exec sp_help with a different schema then dbo 1
- Thread starter sds814
- Start date
-
1
- #2
- Thread starter
- #3
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:
-George
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
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:
exec sp_help 'Reports.TableA'-George
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
- Thread starter
- #5
- Status
Similar threads
- Locked
- Question
- Locked
- Question