Recent content by jhonty

HI, It seems that you have changed the search condition in the proc? Use SET SHOWPLAN ON and then SET NOEXEC ON and exec the proc. , check if it is doing table scan, correct the where condition so that it will use proper index on column then OFF both SET option command, and then reexecute the...

Hi, Its character field so no need to worry just do update <tab_name> set <field> = '1'+<field name> where <condition_if_required> all the best.

You can reinstall the backup server and try again, probabily you'll be succeed. All the best.

Hi, Another simpler way is accessing thru the remote server configuration, u need to add the server1 into server2 by using sp_addserver command (see the syntax) add in its interface file, give proper access to any of the user then write this query within one small proc in server2 by calling...

1. How can I get the list of all databases in sybase ver 12? sp_helpdb 2. How to get a list of tabels from a database? select name from sysobjects where type = 'U' order by name 3. How to list all the table defenitions from a table? sp_help <table_name> 4. How to List all views from a database...

How are you using BeginDate, EndDate variable in the query? try out with <Date_field> between @BeginDate and @EndDate else <Date_field> >= @BeginDate and <Date_field> <= @EndDate

Hi Marvin, They might be talking abt. syslog table i.e. transaction log table which is getting full, there is only errorlog file in sybase I know, check for errorlog file for exact error message. &quot;DUMP TRAN WITH TRUNCATE_ONLY&quot; will work for clearing the log, check for the other...

Hi JMCraig, Thanks for your response and efforts. Its like user can configure their own debug level, higer level would return (in log)only SP name, intermediate level will tell little more (user defined error msg. and desc.) and lowest level will tell the actual sql stmt. where error occured...

Thanks Ged, its more effective.

DO u mean I can upgrade directly from 10.X,11.X to 12.5 without doing migration???

Hi all, 1. Can we directly migrate from Sybase version 10.X to 12.5? 11.0.X to 12.5 ? 11.9.X to 12.5 ? 2. Is anybody have wright up for problem faced during migration between different versions and 12.5? or the know problems (syntax / behavior changed) and there fixes while...

Hi, How can I use notepad as a isql -Enotepad editor? I've Sybase 11.X (solaris 2.X) server and Windows2000 client. What setting would be required? Thanks in advance.

Who is owner of the DB? The login which you are using for creating table, is it having the right permission to do so just check it out.

Hi guys, How anyone can set/code the debug level, so that he can see the actual sql stmt. where error has occured? One thing I've think that I should take stmt. in one variable and if return is error print that variable. Is there any other way Sybase provides or any body can suggest. Thanks...

Thanks feroz now i can see.