Hi there! I suddenly support an instance of Sybase 8. I'd love to find a couple of good websites with the usual how-to approach and examples &tc. ...

Duncan A. McRae

09-22-2004 03:26 PM
Byrocat

Hi Friends, We have a scenario where there are more than 50 users in a database . We are loading the database from a database which are having...

suraj kumar

09-22-2004 09:32 AM
suraj kumar

We work on a sybase 12.0 and found the following error in error log recently: 00:00000:00252:2004/09/18 05:45:16.20 server Error: 913, Severity:...

jerke szabo

09-22-2004 08:09 AM
jerke szabo

Welcome, Is there any possibility to replace java functions in ASE by "something else"? I'd like to install ASE Express Edition but it doesn't...

ViBart

09-22-2004 06:44 AM
ViBart

I'm trying to install Sybase Server on an AMD Opteron machine with 512mg ram and Solaris 9.0 I'm getting the error message: os create region can't...

Wayne Happ

09-20-2004 04:09 PM
Larry Coon

I work on a sybase 11.9.2 and have to generate a few Reports, that are missing in Intershop. I can connect to the server as 'sa'. All I can see are...

xs65@hotmail.com

09-20-2004 11:56 AM
Michael Peppler

I've been tasked with researching sources (preferably free) for Sybase ".net" drivers. Where should I start? Am I asking this question in...

Myron Murff

09-18-2004 09:38 AM
Jim Douglas

Hello, I am getting a following error during the sybase backup: Checking billing_item The total number of data pages in this table is 5457. Table...

Dmitry

09-17-2004 02:24 PM
Dmitry

Hello, I am getting a following error during the sybase backup: Checking billing_item The total number of data pages in this table is 5457. Table...

Dmitry

09-17-2004 02:11 PM
Dmitry

Hi, Has anyone had experience with the following. We are running dbcc_checkstorage and receiving many millions of the following error. 100004...

marek

09-17-2004 05:27 AM
marek

can you let me know step by step new database creation on Sybase 12.5 on HP-UX from command line? what consideration need to take?

Shawn

09-16-2004 04:26 PM
Ollie

Is ASE server working without tempdb? I want to mirror the tempdb on Unix box. I think I have to drop it the re-create it with disk mirror Please...

Shawn

09-16-2004 02:42 PM
Sara Law

