The Multifunctioning DBA:

May, 2010

After the Sybase upgrade, my boss needed to know how many users we have connecting to a specific database using a specific application. In order to accomplish this I extracted sp_who and modified it to gather the information that I needed. I also did not overwrite the original sp_who but I had it...

Recently I did an upgrade from Sybase 12.5 to Sybase 15.0 and this upgrade changed some system tables that broke the scripts that we had in place to generate DDL for all the devices and database creates. I have been working on fixing this issue and I have resolved the issue by modifying our scripts...

About This Blog

This blog is written by an IT professional with over 5 years experience in Windows Server Administration. New to the DBA world, Colin Smith is now involved with Microsoft SQL Server, Oracle and Sybase databases. This blog covers database administration, Windows administration, Scripting and more.