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

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME='RecVersion' order by TABLE_NAME

-- drop rowguid indexes select 'drop index ' + sysobjects . name + '.' + sysindexes . name from sysindexes inner join sysobjects on sysindexes . id = sysobjects . id where objectproperty ( object_id ( sysobjects . name ), 'IsMSShipped' ) = 0 and sysindexes . indid > 0 and sysindexes . indid 255 and ( sysindexes . status & 64 )= 0 and index_col ( sysobjects . name , sysindexes . indid , 1 ) = 'rowguid' order by sysindexes . indid -- remove rowguid default constraints select 'alter table ' + b . name + ' drop constraint ' + a . name from sysobjects a inner join syscolumns on syscolumns . id = a . parent_obj inner join sysobjects b on syscolumns . id = b . id where syscolumns . name = 'rowguid' and objectproperty ( object_id ( b . name ), 'IsMSShipped' ) = 0 and a . xtype = 'D...

I've omitted some extra columns from the result set. The logical names always seem to be tempdev and templog. Knowing this we can run the following ALTER DATABASE statement in SQL Server 2000 or SQL Server 2005 to move tempdb. Set the FILENAME parameter to the location where you'd like each file. USE master GO ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = 'C:\tempdb2005.mdf') GO ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = 'C:\tempdb2005.ldf') GO

This section lists the most common issues encountered when building the integration between Microsoft Dynamics® AX, SSRS and OLAP and the solution recommended by the Microsoft Dynamics® AX Support team. Issue: Error trying to deploy reports Microsoft Dynamics AX Reporting Project Deployment: The following components have not been installed or are not configured correctly: AL.exe Solution: Download and install the Windows SDK for Windows Server 2008 and .NET Framework 3.5 Ensure it is fully installed. NOTE: Install regardless of operating system Issue: Error trying to deploy reports System.InvalidOperationException: The following components have not been installed or are not configured correctly: Microsoft Domain-Specific Language Tools Solution: Download and install these required components. Microsoft Visual Studio 2008 Shell (isolated mode) Redistributable Package 1. Save the download locally 2. Extract the package 3. Run the vs_appenvredist.msi NOTE: Install regardless of ope...

To get the product version, use : SELECT SERVERPROPERTY('productversion') as ProductVersion returns '9.00.3042.00' on my machine To get the Service Pack information or the level of version, use : SELECT SERVERPROPERTY ('productlevel') as Level returns 'SP2' on my machine To get the product edition, use : SELECT SERVERPROPERTY('edition') as EDITION returns 'Developer Edition' on my machine