• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1220
  • Last Modified:

sp_help and others are missing in newly installed SYBASE ASE on my home XP Professional

exec dbo.sp_help
go
===============================================

The responce can be appreciated only by a person with good sence of humor:
---------------------------------------------------------------------------------------------------------------
Stored procedure 'sp_help' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
---------------------------------------------------------------------------------------------------------------
user_name() returns 'dbo', so it looks all right. May i missed some when creating/configuring the server?

Thanks in advance Roman.
0
bibermar
Asked:
bibermar
1 Solution
 
bretCommented:
Sounds like the "installmaster" script didn't get run somehow.  It is easy to correct, just run

isql -Usa -P<password> -i $SYBASE/$SYBASE_ASE/scripts/installmaster
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now