Sybase数据库技术,数据库恢复

• 首页
• 关于
• 订阅
• 归档
• 留言
• 标签
• 免费ASE测试环境
• 镜像站
• 恢复工具

CR:368553

CR Number:   368553 Product Name:   Adaptive Server Enterprise Product Component:   DBXray Status:   Closed OS:   Microsoft Windows Original Version:   3.2.01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Mar 2006 Fixed Description DBXRAY: Several counters show a 0 value when used with ASE 12.5.2

CR:368554

CR Number:   368554 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Oct 2004 Fixed Description Workaround Description  N/A

CR:368607

CR Number:   368607 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jul 2005 Fixed 04 Aug 2005 Fixed 07 Aug 2005 Fixed Description While the ASE is booted with the compressed backup enable (traceflag 4059 on), attempt to dump on the '/dev/null' device will be successfull. Ideally any dump on '/dev/null' should fail.

CR:368617

CR Number:   368617 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Feb 2008 Bundled Request 01 Jul 2008 Fixed Description In HA setup, the update to syslogins table is not syncronized between the servers.

CR:368656

CR Number:   368656 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Nov 2005 Fixed Description Enhance DBCC CHECKTABLE for empty ALLPAGES LOCKED, SLICED tables to report error if the root page of the index has extraneous entries pointing to deallocated pages even though the table is empty.

CR:368687

CR Number:   368687 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Oct 2004 Fixed Description Context menus appear with right click of data tab.

CR:368688

CR Number:   368688 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Oct 2004 Fixed Description ASE Plug-in shows status of logins as locked in the login list view, even when they are unlocked. The propery sheet of a login shows status as unlocked even when login is locked.

CR:368712

CR Number:   368712 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Oct 2004 Fixed 08 Oct 2004 Bundled Request Description If recovery attempts to recreate a user tempdb when the Model database has not been recovered, then when recovery bypasses that step with message 12544, "Not recovering temporary database ... ", it will print a unpredictable database ID instead of the database ID of the user tempdb whose recreation is to be bypassed.

CR:368782

CR Number:   368782 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Oct 2004 Fixed Description Update English ASE Plugin help for 1253

CR:368804

CR Number:   368804 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Mar 2005 Insufficient priority to fix Description dbcc command to view actual alarms in the server

CR:368810

CR Number:   368810 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Nov 2008 Fixed 07 Nov 2008 Fixed Description The migration tool can report the wrong database size when used to calculate estimated space. Workaround Description  The sybmigrate space_est report, lists the pages required per database table. Add up these values, multiply by the new page size, then divide to get the minimum number of Mbytes required. Add extra space as needed for growth.

CR:368845

CR Number:   368845 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Oct 2004 Fixed Description Not customer visible

CR:368943

CR Number:   368943 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Nov 2004 Fixed Description SELECT POWER(0,0) returns 'Domain error' in Adaptive Server Enterprise.

CR:368999

CR Number:   368999 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Nov 2004 Fixed 07 Feb 2005 Fixed Description CIS: select aggregate from a view with CASE will cause signal 11.

CR:369052

CR Number:   369052 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Nov 2004 Fixed Description In cases where adjacent shared memory segments may not have ascending addresses, the message "process infected with 11" in the module 'buf__unhash_and_keep_grabbed_mass' may be reported on a server that uses a lot of memory (more than 1GB) some time after the creation (and possible destruction) of a buffer pool. In 12.5.1 and above, boot time recovery may automatically create (and later destroy) such a buffer pool. This completes the fix to CR 351965. Workaround Description  Boot the server with -T3474 to disable buffer pool tuning during recovery. Avoid creating or increasing the size of a pool at run-time using a source pool of a lesser size (for example, avoid creating a 16K pool using buffers from the 2K pool). Modify these pools either by editing the configuration file, or by rebooting ASE immediately after the sp_poolconfig has been run.

CR:369088

CR Number:   369088 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Sep 2005 Fixed 07 Jul 2005 Fixed 03 Sep 2005 Fixed Description Referential integrity and encryption may not apply to the same column.

