Everything for SAP Hana / Basis /Technology / BO / BW

AOS Settings Max open cursors (Default=90) (200) Buffer size (Default=24KB) (500KB) Array fetch ahead (Default=100) Order by clause from where clause

* Delete RecVersion * SELECT * FROM syscolumns WHERE (name LIKE '%recVersion%') AND (id IN (SELECT id FROM SYSOBJECTS WHERE NAME IN (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = 'recVersion')))

MOSS Language Pack Installation How to install Language pack on your live sharepoint environment? Sample; We install sp2 english moss, integrated language pack turkish 1- Moss 2007 SP x64 English 2- WSS 3.0 LP SP0 x64 Turkish 3- Moss 2007 LP0 x64 Turkish 4- WSS 3.0 LP SP2 x64 Turkish 5- Moss 2007 LP SP2 x64 Turkish - Wizard

COMMITTED SNAPSHOT ON ? check your db Check: SELECT name , is_read_committed_snapshot_on FROM sys.databases Run: ALTER DATABASE [ ] SET READ_COMMITTED_SNAPSHOT ON

Fix for 'The database principal owns a schema in the database, and cannot be dropped' Error in SQL Server 2005 I was trying to restore one database backup; which I successfully did (I'm using SQL Server 2005), and want to delete the users of the database which are restored along with the DB; I received this error which says "The database principal owns a schema in the database, and cannot be dropped". While I googled the error, I found that the user which i want to delete is called "Database Principal" is having "DB_Owner" Role selected. That means the Database Pricipal I want to delete owns the Schema. One solution was to delete the Schema and then delete the user, :-) which I am obviously not going to do. Another Solution was to change the DB_Owner to some another "Database Principal"; let say to "dbo". I did it accordingly and then I was able to delete the user/Database Pricipal successfully. To change the DB_Owne...