I remember my first experience with datatypes, like;

DECLARE @1value int

DECLARE @2value int

SET @1value = 3

SET @2value = 2

SELECT @1value / @2value

Thanks for your interest.

Another funny thing: When I add linked server via script it works. eg:

EXEC sp_addlinkedserver 'SERVER2k', N'SQL Server';

GO

EXEC sp_addlinkedsrvlogin 'SERVER2k', 'false', 'sqluser', 'sqluser', 'p@ssw0rd'

GO

sp_testlinkedserver SERVER2k;

GO

no problem, but when...

Yes I have executed instcat.sql, nothing changed.

I found another interesting thing.

As I mentioned before, when I map local user account on 2005 to sql user account on 2000 it works, but...

Thanks for your reply,

Its not a 64 bits system. I have read about "instcat.sql" but as you mentioned its for 64bits systems. One interesting thing is, when I map Local...