After adding linked server on Microsoft SQL 2008, it’s time to query data from it. So how to query data from linked server on Microsoft SQL 2008?

Just run below query…

SELECT * FROM OPENQUERY
(LinkedServerName,’SELECT * FROM master.sys.servers‘)
GO

LinkedServerName is the linked server that you want to query from. And replace the query statement with your own query. Then you are ready to go.

• 0 Comments

Want to query data from other database server like Oracle, Access, IBM DB2 or even Microsoft Excel Spreadsheet, ODBC data source and file system? All you need to do is to add them as linked server on Microsoft SQL 2008. And remote stored procedures can be executed too.

Run below queries to add linked server

EXEC master.dbo.sp_addlinkedserver @server = N’ServerName‘, @provider = N’SQLOLEDB’, @datasrc = N’DataSource‘, @srvproduct=”

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N’ServerName‘,@useself=N’False’,@locallogin=NULL,@rmtuser=N’UserName‘,@rmtpassword=’Password‘

sp_addlinkedserver is used to create a linked server.
sp_addlinkedsrvlogin is used to create login on the linked server.
That’s all.

• 2 Comments

Introduction
EASEUS Partition Master is hard disk partition management software from EASEUS ~ CHENGDU YIWO Tech Development Co., Ltd. It is used to resize, move, copy, create, delete, format, convert, explore, hide and unhide partitions for Windows Server 2000/2003/2008 and Windows 2000/XP/Vista. It has 4 editions which are Home Edition (free for home user), Professional Edition, Server Edition and Unlimited Edition (32bit and 64bit).

EASEUS Partition Master 3.5 Server Edition

(more…)

• 2 Comments

Yes! JayceOoi.com has a good start in year 2009. The traffic increases after I changed Google Analytics code from footer to header. This is a nice trick to get more hits. Why? Not all visitors will wait until your website page complete loading. JayceOoi.com has lot of stuffs to load. Therefore, Google Analytics missed capture some visitors who did not wait so long. After changing it, you can see the result as below. Cool…

JayceOoi.com January Google Analytics stats

(more…)

• 9 Comments

Do you know how Olympic Beijing 2008 logo come from?

(more…)

• 9 Comments