CR:369099

CR Number:   369099 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   macosx Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Oct 2004 Fixed 20 Mar 2009 Insufficient priority to fix Description ASE supports dynamic configuration of various settings. Some of this may require ASE to allocate additonal shared memory. If so, the configuration would fail with a BUS error (signal 10). This problem has been fixed. Workaround Description  configure ASE with 'allocate shared memory'.

CR:369121

CR Number:   369121 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Nov 2004 Fixed Description When some serious error is encountered by the server during recompilation of the stored procedure the session may be killed with the stack trace and error 216: "Attempt to automatically drop temporary table failed." This error is spurious and no temporary object will remain in the temporaray database. This problem may happen only if a stored procedure creates non temporary table.

CR:369201

CR Number:   369201 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Nov 2005 Fixed 07 Nov 2005 Bundled Request Description In rare circumstances, 3223 and 3208 error is returned when ASE reads the dump header for cross-platform database load, if the database has many disk fragments in Sysusages. The message "current process infected with 11" in the module 'lddb__stat_translate' together with a stack trace which includes the modules 'lddb__unscr_stat_page' may be reported in the error log, when loading a database across platform, if the database has an orphan row in Sysstatistics.

CR:369217

CR Number:   369217 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 May 2005 Fixed Description sp_sysmon may show us wrong "Total Cache Turnover" if sort order is case insensitive, such as nocase_iso_1. Workaround Description  Calculate "Total Cache Turnover" - SUM("Pages Used" of all Pools of Large I/O Detail) manually

CR:369222

CR Number:   369222 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jan 2005 Fixed 17 Jan 2005 Fixed 23 Jun 2005 Fixed Description Feature request to have alphabatical sort ability on indexes/tables in cache Component

CR:369253

CR Number:   369253 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 May 2005 Fixed 26 May 2005 Fixed Description Improve ASE's network infrastructure to prevent an inability to connect to ASE resulting from a hung engine.

CR:369254

CR Number:   369254 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Nov 2004 Fixed Description Enable message "secleanup: time to live expired" to be configurable for sybmon dump.

CR:369269

CR Number:   369269 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Oct 2004 Fixed 19 Oct 2004 Fixed Description The message 'Current process (<value>) infected with 11' may be hit in the module 'proc_invalidate_plans' with a stack trace in the error log when the value of the configuration parameter 'max parallel degree' or 'max scan parallel degree' is reset to its default value of 1. This will result in an implicit shut down of ASE. The modules 'cfg_notify_max_plldeg' or 'cfg_notify_max_scanplldeg' will also be reported. Workaround Description  Avoid changing 'max parallel degree' or 'max scan parallel degree' on the fly.

CR:369368

CR Number:   369368 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Nov 2004 Fixed 16 Nov 2004 Bundled Request 11 Nov 2004 Fixed 15 Dec 2004 One-off Provided Description ASE encounters a timeslice error in function kscloseall

CR:369417

CR Number:   369417 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jan 2006 Fixed Description 1> In stored procedure 'modifylogin' , a new value 'kerberos' for option 'authenticate with', is added. A user can specify authentication mechanism as 'kerberos' as follows, sp_modifylogin 'user1', 'authenticate with','KERBEROS' 2> a user can get authenticated against specified mechanism, even if configuration options 'use security services','unified login required' are set to 1. Workaround Description  *** Friday, October 15, 2004 2:46:01 PM *** cooperg *** N/A

CR:369457

CR Number:   369457 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Aug 2005 Fixed Description CIS: Executing sp_addlogin command may result in Msg 102 error when a user-defined role with password has been activated. Workaround Description  Created a new row without a password ( eg ha_tester) grant role J_Role to ha_tester (role J_Role has the password) grant role ha_tester to username and then tried adding a new login. ! Works

CR:369469

