How to manually corrupt index & data pages?

why should we execute dbcc traceon(3604) and what is its impact on the
server and other programs?
please help

I have in Oracle.
INSERT INTO format ( id, name, description)
SELECT 0,  null   , 'all'   FROM dual UNION ALL
SELECT 1, 'text'  ,'sms'    FROM dual UNION ALL

I'm trying to optimize a stored proc with some convoluted login. When I look
at the query plan for a section of it is says something like.
"log scan on <table name> Full table scan. Starting at the head of the
table"

Any possiblity to read transaction log after dump tran?
Thank you
Indra

after installing sybase on linux, when i run  isql command i am getting
this error:
network packet layer: internal net libtary error: Net-Lib protocol
driver call to connect two endpoints failed

Does Sybase track a history of user logins anywhere?  If I needed to
produce a report for auditors showing which DBA's logged into the
database, does such a thing exist?

In a trigger or stored procedure I want to determine whether a
temporary table named #info exists, use the information in it if
it does exist, and do something else if it does not.  I'm looking
at the online Sybase documentation and I don't see any way to do

If I say floating point types,
does it means float and double data types in C++ or is it just
float...and if yes its only float then under what category does double
comes,

We are taking the dumps of production Server databases and

Back "in the day" of dbLib, I remember creating a message handler that
was called to handle "print" statements in SQL.  I'm using a Smalltalk
interface to CTLib but I don't know enough about how CTLib handles it to
know where to look to setup the same kind of handler.

I have table like this
create table testtab(
 id   int,
 code char(1),

I have a script that occasionally runs out of locks.  The server is
configured with the default 5000, but I was wondering what number to
increase it to.  It would be helpful if Sybase, after running out of
locks, would report how many it thought it needed or what other

Performance drop-outs with Sybase ASE 12.5.1, 12.5.2:
Our company is developing a large database application already for
many years for use in the market of *big* libraries (of university
libraries or big public ones). To get an idea what I'm talking about

Im trying to upgrade sybase on solaris from version 12.0 ebf 11690 to
sybase 12.5.2. ebf 12331, I have made a installation of new software
then while looking through sybase documentation it tells me to run the
sqlupgrade or asecfg and even edit the sample file and run the