Hi All I have a table (e.g employee) containing millions of records. If I do the following select * into new_table_name /* this can be a physical...

Abhi

09-16-2004 02:34 PM
Sara Law

Hi All, Just wondering if anybody has any remarks on the query tool from Unity Solutions? I've been testing with it for a while and it seems...

Conner

09-16-2004 10:00 AM
Conner

Hi All, Is there some way in which we can get values for a variable at runtime from the user in sybase? Something of the sort what '&' does in...

Nitin Bansal

09-15-2004 10:15 AM
Brian Ceccarelli

HI all, I have been trying to program sybase ct-libraries for solaris in a multithreaded environment. But whenever I try to run this program i get a...

Amol Natekar

09-15-2004 10:12 AM
Brian Ceccarelli

Hi! The table Kontr_scanned_images is a large table containing an image field. When I use DBCC on that table I get an error message: 1> dbcc...

Kjell Pettersen

09-14-2004 02:54 PM
Sara Law

I have some issues with my allowing the user to change their own passwords from the win-client app I'm stuck with. I've encapsulated the sp_password...

Anders Arvidsson

09-14-2004 09:33 AM
Anders Arvidsson

Let see if someone can help me out. Last july I downloaded the SQL Anywhere Studio Developer Edition. I have two databases. One dataBase is SQLA 8...

mcs04

09-14-2004 09:16 AM
mcs04

I have a work task of producting commands that are defined as "DBADM" commands (of which I am considering this SA only/ and dbo only commands)? Is...

Kermit Lowry

09-14-2004 02:19 AM
Rob Verschoor

Hi! We have migrated the table syslogins from a 12.0 database to a 12.5 database. Our hope was that the login name and the password would be the...

Kjell Pettersen

09-14-2004 01:52 AM
Kjell Pettersen

I installed the ASE 12.5 on win2003 machine and have sql server also on the machine. i need to create linked server from sql server database to...

RUBS

09-13-2004 11:15 AM
RUBS

You're looking for 'sp_dbrecovery_order'... It's described in the first edition of my ASE QRG on page 73/74; in the 2nd edition on page 83 and in...

marek

09-13-2004 07:46 AM
Marek Grabiec

what is the best practice for sizing the temp db? what the best way to free up temp db space? command, script please how to monitor temp tablespace...

Shawn

09-13-2004 01:10 AM
Shawn

Does anyone know as how to implement two-phase commit in Sybase, this is for version 12.0 on Solaris. I do know that in oracle this is already by...

Teresa

09-11-2004 08:27 AM
Rob Verschoor

Does anyone know as how to implement two-phase commit in Sybase, this is for version 12.0 on Solaris. I do know that in oracle this is already by...

Teresa

09-10-2004 03:13 PM
Teresa

When I backup my Sybase database, it shows me the following messages: Backup Server: 4.74.2.4: Unable to close database information...

Peter Yu

09-08-2004 09:23 PM
Peter Yu

Hi newsgroup, today we are about to go crazy because of our sybase ase 11.4 on linux. What we try to do is to simply call a stored procedure. But...

Roland

09-08-2004 11:52 AM
Rob Verschoor

On 27.08.04 14:29 Anthony Mandic wrote: Which tasks exactly do they need "sybase" for? Cheers, Tobias

Byrocat

09-07-2004 04:37 PM
Byrocat

Hi, on a 12.5.1 ASE (Linux) I have to set "number of open objects" higher than the value of sp_countmetadata: 1> sp_countmetadata "number of open...

J. Bajdala

09-07-2004 09:35 AM
J. Bajdala

On Sat, 04 Sep 2004 17:10:04 +1000, Anthony Mandic <am@*t.com.au> wrote: <---snip---> There is only one problem with migrating an existing hosts...

noone

09-05-2004 10:32 AM
Mark

Hello all, Can anyone tell me how I can obtain the Sybase ASE 12.5.x Admin/PT/whatever WEB-BASED docs on cd? Our company recently got hacked via...

m_protopapas@hotmail.com

09-04-2004 04:12 AM
Jim Douglas

I'd like to query your experiences on enabling auditing. Essentially, the size of the database, your audit configuration, the number of audit tables...

Byrocat

09-03-2004 10:22 AM
Pablo Sanchez

I am using Sybase 11.5.1 on IBM AIX 4.2.1. I would like to change the default editor used in an ISQL interactive session from "vi" to anything else....

Tom Brehony

09-03-2004 05:00 AM
Tom Brehony

I have the need to change passwords in over 80+ databases when the user changes it in one. Any suggestions on an effieient method. I would...

Jim Douglas

09-02-2004 04:48 PM
Mark A. Parsons

Hi, i have tried to install ase 12.5.2 (downloaded from SPDC). After starting the setup program i have got the following java exception: Running...

Michael Wesche

09-02-2004 11:32 AM
Marc M

Hi all, Anyone know if Sybase plans to include the ability to limit queries by max CPU-time (as opposed to wall-clock time) in ASE in the...

Marc M

09-01-2004 02:27 PM
Marc M

I noticed recently that while waiting for a long-running stored procedure my network light flashed A LOT. I snooped it and discovered the server...

Thomas Gagne

09-01-2004 09:35 AM
Thomas Gagne

Hi, I have successfully upgraded 11.0.3.3 to 12.5.0.3(EBF11449). Most of the problems we corrected were string functions/NULLS that don't work...

Eddie

08-31-2004 10:27 PM
Eddie

Welcome, I'm using: Adaptive Server Enterprise/12.5.0.3/EBF 10696 IR/P/Linux Intel/Linux 2.4.7-10smp i686/rel12503/1915/32-bit/OPT/ and I've got...

ViBart

08-31-2004 10:58 AM
Ollie

Everywhere I've worked as a Sybase DBA, there was the monthly shutdown and restart of the Sybase server. Some places did it weekly. I've been...

Byrocat

08-30-2004 11:16 AM
Rob Verschoor

hi buddy, I am planning to take sybase certification test, anybody knows where can I get test materials?

yubo he

08-27-2004 09:16 PM
Rob Verschoor

Hello I've got some trouble with image column under sybase 11.9.x and dblib I have : create table test(id int, blob IMAGE); and INSERT INTO test...

Sam

08-27-2004 03:00 PM
Michael Peppler

Where I work, we're being "forced" (because of hardware issues) to upgrade our databases from old unsupported NT servers running Microsoft SQL Server...

Mike

08-27-2004 02:43 PM
Byrocat

(windows) I download sybperl module, but can not compile(using bc 5.2), it seems like makefile has some errors error makefile 137:colon...

yubo he

08-27-2004 09:28 AM
Michael Peppler

Does anyone know if you can call a DB2 stored proc on a mainframe from a Sybase 11 stored proc on a Windows 2000 Server? Thanks in advance, G

Rental

08-27-2004 06:44 AM
Rental

The only tasks that I can come up with that require that the user sign on to the operating systems are: 1) installing the Sybase software and...

Byrocat

08-26-2004 10:20 PM
Byrocat

I had posted a bunch of plaitive cries for help with java stored procedure in various newsgroups over the last 3 weeks or so with few definitive...

David Kerber

08-26-2004 04:26 PM
David Kerber

We have multiple database servers running on one machine, is there any way for a client program not running on the local network to find the port...

Andy B

08-26-2004 05:27 AM
Andy B

I install ASE 12.5.2 + HA in windows 2000, when i execute the next command: sp_companion NODE2, configure,with_proxydb, sa, pass_sa,...

Luis

08-26-2004 03:06 AM
Luis