CR Number:   369469 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Oct 2004 Fixed Description When INSERT or DELETE privileges are granted to PUBLIC, it is not possible to GRANT the same privilege WITH GRANT OPTION to an individual user. Workaround Description  add the user to public group then grant permission and then remove this user from public OR grant all to user first & then grant all to public.

CR:369473

CR Number:   369473 Product Name:   Adaptive Server Generic Docs Product Component:   What's New in Adaptive Server? Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Oct 2004 Fixed Description Currently it says "The length of a unchar/univarchar column is limited by the size of a data page in Adaptive Server, just as in char/varchar columns" It should be "The length of a unichar/univarchar ....."

CR:369493

CR Number:   369493 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jan 2006 Fixed 09 Feb 2006 Presently Not Targeted For Any Future Release Of This Product Description Message 2843, "The dynamic statement '*<name>' could not be found. This may be due to insufficient metadata descriptors for the number of tables and procedures in use by Adaptive Server. Configure the serverwide 'number of open objects' parameter to accommodate more objects." is raised when a procedure is executed using a name like "*<name>". Workaround Description  n/a

CR:369510

CR Number:   369510 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Open OS:   Digital UNIX Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 May 2005 Fixed 23 Feb 2005 Fixed 29 Apr 2005 One-off Provided 28 Apr 2005 Fixed Description The backup of database dumps taken on Tru64 platform does not load on other platforms such as Linux 32 on Intel, Solaris 32 or 64bit, etc. As a side effect of this fix, compatibility from older dump on Tru64 is not kept. To workaround incompatibility issue, you could use trace flag -D128 with the backupserver binary. This way you would be able to load older dumps.

CR:369595

CR Number:   369595 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Nov 2009 Fixed Description Sybmigrate doesn't check server's configuration before actually start sybmigrate.

CR:369627

CR Number:   369627 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Oct 2004 Fixed Description The stored procedure sp_logiosize may display strange characters following the database names.

CR:369675

CR Number:   369675 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Oct 2004 Fixed Description The error 5850 will be incorrectly raised when the configuration parameter 'enable ldap auth' is set to zero in those platforms where LDAP is not supported.

CR:369767

CR Number:   369767 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Open OS:   Microsoft Windows Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The proxy table wizard now forces you to create CIS mapping before one can select remote table, therefore no longer making it optional.

CR:369861

CR Number:   369861 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Nov 2004 Fixed 26 Oct 2004 Fixed 02 Nov 2004 Fixed Description Under JS Task shutdown invoked due to a normal Job Scheduler shutdown or an implicit exception request the JS Task could be caught in a SPINLOCK order violation finally resulting in a SIGBUS with a chance that ASE needs a reboot before the Job Scheduler can be started again. Workaround Description  There is no workaround for this bug.

CR:369933

CR Number:   369933 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Oct 2004 Presently Not Targeted For Any Future Release Of This Product 05 Nov 2004 Fixed Description The error "ct_fetch(): protocol specific layer: internal Client Library error: There is a tds state machine error. An illegal tds token sequence was received." will be raised if updating a table with a timestamp field results in a duplicate key error.

CR:369961

CR Number:   369961 Product Name:   Adaptive Server Enterprise Product Component:   sqldbgr Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Nov 2004 Fixed Description When using sqldebugger utility some warning messages and messages sent via PRINT statement are silently ignored without printing.

CR:369966

CR Number:   369966 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Dec 2004 Fixed Description In the case of fatal errors occuring at online time during the recovery process, Adaptiver Server error handling may not be graceful and may fail to recover subsequent databases. Workaround Description  None.

CR:369969

CR Number:   369969 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2006 Bundled Request Description Not customer visible

CR:369970

CR Number:   369970 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Open OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Not customer visible

CR:369971

CR Number:   369971 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Open OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Not customer visible

CR:369972

CR Number:   369972 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jul 2005 Fixed Description Not customer visible

CR:369973

CR Number:   369973 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jan 2005 Bundled Request Description Not customer visible

CR:369974

CR Number:   369974 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jun 2005 Fixed Description Not customer visible

