When I run sp_configure "procedure cache size" I got a table about
procedure cash (parameter name, default, ...). How can i get config
value of procedure cache size using sql query?

I have two tables with text columns. I wish to update text column in
existing rows in TABLE1 using data present in the text column of a
corresponding row in TABLE2.
(The row in TABLE2 can be selected without referring to the text

Hi all - running on an old version of ASE - Adaptive Server Enterprise/
11.5.1.1 SWR 9085 ESD 7
our overnight DBCC has advised a 2580 error - see below:
The clustered index page (Page pointer = 0x931f7000, pageno = 2828857,

If I create tables in source and target database say
CREATE TABLE QUOTEDTL22
(
 Business_unit_id      NUMERIC (10) NOT NULL,

somewhere I heard or read that there are differences between how this
is handled different in different versions of ASE. Can somebody give
me a clue where to find this (again). I know that I have seen this
problem occur when testing code on ASE15 that worked fine on ASE

Need your comment here. I am wonder how to answer this typic interview
question for sybase performance and tuning - ie, you come in monday
morning, user called that the job/process/query is running very slow,
- it used to take only 5 minutes, now forever, - this is no change/

i have a problem with the follow sybase query. i need do it faster
the variables @dINIT_DATE, @dEND_DATE_AUX, @CUR_SID and  @CUR_NID are
variables that recive the stored procedure.
Actually it takes 15 minutes to execute in a table with 13999 rows

Let's see. Imagine I have a server with a table with two fields: id
and data. I want to insert a new record on the table. Id will be given
(a numeric unique id) and data must be the content on a file
accessible by Sybase (on a folder in the server hard drive or maybe on

Hello, I have created scheduler, job and scheduled jobs successfully
However, when I try to execute a simple proc like, sp_who, i get belo
error in jsagent.log and sp_sjobhistory (with list_output) shows erro
(but not what the error is).

For quite some time now I have put up with the crash that happens
every time I close SQL Advantage.  This is something that I am having
difficulties to put up with for much longer.
I wonder if anyone else has this occurrence?  Is this a known issue,

Hello *,
I just can't find a way to execute a script when i'm in isql. For
example, in oracle you can use the @ sign for directing to a script.
Does Sybase 12.5 has such equivalent?

I write a big file size > 130 mbytes to sybase db. But I have error:
There is not enough procedure cache to run this procedure, trigger, or
SQL batch. Retry later, or ask your SA to reconfigure ASE with more
procedure cache.

I'm working in a large corporate data center with a typical EMC (Like)
data storage array. I don't know exactly what it is... But it's some
sort of storage system. I have a co-worker who is convinved that
performance can be improved by specifying what segments to place the

Is there any way of migrating master.syslogins from a Sybase Unix
(Solaris 9) to windows (Server 2003)  environment ?
I have used bcp to move syslogins between sybase on Unix server - no
problem. The bcp in appears to work fine onto the windows server, but

I have created two select statments, each produce three lines with
this layout:
1st Select:
SELECT ID,