I just got a backup set which I need to install, I did as following
Create database FFTS on FFTSData=10000 Log on FFTSLog for load
It worked, then when I tried to make database online
...
Hi,
I have 2 rep servers REP_TEST1 and REP_TEST2. The routes have been defined from REP_TEST1 to REP_TEST2 and vice versa. Now i am trying to test the scenerio of publication/subscription. I ...
I am developing a C# .Net Windows forms application using Visual Studio 2005.
I need to call Sybase Stored Procedures from my application.
I use a Sybase ODBC connection as follows:
User...
Hi,
I need an equivalent in Sybase to the below which is in Oracle,
SELECT to_char(systimestamp,'ddmmyyyyhh24missFF') FROM DUAL
I need Getdate() in userdefined format of ddmmyyyyhhss wi...
Hi,
So far I never encountered any as above, but I would like to know if sybase db get to suspect mode or corrupted what will be a step to repair it?
Hi,
I wish to drop a table in sybase 12.5. Firstly is the most efficient way to do this simply DROP TABLE TABLE_NAME ? Or should I truncate it first?
Secondly, when I drop the table are ...
Hi
i am getting following error during the dbcc report :
hard fault 100040 OAM page format error Non-first OAM...
I am trying to resolve a performance issues after moving from 12.5 to 15.0.2.
One path of investigation has led me down idea some of our table are badly fragmented? (as the 1st few weeks of...
Am trying to install the program for our developers, but receiving the attached error regarding the pbjvm115.dll. Has anyone seen this error?
Currently, our web server is on a Win 2k SP4...
Hi,
I have a PURCHASE (columns: id_region, id_purchase) and a PURCHASE_ARCHIVE (columns: date_of_archive, id_region, id_purchase) table whick were identical in schema excpet the arcive tabl...
Below is a working create statement (ASA 9.04, Intractive SQL)
I want to include in the column DivisionID that it is a "Default Value","System Defined", Global Incremnet, Partition size ...
Hi,
I wonder how if we mistakenly entered the command, how can we using backspace to delete / make cxhanges? as you can see below, I have wrongly entered the command which backspace doesnt he...
Hi experts,
There are two Sybase databases ("tiger_1" and "tiger_2") that are located remotely. Using "isql" or "tsql", I can access "tiger_1" but I can not connect to "tiger_2". There i...
I have been backing up the entire database daily. I would like to be able to run incremental (Transaction Log) backups hourly, then apply them to the daily backup.
How would you start?
...
I wonder how do I check size of my transaction log in sybase
Hi,
Please advise what should be done if the SQM thread is down:
Wed Sep 9 07:25:01 BST 2009 ======= Checking connections to rep server REP_PRODBOND =======
Wed Sep 9 07:25:02 BST 2009 ...
hi for example, if i run sp_helpindex on sybase 12.5 vs sybase 15, the result FORMAT is different. We have some legacy code that depends on the format to be the same. We tried turning on the ...
Hi,
I need to access a sybase database on a remote server from a local sever running sybase. What are the ways possible to establish the accessibility?
Much appreciated for any comments.
Hi,
anyone can guide me how can I use ddlgen to have ddl scripts on table level, which included index creation as well ?
What will be the command use to check ASE instance uptime ?
i started my rep server and i can see in log its up
when i add a database to this rep server using rs_init i am getting the error :
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Hel...
Hi Guys,
We have a SYBASE CENTRAL database server version 4.1.1.1436.
The query tool that comes with it is called SQL Advantage and is dead awful.
Im use to MS SQL Server and MySQL Server, ...
I am developing a C# .Net Windows application using Visual Studio 2005.
I need to call Sybase Stored Procedures from the application.
I use a Sybase ODBC connection as follows:
User Data...
How do we in Sybase checking user permissions (db role and server role), how do I have this report extracted for 200 users ? I know sp_helprotect will do but is there any other way by using T-...
SQL Anywhere 10 on Windows 32
I need a query that will return a string which is a list of comma seperated industry names.
The industry names are held in a table called industry, which has ...