CR:370015

CR Number:   370015 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Mar 2005 Fixed Description Memory to track a job which has a timeout value remains allocated even after the job instance has completed or been terminated (without having expired its timeout value), causing memory usage to steadily grow.

CR:370028

CR Number:   370028 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Nov 2004 Fixed 05 Nov 2004 Fixed Description On HP Itanium 64 platform only, sp_sysmon reports that Spinlock Contention is always 100%.

CR:370033

CR Number:   370033 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jun 2005 Fixed 23 Jun 2005 Fixed 09 Jan 2006 Fixed Description Enhance the buffer manager to remove certain racing conditions when recycling buffers in the LRU/MRU chain in data caches using "strict lru" strategy.

CR:370039

CR Number:   370039 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jan 2005 Fixed Description If a call to xp_cmdshell is coded within a sp_thresholdaction procedure, the parameters to xp_cmdshell will be truncated to 255 characters

CR:370055

CR Number:   370055 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Nov 2004 Fixed Description The message "current process infected with 11" in the module 'ex_doprint' together with a stack trace which includes the modules 'lddb_chkrolename' will be reported when loading a database that has a user or group that matches an existing role name.

CR:370067

CR Number:   370067 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Customer wants built-in function to calculate entire row length

CR:370073

CR Number:   370073 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jun 2005 Fixed Description CIS: Query hangs or runs poorly with join against proxy table column. Costing for certain join order might have been underestimated. Workaround Description  Do not run update statistics on the proxy table Use "set forceplan on" to force the join order using the order in "from" clause, or force the index

CR:370092

CR Number:   370092 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Dec 2004 Fixed 07 Dec 2004 Fixed 10 Feb 2005 Fixed 10 Feb 2005 Presently Not Targeted For Any Future Release Of This Product Description In rare circumstances a deserialized Object attempts to validate on an incomplete read. In this case the read may be retried with an expectation of success so a retry mechanism was incorporated in the deserialization mechanism.

CR:370120

CR Number:   370120 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   Solaris Original Version:   12.5.2 Intl Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Nov 2004 Fixed Description Simplified dynamic memory tracking and management for Job Scheduler Agent.

CR:370170

CR Number:   370170 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Nov 2004 Presently Not Targeted For Any Future Release Of This Product Description Feature request to support MOUNT DATABASE command on HA systems

CR:370233

CR Number:   370233 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Nov 2004 Fixed 16 Nov 2004 Fixed 23 Jun 2005 Fixed Description ASE 12.5.2 ESD#2 reports "kernel hbc_ninit: No sockets available for HBC" on boot because of the bug fix 354768. This is an informational message only and can be safely ignored if EJB is not configured. ASE 12.5.3 alters this behavior so that this message appears only when "enable enterprise java beans" parameter is set to 1 in the config file. Workaround Description  This error is not displayed if ASE is started with traceflag 1642 However this takes the bahavior of ASE back to pre 12.5.2 ESD#2 release

CR:370295

CR Number:   370295 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Feb 2005 Fixed Description CIS: SELECT COUNT(*) FROM an EXTERNAL FILE without any search arguments gives timeslice errors for large files. Workaround Description  Increasing the cpu grace time can help but needs to be increased in proportion to the size of the external file. Putting a search argument on the select statement avoids the problem completly but does give a performance hit as it must be evaluated for each row.

CR:370329

CR Number:   370329 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Nov 2004 Fixed 02 Nov 2004 Fixed Description This fix affects the Scheduled Job wizard in the ASE Plugin. The plugin will no longer display a NullPointerException when an invalid Schedule name is entered while creating a Scheduled Job; now the user will get an error saying the name is invalid. Also, this fix prevents the creation of a Scheduled Job when a duplicate Job name is provided in the first page of the wizard. Previously, it may have looked like the user created a new Job and a new Scheduled Job when what actually happened is that a new Scheduled Job was created using an existing Job. To create a Scheduled Job using an existing Job, the user should use the Job Scheduler wizard.

