We're running Sybase ASE 12.5.0.3 on a Win NT server.  I am trying to
capture the SQL text run from an application.
I can see the process in the "Process Current SQL Statement Monitor",
but nothing shows up in the Batch Text, Stored Proc Text, or Query Plan

I've been developing an application using SQL Anywhere. I would now
like to deploy it so other users can work with it. I set the
application up on a remote server that anyone can access using remote
desktop. The problem is that it will only let one user in at a time.

I recently changed the IP address on a Solaris server. The interfaces
file was
edited and Sybase came up OK. However since the change I can not get a
database

We're migrating from 12.0 to 12.5.3, and I've been playing around with
various new features that have been introduced between these releases.
I notice dump/load database now has a 'with compression=[1-9]' as of
12.5.2, which looks a lot less cumbersome than the

Can we find out the list of the logins who have had an activity (or not
had activity)on their accounts in the past 60 days.
Iam just interested in knowing which login has accessed  the system in
last 60 days .

I know that MS SQL Server allows stored procedures to access COM object
methods via calls system stored procs (sp_OA stored procs).
I haven't been able to find documentation confirming that Sybase can do
the same thing.  I do know that there are no system procs in Sybase

I have 3 simple questions for sybase developers.
thank you very much in advance,
   JOAN
I have 5 users (AA,BB,CC,DD,EE) but only 2 (AA,BB) have tables and views.

Two questions:
Situation 1:  Normalized database, have several lookup-only tables that
contain anywhere from 3 rows to ~5,000.  Insert / update activity is
rare.  They have identity columns that are used for joins to much

I am working on setting up a database server/webserver combination for
my company. The connection between the two is on a private network
(their own switcher) and the webserver has two NICs: one for the
private network(connected to db) and one for the internet.

Need  15 (fifteen) SQL developers Sybase experience OKAY
LOCAL CHICAGO ONLY.

I am trying to alter a table to add a new column which should contain
datetime (getdate) as default value. I tried altering the table but
could not suceed.
Sample data:

is there a way to find most fragmented tables?
Thanks,
Vipra

Hi i have database dumps named as "train_2005_03_21.bkp"
I dont how to load this back into database -sybase obviously
Pls help me out with exact command
Cheers

I don't want the output in console or errorlog.
Thanks a lot

Hi all, I'm relatively new to Linux, and am trying to bring myself up
to speed as a DB Admin.
I'm trying to connect a webserver that's running Mepis (Debian) Linux
to an already functioning Sybase server. PHP will be my application of