NO ROWS Function ‘rs_get_textptr’ for ‘sometable’ returned no rows, table example:- create table test_tab( cola int not null, colb_txt text null) This occurs with columns containing text columns. The problem is you forgot sp_setrepcol. The default for text/image is always replicate and so not null is assumed. So you need to run sp_setrepcol to set […]
Reasons not to grant db_owner DBO can do some nasty stuff:- CHANGE RECOVERY MODEL BACKUP DATABASE ALTER ANY SYMMETRIC KEY TURN ON/OFF AUTOSHRINK ADD FILE AUTO_UPDATE_STATISTICS SET RECURSIVE_TRIGGERS DROP DATABASE SET OFFLINE If you must create database objects, view showplans/dynamic tables or more but do not want to give away ‘the keys to the […]
I was asked recently to setup Heterogeneous SAP replication from SAP ASE to SQL Server and then the task was extended to also replicate to an Azure Database. This can be complicated to setup and get working so I documented the procedure and updated our PDF downloadable instructions available from, http://www.dbxperts.co.uk/downloads/ A common issue with the […]
Detailed notes on reviewing existing DBCCDB for use with ‘check storage’ DBCCDB review First, find out what ASE recommends you set the minimum values to using > sp_plan_dbccdb <dbname> Then, we work through these values and we pay attention to the settings below. check size of dbccdb check size of dbccdb_cache check scan ws value […]
If you want to backup your SQL Server databases you normally use the Maintenance Plan Wizard to generate an automated job to do just that. But what if you want to backup across multiple files to improve the backup performance ( on multi CPU servers) AND still included an automatically generated date/time stamp within the […]
Why should different version of Sybase on a single Windows server be an issue? If you install multiple versions of Sybase ASE, the paths will become filled with contradictory references to both Sybase install locations. The Windows servers may or may not start but even if they do, you cannot be 100% sure which library […]
Our SAP Sybase Replication servers sometimes suddenly start using unexpectedly high amount of stable queue. So I wrote this short script to check the size of the stable queue usage and send an alert if any the % usages is greater than the value of $ALERT_PERCENT. Then when a user starts running a massive batch […]
Since 15.7 sp1xx there has been a great new facility to increase and decrease log segments in an ASE database but did you know that you could end up with a row in the sysusages table that you cannot get rid of? Further research shows this to be a know issue with the use of […]
Sometimes we want to recreate an existing error class, for example, taking one from production into a new UAT environment. It is not really possible to do this but we can work out the modified error codes in the user defined error class and then manually recreate the class. Run the SQL, in the RSSD, […]
