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

Hi, Before you make any operation you must know the AIX file system, How to ; Method 1: login with root lsvg -l rootvg then you decide file system , journal or enhanced journal fs.

Hi All, if you moved sql server system database other than default location then you wont be able to start SQl Server Agent Services in failover cluster environment.I was trying to install SQL Server Agent Services in failover cluster but the setup did not complete succesfuly.upon further investigation this issue caused dns entry and regedit You should make this, After attempting to upgrade one of my servers to SQL Server 2008/2012 I found that the installer would error on installing the database engine.  The messge was: “The Database Engine system data directory in the registry is not valid.” I found the installer looks in  HKLM\software\microsoft\microsoft sql server\%instance_name%\setup\SQLDataRoot to discover the path to the system databases.  This key was created during the 2008 R2 installation and the files were subsequently moved so what was created at install time is no longer correct. If you modify this key to the path configured in the...

Hi All, Today has a different demand.The customer asked special characters in database. firstly I created stored procedure as below.Then you run the procedure like I write. Important point is you must configure db collation before you run in searchalltables. *Für Deutsch versionen müssen sie fragen auf mich.Ich helf ihnen gern. Create this procedure in the required database and here is how you run it: --To search all columns of all tables in Pubs database for the keyword "Computer"   EXEC SearchAllTables 'Computer' GO *************************************************************************** Here is complete stored procedure, copy all code to query to run. CREATE PROC SearchAllTables ( @SearchStr nvarchar(100) ) AS BEGIN CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue nvarchar(3630)) SET NOCOUNT ON DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110) SET @TableName = '' SET @S...

To move the model, msdb and tempdb databases: Single user mode is no longer necessary, neither is the 3608 trace flag. Now its a simple alter command: --Move Model Database USE master ; GO ALTER DATABASE model MODIFY FILE ( NAME = modeldev , FILENAME = 'E:\DATA\model.mdf' ); GO ALTER DATABASE model MODIFY FILE ( NAME = Modellog , FILENAME = 'E:\DATA\modelLog.ldf' ); GO --Move MSDB Database USE master ; GO ALTER DATABASE msdb MODIFY FILE ( NAME = MSDBData , FILENAME = 'E:\DATA\MSDBData.mdf' ); GO ALTER DATABASE msdb MODIFY FILE ( NAME = MSDBLog , FILENAME = 'E:\DATA\MSDBLog.ldf' ); GO --Move Tempdb Database USE master ; GO ALTER DATABASE tempdb MODIFY FILE ( NAME = tempdev , FILENAME = 'E:\DATA\tempdb.mdf' ); GO ALTER DATABASE tempdb MODIFY FILE ( NAME = templog , FILENAME = 'E:\DATA\tempLog.ldf' ); GO Stop the instance, physically move the model and msdb files to the new location, and restart the instance. Te...

Problem When you run powershell on your server you get the following error:The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered. Solution Make sure the logged in user has rights to the SharePoint_Configuration databaseSharePoint_Shell_AccessDB_owner (try reducing the privileges after you get it working in order to support “least privileges

Dynamics AX 2012 RTM 6.0.947.06.0.947.0 RTM Dynamics AX 2012 RTM Hotfix6.0.947.xxx6.0.947.xxx Published Hotfixes Dynamics AX 2012 CU 16.0.947.616.0.947.61 Cumulative Update 1 Dynamics AX 2012 CU26.0.947.2806.0.947.280 Cumulative Update 2

Lock Drive Without Any Software Step 1 : Goto "RUN" and type "gpedit.msc" Step 2 : A window will be opened (Group Policy).You will find two options in left side of the page. Step 3 : Drop down the "user configuration" and again drop down sub menu "Administrative Templetes" and again drop down another sub menu "Windows Components" and click on "Windows Explorer". Step 4 : Right click on "Prevent Access To Drives From My Computers" and then click on properties. Step 5 : Click on the radio button "Enabled" and you can select any option in the menu. Step 6 : Follow the same procedure for disabling it.

Hi All, The problem is that the terminal server will function just fine for a week or so and then suddenly when a new user tries to log on they get an error message indicating that not enough resources are available to log them on Resolution: 1) Create/edit these values in the registry:HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\MemoryManagement“PoolUsageMaximum”=dword:00000030“PagedPoolSize”=dword:ffffffff2) Restart. Also Refer to the KB: http://support.microsoft.com/kb/312362

I turned military service and write back smoothly. In this case i setup exchange 2010. but suddenlty i become above transport message "MsExchangeTransport" You can use my solution on this text. I hope you help! After disabling my setup went smoothly, follow the below instructions to disable IPv6 from your system.To completely disable IPv6 on a Windows Server 2008-based system, follow these steps: 1. Open Registry Editor. 2. Locate the following registry subkey:HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip6\Parameters 3. In the details pane, click New, and then click DWORD (32-bit) Value. 4. Type DisabledComponents, and then press ENTER. 5. Double-click DisabledComponents, and then type 0xffffffff in Hexadecimal or 4294967295 in Decimal.If setup still gives error, remove IPv6 entry from “hosts” file %systemroot%\system32\drivers\etc then enable ip6 from network by changing adapter settings.