CR:370364

CR Number:   370364 Product Name:   Adaptive Server Enterprise Product Component:   sqldbgr Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Oct 2004 Fixed 16 Nov 2004 Fixed 20 Oct 2005 Fixed 09 Jan 2006 Fixed 23 May 2006 Fixed Description Make SQLDBGR to be JDBC3.0 compliant.

CR:370369

CR Number:   370369 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jan 2005 Fixed Description A CREATE TABLE statement using a constant MS in the DEFAULT clause for a column succeeds without raising the expected message "Msg. 128, The name 'MS' is illegal in this context. Only constants, constant expressions, or variables allowed here. Column names are illegal.". Workaround Description  Default for c1 column requires quotes around the value.

CR:370427

CR Number:   370427 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Nov 2004 Fixed 03 Nov 2004 Fixed 02 Nov 2004 Fixed Description The Job Scheduler Task from ASE 12.5.2 could freeze ASE under Job Scheduler Agent exceptional behavior.

CR:370520

CR Number:   370520 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Feb 2006 Fixed Description The functionality implemented under CR 316222 and extended under CR 400907 to improve the performance of DROP TABLE in temporary databases was active by trace flag 3706 at boot time or via DBCC TRACEON(3706). This enhancement now become the default ASE behaviour. Consequently by default ASE will release during the drop of user tables in tempdb the system catalog locks when not in DDL-IN-TRAN mode after the commit of the transaction but before post commit work started. The trace flag 3706 is therefore obsoleted. Should there be a need to turn off this enhancement then trace flag 3708 can be used.

CR:370530

CR Number:   370530 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Nov 2004 Fixed Description Renormalization of stored procedures may consume too much stack space leading to stack overflow errors. Module name qremap__tree is printed in the errorlog. The problem is generic but is likely to happen more frequently on linux platform.

CR:370533

CR Number:   370533 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Nov 2004 Fixed 07 Feb 2005 Fixed Description A 12301 error, "Internal error: the index (id = <indid>) and the data for row (<pageid>, <rnum>) in table '<tablename>', database <dbid> are inconsistent; data is marked deleted but index is not. Aborting the transaction." may be reported while running a lot of concurrent DMLs on a Data Only Locked table having one or more indices.

CR:370633

CR Number:   370633 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jan 2006 Fixed 16 Jan 2006 Fixed 15 May 2006 Fixed Description Wrong page errors might occur while accessing tables after a server crash mid-way through an ALTER TABLE UNPARTITION operation. These errors can also occur while accessing tables after loading a transaction dump containing uncommited changes for an UNPARTITION operation to such tables. (Fixes issues raised in 400988.)

CR:370711

CR Number:   370711 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Nov 2004 Fixed Description Query with a builtin function which takes as the argument user name may fail to return correct result if the statement cache option is turned on and the parameter passed to to the builtin is host variable.

CR:370760

CR Number:   370760 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Nov 2004 Fixed 11 Nov 2004 Presently Not Targeted For Any Future Release Of This Product Description Select into or Insert select with text/image columns and order by may stacktrace, if the source table is a proxy_table and remote server is a direct_connect.

CR:370870

CR Number:   370870 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Nov 2005 Fixed Description The message "current process infected with 11" in the module 'kbfalloc' may be reported in the error log when using network packet size greater than the configured value of "default network packet size".

CR:370932

CR Number:   370932 Product Name:   Adaptive Server Enterprise Product Component:   Component Drop Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Feb 2005 Fixed 12.5.3 24 Nov 2004 Bundled Request Description The following cp1252 sort order files are missing from $SYBASE/charsets/cp1252 directory: dictionary.srt, espdict.srt, espnoac.srt, espnocs.srt, nocase.srt, noaccents.srt and nocasepref.srt.

CR:370957

CR Number:   370957 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Dec 2006 Fixed 14 Jan 2007 Reservation Made 25 Mar 2008 Not reproducible with latest version of the product available as of Resolution Date Description SELECT from a proxy table which is mapped to a remote table containing unsupported datatype will give error.

