Looks like you need second instance.

To access different databases in same instance, you just need to use qualified name like databasename.owner.tablename.

For example, select * from db1.dbo.table1 T1 inner join db2.dbo.table2 T2 on T1.id = T2.id

You may not even need JDBC for SQL Server in Windwos platform when running ColdFusion MX. ColdFusion MX comes with its own ODBC server which can be used to communicate...

Have any linked servers configured to access this server? Any scheduled Window tasks? (Control panel --> Scheduled Tasks)

Can you post the result of "select loginname from syslogins" here?

Yes. It looks like.

Do you run clustered SQL Server or non-clustered SQL Server? Any schedule jobs fail?

Start Profiler (Event : Security Audit - Audit Login Failed) to trace which application is tring to access your server with 'sa' login.

xp_readerrorlog is one of function of xpstar.dll which run after the startup procedure.

"2000.80.194.0 is the version of xpstar.dll"

It looks you don't have service pack. Try to install sp3a to see whether your problem can be resolved.

Many ways. One is "osql.exe -L".

Any changes?

http://support.microsoft.com/default.aspx?scid=kb;en-us;833045&Product=sql2k

http://support.microsoft.com/default.aspx?scid=kb;en-us;328197&Product=sql2k

Do you use  Microsoft SQL Server Notification Services to sent out E-mail notifications?

begin tran

truncate table cs_ord

go --- You need remove 'go' here from your codes.

insert into cs_ord(Order_Num, Amount)

SELECT T1.SO as Order_Num,

CASE WHEN (SUM (T1.C_CHORHI_CHANGE_NUM = '0')

                        THEN (T1.AMT)

                                 ELSE (T1.CHANGE_AMT)

                       END...