Solved

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

Posted on 2004-03-22
1
1,165 Views
Last Modified: 2012-05-08
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
Comment
Question by:bibermar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 10

Accepted Solution

by:
bret earned 125 total points
ID: 10652087
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The following article is comprised of the pearls we have garnered deploying virtualization solutions since Virtual Server 2005 and subsequent 2008 RTM+ Hyper-V in standalone and clustered environments.
This article is a collection of issues that people face from time to time and possible solutions to those issues. I hope you enjoy reading it.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.
Suggested Courses

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question