CR:370981

CR Number:   370981 Product Name:   Adaptive Server Enterprise Product Component:   auditinit Status:   Open OS:   NA Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description A feature request to be able to specify in the sp_audit procedure to allow an 'all' option for objects and users. eg "sp_audit 'all','all','all" and then remove some selected options from specific users. Workaround Description  Some instances of this problem can be solved by generating a script that does an object-level sp_audit for every applicable object in the database. For instance, to turn off SELECT auditing for all tables in a database: select 'execute sp_audit "select", "all", "' + name + '", "off" ' from sysobjects where audflags & 48 > 0 go

CR:371136

CR Number:   371136 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Nov 2004 Fixed Description DBCC CHECKTABLE may fail to report error 2510: "Key mismatch between index page <index pno>, at offset <indoffset> and data page <data pno> (row ID <rnum>) in database '<dbname>'. Drop and re-create index id <indid> of table '<tabname>'" and abort silently.

CR:371154

CR Number:   371154 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Dec 2004 Fixed Description Error message number 216 : "Attempt to automatically drop temporary table failed." and the stack trace may be written to the errorlog when the server encounters an error during the recompilation of the stored procedure using cursor on the temporary table.

CR:371162

CR Number:   371162 Product Name:   Adaptive Server Enterprise Product Component:   SQL Advantage Status:   Closed OS:   Microsoft Windows Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jan 2005 Fixed 11 Jan 2005 Fixed Description SQL Advantage 12.5.1 has significant performance degradation versus 11.5 Workaround Description  Use SQL Advantage 11.5.

CR:371192

CR Number:   371192 Product Name:   ASE Replicator Product Component:   Distributor Status:   Closed OS:   Generic Original Version:   12.5.3.303 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.3.304P1 13 Dec 2004 Fixed 4.0.0 13 Sep 2005 Fixed Description ASE Replicator: Replicator no longer requires a password on the process startup command line. If the "-p" option is omitted, Replicator will prompt you for the password.

CR:371223

CR Number:   371223 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 May 2009 Duplicate Description In some cases, displaying the value of memory used is more than the memory used for statement cache configuration expectation.

CR:371288

CR Number:   371288 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description New Feature: customer wants to be able to use sp_audit with all logins except certain logins The way the customer describes this it would possibly take a two step process... 1. exec sp_audit to start auditing for all logins 2. exec sp_audit to exclude individual logins Workaround Description  laborously enter all the sp_audit requests for each of the included logins and not do the excluded logins

CR:371302

CR Number:   371302 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Nov 2004 Fixed Description A 2511 error, "Keys of index id <indid> for table '<tabname>' in data page not in correct order. Drop and re-create the index.(index page <pgid>)" may be reported by DBCC CHECKTABLE after doing an UPDATE to an ALLPAGES_LOCKED table having a clustered index with a one or more descending key columns.

CR:371310

CR Number:   371310 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jan 2005 Fixed Description On 64 bit platforms "sp_configure 'additional network memory' ,2147481600" silently fails.

CR:371323

CR Number:   371323 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Dec 2004 Fixed Description CIS: When a proxy table is updated via ct_dynamic in a client application, error 7732 may occur indicating that the cursor is READONLY. With this change, remote tables may need to be created with a unique index for table scans on updatable cursor.

CR:371350

CR Number:   371350 Product Name:   Adaptive Server Enterprise Product Component:   SQL Advantage Status:   Closed OS:   Microsoft Windows Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Mar 2006 Insufficient priority to fix Description After upgrading SqlAdvantage to 12.5.1 and Open Client to 12.5.1 the grid tool does not support a char column with over 256 characters. Only a portion of the data is displayed. The issue is if you have results large then the window there is no way to scroll to see that data off the Window. Workaround Description  If you double click on a large grid view column this will bring up a new scrollable window that can be used to show all the data.

CR:371388

CR Number:   371388 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Requested higher audit granularity to allow any reasonable combination

