SQL Server Preproduction Tasks
Posted by Harry Zheng on 2008-11-27
1 comment
SQL Server 2008 Data Type Test
Posted by Harry Zheng on 2008-08-20
0 comments
IF EXISTS (select 1 from information_schema.columns where table_schema = ‘dbo’ and table_name = ‘DataTypeTest’)
drop table DataTypeTest;
create table DataTypeTest (
– Exact Numberics
T1Bit bit,
T1TinyInt tinyint null,
T1SmallInt SmallInt not null,
T1Int Int not null,
T1BigInt BigInt not null,
T1smallMoney smallmoney,
T1Money money,
T1Numeric numeric(18,0),
T1decimal decimal(20),
– Approximate numerics
T1float float(10),
T1real real,
–Date and Time
T1Date date,
T1DateTime datetime,
T1DateTime2 datetime2(6),
T1datetimeoffset datetimeoffset(3),
T1SmallDateTime Smalldatetime,
T1Time time(7),
–Character strings
T1char char(20),
T1text text,
T1varchar varchar(max),
–Unicode character strings
T1nchar nchar(20),
T1ntext ntext,
T1nvarchar nvarchar(20),
–Binary Strings
T1binary binary(10),
T1image image,
T1varbinary varbinary,
– Other
T1hierarchyid hierarchyid,
T1sql_variant sql_variant,
T1Timestamp Timestamp,
T1Uniqueidentifier uniqueidentifier,
T1xml xml)
select * from information_schema.columns where table_schema = ‘dbo’ and table_name = ‘DataTypeTest’ FOR XML RAW, TYPE
< row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1Bit“ ORDINAL_POSITION=“1“ IS_NULLABLE=“YES“ DATA_TYPE=“bit“ />< row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1TinyInt“ ORDINAL_POSITION=“2“ IS_NULLABLE=“YES“ DATA_TYPE=“tinyint“ NUMERIC_PRECISION=“3“ NUMERIC_PRECISION_RADIX=“10“ NUMERIC_SCALE=“0“ /><
row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1SmallInt“ ORDINAL_POSITION=“3“ IS_NULLABLE=“NO“ DATA_TYPE=“smallint“ NUMERIC_PRECISION=“5“ NUMERIC_PRECISION_RADIX=“10“ NUMERIC_SCALE=“0“ />< row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1Int“ ORDINAL_POSITION=“4“ IS_NULLABLE=“NO“ DATA_TYPE=“int“ NUMERIC_PRECISION=“10“ NUMERIC_PRECISION_RADIX=“10“ NUMERIC_SCALE=“0“ /><
row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1BigInt“ ORDINAL_POSITION=“5“ IS_NULLABLE=“NO“ DATA_TYPE=“bigint“ NUMERIC_PRECISION=“19“ NUMERIC_PRECISION_RADIX=“10“ NUMERIC_SCALE=“0“ />< row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1smallMoney“ ORDINAL_POSITION=“6“ IS_NULLABLE=“YES“ DATA_TYPE=“smallmoney“ NUMERIC_PRECISION=“10“ NUMERIC_PRECISION_RADIX=“10“ NUMERIC_SCALE=“4“ /><
row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1Money“ ORDINAL_POSITION=“7“ IS_NULLABLE=“YES“ DATA_TYPE=“money“ NUMERIC_PRECISION=“19“ NUMERIC_PRECISION_RADIX=“10“ NUMERIC_SCALE=“4“ />< row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1Numeric“ ORDINAL_POSITION=“8“ IS_NULLABLE=“YES“ DATA_TYPE=“numeric“ NUMERIC_PRECISION=“18“ NUMERIC_PRECISION_RADIX=“10“ NUMERIC_SCALE=“0“ /><
row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1decimal“ ORDINAL_POSITION=“9“ IS_NULLABLE=“YES“ DATA_TYPE=“decimal“ NUMERIC_PRECISION=“20“ NUMERIC_PRECISION_RADIX=“10“ NUMERIC_SCALE=“0“ />< row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1float“ ORDINAL_POSITION=“10“ IS_NULLABLE=“YES“ DATA_TYPE=“real“ NUMERIC_PRECISION=“24“ NUMERIC_PRECISION_RADIX=“2“ /><
row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1real“ ORDINAL_POSITION=“11“ IS_NULLABLE=“YES“ DATA_TYPE=“real“ NUMERIC_PRECISION=“24“ NUMERIC_PRECISION_RADIX=“2“ />< row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1Date“ ORDINAL_POSITION=“12“ IS_NULLABLE=“YES“ DATA_TYPE=“date“ DATETIME_PRECISION=“0“ /><
row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1DateTime“ ORDINAL_POSITION=“13“ IS_NULLABLE=“YES“ DATA_TYPE=“datetime“ DATETIME_PRECISION=“3“ />< row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1DateTime2“ ORDINAL_POSITION=“14“ IS_NULLABLE=“YES“ DATA_TYPE=“datetime2“ DATETIME_PRECISION=“6“ /><
row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1datetimeoffset“ ORDINAL_POSITION=“15“ IS_NULLABLE=“YES“ DATA_TYPE=“datetimeoffset“ DATETIME_PRECISION=“3“ />< row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1SmallDateTime“ ORDINAL_POSITION=“16“ IS_NULLABLE=“YES“ DATA_TYPE=“smalldatetime“ DATETIME_PRECISION=“0“ /><
row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1Time“ ORDINAL_POSITION=“17“ IS_NULLABLE=“YES“ DATA_TYPE=“time“ DATETIME_PRECISION=“7“ />< row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1char“ ORDINAL_POSITION=“18“ IS_NULLABLE=“YES“ DATA_TYPE=“char“ CHARACTER_MAXIMUM_LENGTH=“20“ CHARACTER_OCTET_LENGTH=“20“ CHARACTER_SET_NAME=“cp850“ COLLATION_NAME=“SQL_Latin1_General_CP850_CI_AS“ /><
row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1text“ ORDINAL_POSITION=“19“ IS_NULLABLE=“YES“ DATA_TYPE=“text“ CHARACTER_MAXIMUM_LENGTH=“2147483647“ CHARACTER_OCTET_LENGTH=“2147483647“ CHARACTER_SET_NAME=“cp850“ COLLATION_NAME=“SQL_Latin1_General_CP850_CI_AS“ />< row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1varchar“ ORDINAL_POSITION=“20“ IS_NULLABLE=“YES“ DATA_TYPE=“varchar“ CHARACTER_MAXIMUM_LENGTH=“-1“ CHARACTER_OCTET_LENGTH=“-1“ CHARACTER_SET_NAME=“cp850“ COLLATION_NAME=“SQL_Latin1_General_CP850_CI_AS“ /><
row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1nchar“ ORDINAL_POSITION=“21“ IS_NULLABLE=“YES“ DATA_TYPE=“nchar“ CHARACTER_MAXIMUM_LENGTH=“20“ CHARACTER_OCTET_LENGTH=“40“ CHARACTER_SET_NAME=“UNICODE“ COLLATION_NAME=“SQL_Latin1_General_CP850_CI_AS“ />< row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1ntext“ ORDINAL_POSITION=“22“ IS_NULLABLE=“YES“ DATA_TYPE=“ntext“ CHARACTER_MAXIMUM_LENGTH=“1073741823“ CHARACTER_OCTET_LENGTH=“2147483646“ CHARACTER_SET_NAME=“UNICODE“ COLLATION_NAME=“SQL_Latin1_General_CP850_CI_AS“ /><
row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1nvarchar“ ORDINAL_POSITION=“23“ IS_NULLABLE=“YES“ DATA_TYPE=“nvarchar“ CHARACTER_MAXIMUM_LENGTH=“20“ CHARACTER_OCTET_LENGTH=“40“ CHARACTER_SET_NAME=“UNICODE“ COLLATION_NAME=“SQL_Latin1_General_CP850_CI_AS“ />< row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1binary“ ORDINAL_POSITION=“24“ IS_NULLABLE=“YES“ DATA_TYPE=“binary“ CHARACTER_MAXIMUM_LENGTH=“10“ CHARACTER_OCTET_LENGTH=“10“ /><
row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1image“ ORDINAL_POSITION=“25“ IS_NULLABLE=“YES“ DATA_TYPE=“image“ CHARACTER_MAXIMUM_LENGTH=“2147483647“ CHARACTER_OCTET_LENGTH=“2147483647“ />< row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1varbinary“ ORDINAL_POSITION=“26“ IS_NULLABLE=“YES“ DATA_TYPE=“varbinary“ CHARACTER_MAXIMUM_LENGTH=“1“ CHARACTER_OCTET_LENGTH=“1“ /><
row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1hierarchyid“ ORDINAL_POSITION=“27“ IS_NULLABLE=“YES“ DATA_TYPE=“hierarchyid“ CHARACTER_MAXIMUM_LENGTH=“892“ CHARACTER_OCTET_LENGTH=“892“ />< row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1sql_variant“ ORDINAL_POSITION=“28“ IS_NULLABLE=“YES“ DATA_TYPE=“sql_variant“ CHARACTER_MAXIMUM_LENGTH=“0“ CHARACTER_OCTET_LENGTH=“0“ /><
row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1Timestamp“ ORDINAL_POSITION=“29“ IS_NULLABLE=“NO“ DATA_TYPE=“timestamp“ />< row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1Uniqueidentifier“ ORDINAL_POSITION=“30“ IS_NULLABLE=“YES“ DATA_TYPE=“uniqueidentifier“ />< row TABLE_CATALOG=“SFSNEXT“ TABLE_SCHEMA=“dbo“ TABLE_NAME=“DataTypeTest“ COLUMN_NAME=“T1xml“ ORDINAL_POSITION=“31“ IS_NULLABLE=“YES“ DATA_TYPE=“xml“ CHARACTER_MAXIMUM_LENGTH=“-1“ CHARACTER_OCTET_LENGTH=“-1“ />
Install Microsoft Query with windows installer error 1648
Posted by Harry Zheng on 2008-04-18
0 comments
Follow this article to resolve:
http://support.microsoft.com/kb/913754
Cause: Registry key/value missing at HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Nls\CodePage registry subkey.
| Name | Type | Value |
| 850 | REG_SZ | c_850.nls |
| 852 | REG_SZ | c_852.nls |
| 855 | REG_SZ | c_855.nls |
| 857 | REG_SZ | c_857.nls |
| 860 | REG_SZ | c_860.nls |
| 861 | REG_SZ | c_861.nls |
| 863 | REG_SZ | c_863.nls |
| 865 | REG_SZ | c_865.nls |
| 866 | REG_SZ | c_866.nls |
| 867 | REG_SZ | c_867.nls |
| 868 | REG_SZ | c_868.nls |
| 869 | REG_SZ | c_869.nls |
| 874 | REG_SZ | c_874.nls |
| 875 | REG_SZ | c_875.nls |
| 932 | REG_SZ | c_932.nls |
| 936 | REG_SZ | c_936.nls |
| 949 | REG_SZ | c_949.nls |
| 950 | REG_SZ | c_950.nls |
An error occurred while creating a Page Server subprocess
Posted by Harry Zheng on 2008-04-17
0 comments
Encountered the error “An error occurred while creating a Page Server subprocess” on InfoView when trying to view a report.
Didn’t find anything useful on the log directory.
It may be a resource issue as I run BO from my laptop. Still need to find out the root cause.
Some mentioned it may be related to “KBase Article ID: c2017905.
How to rename DTEngine Cluster Name and/or NodeName
Posted by Harry Zheng on 2008-04-16
0 comments
- Connect to the repository database
set current schema DTENGINE
Select * from DT_CLUSTER_INFO;
update DT_CLUSTER_INFO set cluster_name = ‘MYCLUSTER1′
Select * from DT_CLUSTER_NODES_INFO;
update DT_CLUSTER_NODES_INFO set NODE_NAME = ‘MYNODENAME’, host_name = ‘MYHOSTNAME’ Where NODE_NAME = ‘OLDNODENAME’;
- vi $DT_HOME/bin/dtengine.sp
jboss.partition.name=MYCLUSTER1
- vi $DT_HOME/configure/DTEngine.properties
#The logical node name of this node.This is a unique name
#across the cluster.
com.embarcadero.dt.agent.logicalNodeName=MYNODENAME
