Thanks Gaz

I found a solutions. I tried as administrator option and administrator user name and password.

I opened IE as an administrator and tried but I got the same issue. 🙁

It's RTM version.

It's RTM version.

It's RTM version.

This code lists databases available in the local server, not remote server 10.0.172.53. ODS database is available in the remote server. So, ODS database does not listed in the above...

ODS

I get list of databases available in the local server. But I need to retrieve data from Remote server.

ODS database is not available in the local server. It is available in the remote server. I need get data from remote server.

Hi Chris Morris,

Thanks for your reply. When I execute your code I get database available in the local server. Not the remote server(10.0.172.53).

Can I use CTE in SQL Server 2000?

DECLARE @counter as int

SET @counter = 0

WHILE @counter < 10

BEGIN

--Your code here

PRINT @counter

SET @counter = @counter + 1

END

DECLARE @date AS DATETIME

SET @date = '2007/01/01'

SELECT CONVERT(VARCHAR,@date,112)

You may do this on triggers.

CREATE TRIGGER insert_balance ON [dbo].[TEST]

FOR INSERT

AS

UPDATE Test

SET Balance = (inserted.Debit - inserted.Credit)

+ COALESCE((SELECT TOP 1 Balance FROM Test

WHERE ID<(SELECT MAX([ID])

FROM...

Try this,

SELECT COUNT(ACCOUNT) FROM

(SELECT COUNT(DISTINCT ACCOUNT) AS ACCOUNT

FROM dxhistory

WHERE RANK=1

GROUP BY ACCOUNT, RANK

HAVING COUNT(RANK)>1)AS T