CR:371454

CR Number:   371454 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Nov 2004 Fixed 08 Nov 2004 Fixed Description When ASE is configured for High Availability with HACMP5.1 Cluster, failover fails with the error "SYBASE HA MONITOR: ***ERROR: Dbcc takeover may have failed. Please check the errorlog of <secondary_companion_name> and manually execute 'dbcc takeover' from <secondary_companion_name> if necessary." in the hacmp.out log file.

CR:371554

CR Number:   371554 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Nov 2004 Fixed 10 Nov 2004 Fixed 23 Jun 2005 Fixed Description ASE message 1608 has been enhanced with a supplementary informational message including the host and login name relating to the lost connection. for example, "extended error information: hostname: TONYI-XP login: sa".

CR:371687

CR Number:   371687 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Nov 2004 Fixed Description Error 3475 may be raised if sessions currenlty suspended on the LCT of a mixed log and data database are interrupted. DBCC checkalloc may raise multiple 12909 errors : "Table with object id=0 (name = 0) inconsistent after Large Scale Allocation. 8 pages in extent <XXX> were found reserved." Workaround Description  Set the "abort tran on log full" database option, so that transactions do not get suspended on the LCT but aborted instead.

CR:371703

CR Number:   371703 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Nov 2004 Fixed Description If SET PROXY is executed in a batch where one of the commands fail, the security context will be partially lost and the user will not be able to revert its identity. The output of sp_who will show that both the original name and the current name are set to the faked user's name.

CR:371715

CR Number:   371715 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   NA Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 May 2006 Fixed Description Improve the performance of object statistics collection when 'per object statistics' and 'object lockwait timing' are enabled. Workaround Description  Set 'per object statistics enabled' configuration parameter to 0. This is done with sp_configure 'per object statistics enabled', 0.

CR:371757

CR Number:   371757 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.3 ESD#2 04 Feb 2005 Fixed Description At times, the Job scheduler may not calculate time intervals correctly, if the job is scheduled to run past midnight. The next callout calculations were not correctly handling cases where the schedule starttime was after the schedule endtime, that is a schedule that wraps over midnight. The net effect of this error was that the schedule was being offset from the starttime when it passed midnight. The current fix handles this case correctly so schedules are rolled over midnight properly. The fix in effect recognizes that midnight, which is stored as a 0 in a CS_DATETIME, effectively needs to be viewed as the largest allowable value when approached clockwise during an operational schedule rather than as a 0. In addition to the direct fix there are a couple side effects to this fix that users may see: 1) End times are now enforced correctly. This means that when a recurrence interval falls on the end time the job will not run. The current situation is that a job can actually run past the endtime because the next callout calculation was allowing the next callout time to be outside the endtime boundary so the job would be run past the endtime and then the following callout time would move up to the next starttime. This was clearly incorrect and has been fixed, however this represents a change in current behavior. 2) Schedules where starttime equals endtime, either as default values or explicitly set are treated correctly. That is the schedule will run in continuous intervals without interruption unless constraints (day of week/date of month) are set.

CR:371818

CR Number:   371818 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jul 2007 EOL'd version. Not to be Fixed. 13 Dec 2007 Fixed 04 Jan 2008 Fixed 29 Oct 2007 Reservation Made Description Sometimes the internal Adaptive Server clock might differ from Operating System clock (as returned by GETDATE()). A new built in function called GET_INTERNAL_DATE() has been introduced to return the Adaptive Server internal clock value. The internal clock value is used for assigning dates to internal objects and only ever increments to ensure that time moves in one direction only. Over time, the internal clock synchronizes closely with the OS clock. Discrepancies between the clocks tend to arise when the OS time is abruptly changed or if being used, when daylight saving transitions happen. The internal date is used for things such as the crdate field in sysobjects and sysindexes, the loggedindatetime in syslogins, WAITFOR commands, and the datetime stamps in begin tran and commit tran log records.

CR:371839

