May 9, 2003 at 2:18 pm
I JUST became owner of e JDE OneWorld database. I'm trying to get a handle on the indexes and tables but cannot issue a sp_help on the tables. In QA object browser, the tables names are PRODDTA.tablename. If I issue sp-help tablename, it tells me name not found (I see it in sysobjects as tablename). If I issue sp_help PRODDTA.tablename, I get an "Incorrect syntax near '.'" message. Any thoughts?? TIA
Terry
Terry
May 9, 2003 at 2:40 pm
Put it in single quotes:
EXEC sp_help 'PRODDTA.tablename'
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
May 9, 2003 at 2:46 pm
I feel like a fool. Thanks for the insight.
Terry
Terry
May 9, 2003 at 3:05 pm
Don't feel that way. It's not intuitive. Kinda like the difference in parameter order for sp_addsrvrolemember and sp_addrolemember. These little things will drive you nuts.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply