Bonjour,
I'm working with Sypase ASE Auditing and I have a questiopn regarding sp_displayaudit "database" command.
I have a db "mydatabase" where I set up auditing on table "mytable" for select, insert, delete and update.
When I query :sp_disp...
Bonjour,
we are in the process of upgrading our IQ 15.4 database. We have had some performance gain by simply upgrading and then by rebuilding FP indexes into NBIT.
We have also had substantial gain in migrating HG indexes into TIERED HG Indexes...
Bonjour,
I need to create a Sybase IQ 16 Dev database with a Sybase IQ 15.4 Prod Database but I need to keep users and passwords from my Dev env.
Now that my database is upgraded, how can I replace the current users with the users from Sybase !Q...
Bonjour,I'm running a Sybase ASE 15.7 Cluster Edition database and I just found something wierd about caches and very few literature about it.
I am refering at the middle section of the sp_helpcache procedure. The memory available for named caches ...
Bonjour, I am migrating an old Sybase 12 database and I need to create procedures that refers temp tables. Is there any way to force the create procedure even if it relates to table not created yet? Currently I get this :Msg 208, Level 16, State ...
Awesom Gi-sung, exactly what I was looking for.I'm having more following questions regarding this procedures.If I don't wan't to remove, one by one, all users from the currently retored procedure, is there any table I can edit to remove the users (li...
Editorial: Question has been here for 4 days now, only 10 views which some of them must be from me comming to see answers.... First option, this is a very small community or second, there is a visibility issue with questions.... or anything else but...
Thank you Mark, the Server is ASE CE 15.7 and by turning the deferred name resolution I was able to creates everything I needed. This was realy helpfull, thanks again.RegardsWilliam