CR Number:   371839 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Building Blocks Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jan 2006 Fixed Description Need to document bitmask values assigned to systhresholds.currauth IN ASE 12.5.1 Doc "Reference Manual Tables" This is the current description for the currauth column: A bit mask that indicates which roles were active for suid at the time the threshold was added or most recently modified. When the threshold is crossed, proc_name executes with this set of roles, less any that have been deactivated since the threshold was added or last modified. Determining which roles were active based on the systhresholds.currauth is not clear. Customer requests a documented explanation in the ASE user reference manual for the bitmask values assigned to systhresholds.currauth.

CR:371861

CR Number:   371861 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jan 2005 Presently Not Targeted For Any Future Release Of This Product Description Provide option to write messages on client end when using login triggers

CR:371907

CR Number:   371907 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Dec 2004 Fixed 14 Dec 2004 Presently Not Targeted For Any Future Release Of This Product 07 Jun 2005 Not reproducible with latest version of the product available as of Resolution Date Description Quickly repeated requests to abort or stop and then restart the Job Scheduler task leads to a variety of problems related to communication between the ASE Job Scheduler task and its agent. Symptoms include a Job Scheduler hang (no response), ct lib connection failures (as noted in the Job Scheduler agent log file), the Job Scheduler task error 'spurious states from jsagent', and log messages indicating a failure to receive a communication buffer from either the Job Scheduler task or agent.

CR:371913

CR Number:   371913 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Nov 2004 Fixed 11 Nov 2004 Fixed 17 Nov 2004 Fixed Description In some circumstances, a 695 error, "An attempt was made to read logical page '<pageno>' for object '<objid>' in database '<dbid>' from disk. Wrong logical page '<pageno>' was brought into cache '<cachename>'" or other 69x error may be reported in the error log some time after using sp_poolconfig to increase the size of a memory pool in a data cache that is using the relaxed LRU cache replacement policy. Workaround Description  Avoid running sp_poolconfig. To modify pool sizes, shutdown ASE, modify the configuration file to adjust the pool sizes and then restart. Alternatively, do not use a "relaxed LRU" strategy for any caches.

CR:371920

CR Number:   371920 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Nov 2004 Fixed 24 Nov 2004 Fixed Description Sybase Central ASE Plug-in generates a DDLBaseException stacktrace with the following error code, when trying to generate the DDL on a Unique Constraint object: "DGP1 The Object type is invalid null.". Workaround Description  This works fine when choosing 'table' -> 'generate table objects'.

CR:371921

CR Number:   371921 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) Description A feature request to report committed transactions within a specificed time frame

CR:371993

CR Number:   371993 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jan 2005 Fixed Description In some rare cases, ALTER TABLE on a DOL table may corrupt the clustered index so that entries for some rows are missing, resulting in a lower rowcount. DBCC checktable will report a 7928 error.

CR:372034

CR Number:   372034 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Nov 2006 Fixed 14 Jun 2007 Fixed Description Migration fails during setup when source server has a password and target does not

CR:372062

CR Number:   372062 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   NA Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to switch On/off numeric logins

CR:372191

CR Number:   372191 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Nov 2004 Fixed Description Add diagnostics to capture CSMD for sddone "not within virtual disk range" errors

CR:372200

CR Number:   372200 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   SunOS Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Sep 2009 Presently Not Targeted For Any Future Release Of This Product Description Customer issue is that with increasing DB auditing needs, the ability to audit user activity at either the group level or user-defined role level would greatly simplify administering Sybase's Auditing features. Add Option Types of: group, role Examples: sp_audit @option="group", @login_name="all", @group_name="mygroup", @object_name="all", @setting="on" Turn on auditing for all users in all databases that are in group "mygroup" sp_audit @option="role", @login_name="all", @role_name="myrole", @object_name="all", @setting="on" Turn on auditing for all users in all databases that have the role "myrole" active. These are suggestions not necessarily how to implement the feature. Workaround Description  *** Monday, November 15, 2004 10:06:03 AM *** cooperg *** N/A