Viewing 3 posts - 1 through 3 (of 3 total)
Try using openrowset(provide=SQLOLEDB.1) to connect another sql server. if that work then I guess there is some resgistry issue.
February 1, 2010 at 11:17 am
#1111831
Have any one resolved this issue. Me too having same problem
When I execute SELECT * FROM [LinkedServer].[Database].[dbo].[TableName] i get the following error message: -
Server: Msg 7399, Level 16, State 1,...
August 13, 2007 at 11:05 am
#726543
My sql server is 2000 32 bit. and during sp4 installation everything went smooth.
August 13, 2007 at 10:42 am
#726529