Solved

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

Posted on 2004-03-22
1
1,182 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

There are times when I have encountered the need to decompress a response from a PHP request. This is how it's done, but you must have control of the request and you can set the Accept-Encoding header.
This article explains the fundamentals of industrial networking which ultimately is the backbone network which is providing communications for process devices like robots and other not so interesting stuff.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

635 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