Has anyone ever encountered Error 691 and know how to solve it???
The manual describes it as a hardware error and points it to the drive
on which I have stored the tempdb. But, our SA does not seem to find
any errors in the OS errorlog. The last option we have is to swap the

Do you know if Sybase supports Dual Processors ?

Hi there, I'm getting the following error from my DBCC checks. I can't
find this Msg in any of my documentation. Can anyone tell me if its
serious or not and can I fix it by going into single user mode and using
the "fix" option?

Recently, I was told to make some kind of documentation for a database
which is in production but does not have any documents.
There are a total of 141 stored procs and 203 tables.
I could figure out that about 91 stored procedures are run every

Simple question with table or view do I look at to find what roles and/or
permission a user have been given. I would need this for all users.
thanks
dlj

1) My old system is solaris 2.7 with sybase 11.2
2) New system is solaris 2.8 with Sybase 12
The question is: -
a) I need the contain of  ???tb from old sybase 11,2 database to new Sybase

Problem :  I want to bcpin 10 millions rows into a table.
But before that I have to decide whether I go with fast BCP or Slow
BCP.
I have to find out the trade off between using fast bcp and creating

I found this error message on the sybase log
"server  background task message: THRESHOLD WARNING: database MONDO,
segment DATA_SEG01 at 233000 pages, server  background task message:
*********

I'm preparing for sybase certification for version 12.5.
I've prepared for it based on the sybase manual, which were very
helpful. In order to test my knowledge I would like to buy some more
tests (apart from the CD offered by Sybase), but I don't really know

I need to write a C++ progam that allows the sybase isql.exe program
to connect to it and send it sql commands such as "select getdate()".
The program would respond in a way that isql.exe would think it's a
sybase server 12.0. The reason for this is that I have legacy scripts

Dear Friends,
How to get the defragmantation information of all tables in database
Iam using 12.5.0.3 on Sun solaris
Thanks in advance

I'm able to get work this in MSSQL 2000 but not in Sybase's ASE.
I got this error when try to do this in Sybase:
"Incorrect syntax near the keyword 'execute'.
State:S1000,Native:156,Origin:[INTERSOLV][ODBC SQL Server driver][SQL Server]"

How can I recover mistakenly dropped a table in Sybase?

I've got a question about limiting the results from a select query.
First of all gotta say that i never work(ed) with sybase so i tried to
use the query i would use on MySql but that doesn't seem to work on sybase.
The query is simple: It's like

Is looping possible in a stored proc?  I need to something
like this (logically):
    run query A (select) - returns N rows
    For each row