In our application we have a table named bal_pos_calc_report with below
index structure.
index_name     --------index_keys
me_idx_bal_pos_1-----effective_date

Dear group,
I have a requirement to create some of the tables where are present in
a database1 of server1 into database2 of server2.
How to get the DDL of a particular table.

I would like to create some thresholds on tempdb to warn me when the
default and logsegment are getting full.
I created them and tested them.  It all worked very well.
Then I thought - when I reboot the server they are gone.

I have been compiling this new site www.dbahub.com, from a couple of
weeks. I am trying to get most of the popular databases under one site,
where all DBAs can find relevent information.
I encourage to register with this website and submit documents,

I'm having a problem connecting MS Access to a Sybase database with
ODBC drivers from Sybase Client 12.5.1 and 12.5.2.
All of this works fine with Sybase client 12.0 but NOT with 12.5.1 or
12.5.2.

I have to create a view with a complicated
 "where clause" in Sybase ASE 12.5.3
Two options are:
1) CREATE VIEW As

I don't speack and write english very well, but I try to explane my problem.
I have a program that cn has been built SQL Sybase Central, this program is
managed with a based application on Visual Basic.
When I try to access in my program, its ask me a user and password. I have 3

If sybase 7 is working just fine for the app you are using, would there be
any reason to upgrade to sybase 9? I've
heard 9 is slower and buggier. Our vendor is suggesting a move to 9, as they
say "well if your database gets corrupted

I am getting the following error during a dbcc checkalloc :
Server message::
Message number: 2540, Severity 16, State 1, Line 2
Server: EXMRXDAT

I need to retrieve data from a table from MS SQL database and then
populate sybase database tables from the same. The procedure i thought
of is: -
1. BCP MS SQL data onto a flat file.

Can anyone help me on this issue. I have a file which is of
fixed-length. so its delimiter would be a null string (""). I want of
bcp this file using a format file. Does anyone know how to specify null
string as delimiter in format file.

I am trying to install sybase ASE 15 developer edition on my laptop,
which runs Windows XP Home Edition.  For some reason, it is failing.  I
go through the whole step and at the end I get a message, it failed.

I recently installed Sybase PC Client on my PC to make use of the
Sybase ODBC drivers, so I could connect an Access database to a Sybase
database.  Everything worked fine.
I then tried to install  Sybase PC Client on a colleague's pc and I

I want to get the Sybase (ASE 12.5.3) servername
 and Db name inside of a view.
I tried following
-------------------------------------------------------------------

I have some problems to install the Sybase Client with silent mode.
The goal is to install the clients (Sybase) with unattendend mode.
The steps are:
-Sybase Client: