I get an error when using sp_getmessage on a message that were put into
sysusermessages with sp_addmessage.
The sql is like this:

create proc kpTest as
declare @result varchar(255)
exec sp_getmessage 30003, @result
output

The output:

Msg 11060, Level 16, State 1:
Server 'PADDATEST', Procedure 'sp_getmessage', Line 100:
This statement has exceeded the maximum number of recompilations (10). This
indicates an internal error. Please note the error prior to this one and
contact
Sybase Technical Support.
(return status = -6)

DSSI is looking for fulltime perminant people with experience as DBA
or Developer for ASE or IQ in the Phoenix Arizona area. Positions
include benifits and 401k.
Respond to: careers at dssolutions dot com

http://naked-heath-ledger-butt.you-aint.nx.cn/map.html Naked heath
ledger butt
http://busty-bounty-hunter.meterthe.nx.cn/map.html Busty bounty hunter
http://the-blow-our-holes-are-dug.frombfs.nx.cn/map.html The blow our
holes are dug
http://teen-girls-sniffing-shoes.downbuy.nx.cn/map.html Teen girls
sniffing shoes
http://girl-bagtag-stories.careyall.nx.cn/map.html Girl bagtag stories
http://ace-ventura-sex-scene-movie-download.buymay.nx.cn/map.html Ace
ventura sex scene movie download
http://tit-bondage-submission.buyidaho.nx.cn/map.html Tit bondage
submission
http://nicole-whitehead-nude.you-aint.nx.cn/map.html Nicole whitehead
nude
http://mommy-s-little-sweetheart-outfit-by-carter-s.careythe.nx.cn/map.html
Mommy s little sweetheart outfit by carter s
http://ninja-turtle-nipple-slips.you-aint.nx.cn/map.html Ninja turtle
nipple slips
http://nipple-nibbling-lesbians.you-aint.nx.cn/map.html Nipple
nibbling lesbians ...

Hi All,

We are using ASE 12.5 in our application, from a long time, and in
some piece of c code size for query result have been hard coded to
16384.

Now some of our requested queries returns data more than size of
16384.

So what should we do?
I am not very sure whether this is the maximum allowed size from
Sybase itself?
Or we can remove this hardcoded code, and we can allocate memory as
per requirement?

Any help will be highly appreciated.

Thanks
Sunil

Hi,

I have an ASE 12.0
I have a program I need to analyze,
How can I trace all the objects accessed ?

Thanks in advance

Hello everyone,

My application activates procedure A that activates procedure B
Stored procedure B performs a tables' update and its
last statement is:

Select field1, field2,..
From TABLE_NAME
Where condition

Namely, in the end of the procedure a results set is retrieved to
the application

When procedure B is activated directly, there is not a problem.

However when the application activates procedure A, that calls to
procedure B, it encounters problems, because it needs only procedure
A's results sets.

Of course to overcome this problem , I can add an additional parameter
to procedure B, that is null by default and the results set return is
performed , only if it has a non null value.

Is there a better way in Sybase to prevent returning results set by
procedure B without introducing a special change in it.

http://totalvideos.isgreat.org/video/new
http://totalvideos.isgreat.org/video/new
http://totalvideos.isgreat.org/video/new
http://totalvideos.isgreat.org/video/new
http://totalvideos.isgreat.org/video/new
http://totalvideos.isgreat.org/video/new
http://totalvideos.isgreat.org/video/new
http://totalvideos.isgreat.org/video/new
http://totalvideos.isgreat.org/video/new
http://totalvideos.isgreat.org/video/new
http://totalvideos.isgreat.org/video/new
http://totalvideos.isgreat.org/video/new
http://totalvideos.isgreat.org/video/new
http://totalvideos.isgreat.org/video/new
http://totalvideos.isgreat.org/video/new
http://totalvideos.isgreat.org/video/new
http://totalvideos.isgreat.org/video/new
http://totalvideos.isgreat.org/video/new
http://totalvideos.isgreat.org/video/new
http://totalvideos.isgreat.org/video/new ...

Dear Gurus,

Could anyone tell me What is default user name and password to connect
ASE 12.4?
like in Oracle default DBA login as
username = sys
password = sys

In MS-SQL Server default DBA login as
username = sa
password = sa

thanks in advance
Sanjeev

Hi Everybody,

Newbie question

I am running into a small issue here on my db server. I have about 80
db's running on a Windows 2003 R2 box and about an additional 20 or so
DSN services linked to various db's. The box has plenty of overhead
and each of the db's are typically small under 200 mb's which are
accessed through an ODBC connection. Each db has its own dbsvr and up
til this point we have had no issues.

Here is my issue:
I am trying to bring online another dbsvr and db for another client
and I am not able to do so. I get an error while trying to start the
service stating "there was an error while trying to start the
service". The event log is unfortunately not giving me any additional
info on the issue. If I shut down one of the existing db's or other
DSN service I can bring up one of the new db's. I have no trouble
adding non DSN services to the system. Does anybody know if there is
a limit on ODBC/DSN services in windows or is there a limit on dbsrv's
I can have on one machine?

Thank you!

Hi,

I am carrying out some analysis of legecy stored procedures.

They are quite large. Some are 1000 lines of code.

The question I am raising here is to do with result sets.

There are many many selects with in the SP.

Some are are used to initialisze local variables
Some are selects gathering data needed for ulimate objective.
while others are the actual result sets used by the calling C
function.

My question is if there are 10 selects in an SP will there be ten
result sets ?