During the install, the error “OS error in starting service oraclemtsrecoveryservice” To resolve, edit registry key: [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE\Ora cleMTSRecoveryService\Protid_0] Edit the Host key and set to the machine name.
Use the following to determine if your MSSQL database has features only available in enterprise versions of the product (partitioning, compression, encryption, etc). 1select * from sys.dm_db_persisted_sku_features
1). When an error is generated. Such as when trying to do a page load of Vault Admin 2). Check the Vault error log on the Vault server Windows\Temp\sgvault\sgvault.log 3). …
Ubuntu Server with only a command line interface 1). Go to Virtual Machine > Install VMware Tools (or VM > Install VMware Tools). Note: If you are running the light …
To enable sshd on ESXi 5.5 1). Login to vSphere 2). Click the host > configuration > Security profile 3). Click Services > Properties 4). Select SSH > Options 5). …
Oracle 12.1.0.1 Standard, create a user for a specific PDB. 1234567891011121314151617181920C:\> sqlplus SYSTEM@oracle12 Enter password: ******** SQL> SELECT PDB FROM v$services; PDB ———– MYDB CDB$ROOT SQL> ALTER SESSION SET container=MYDB; …
Determine the size of database tables in a MSSQL Server Database. 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647SELECT DB_NAME() AS DatabaseNase , GETDATE() AS DateCreated , TableName, Rows …
Original Source Link 1234567891011121314151617181920212223242526272829303132COLUMN TABLE_NAME FORMAT A32 COLUMN OBJECT_NAME FORMAT A32 COLUMN OWNER FORMAT A10 SELECT owner, table_name, TRUNC(sum(bytes)/1024/1024) Meg FROM (SELECT segment_name table_name, owner, bytes FROM dba_segments WHERE …
12345678static public string ConvertToText(string rtf) { using(RichTextBox rtb = new RichTextBox()) { rtb.Rtf = rtf; return rtb.Text; } } Catch ArgumentException …
Determine if a decimal number can be converted to an INT without any loss of precision. Check if either of the rightmost two digits are non-zero 123substring(convert(varchar(10), a.DebitAmount), len(convert(varchar(10), a.DebitAmount)) …
