ASP.NET

14-Apr-09 19:25

i write this code in my sqlserver does anybody know why it doesnt work. it has error in inner join. plz help Sigh | :sigh:

UPDATE [servername1].[WebSite].[dbo].[Table_1] INNER JOIN [servername2].[website1].[dbo].[Table_2] ON Table_1.id = Table_2.id SET Table_1.name1 = [Table_1].[name2]

Abhijit Jana14-Apr-09 19:35

Abhijit Jana

14-Apr-09 19:35

This is ASP.NET Forum , please post it in SQL Forum.

cheers,
Abhijit
CodeProject MVP

Vimalsoft(Pty) Ltd14-Apr-09 23:16

14-Apr-09 23:16

Do not Post SQL Questions here. I hope its the Last time you do this. You need to use a "from" like this

UPDATE [servername1].[WebSite].[dbo].[Table_1] 
SET Table_1.name1 = [Table_1].[name2]
FROM [servername1].[WebSite].[dbo].[Table_1]
INNER JOIN [servername2].[website1].[dbo].[Table_2]
ON Table_1.id = Table_2.id 
pre>

Check the your Statement from the Bolded and what ever follows 


Hope this Helps


Vuyiswa Maseko 

<div class="ForumSig">Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." 

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
</div>

ptvce14-Apr-09 23:42

14-Apr-09 23:42

thanks for ur help, yes is it work now but if my tables be in diffrent server it has error i have problem when i have 2 server

and thats error is : Could not find server 'SPSERVER16' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.

Vimalsoft(Pty) Ltd14-Apr-09 23:44

14-Apr-09 23:44

Check your Permissions in the Link Servers

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za

ptvce15-Apr-09 0:41

15-Apr-09 0:41

i run this:
EXEC sp_addlinkedserver
@server = 'SPSERVER16',
@srvproduct = '',
@provider = 'SQLNCLI',
@datasrc = 'SPSERVER16'
GO

and then run this:

EXEC sp_addlinkedsrvlogin spserver16, FALSE, sa, 1234
and its succses
and then run:

EXEC sp_tables_ex spserver16
GO

and it has this error:

Login failed for user ''. The user is not associated with a trusted SQL Server connection.

Vimalsoft(Pty) Ltd15-Apr-09 0:49

15-Apr-09 0:49

Why don't you add a link Server manually not from T-SQL, supplies the credentials there , and in your Code you call the name of the Link server. Doing it in T-SQl you might encounter credentials Problem

ptvce15-Apr-09 0:59

15-Apr-09 0:59

both of them is equal, when i manually create linked server i has this problem too

Vimalsoft(Pty) Ltd15-Apr-09 1:06

15-Apr-09 1:06

Talk to your DBA about the Problem , remember again not everyone can create a Link server, sometimes you might Create a link server and not have permissions to access data on the Other side. Your have a permission Issue.

ptvce15-Apr-09 1:22

15-Apr-09 1:22

heyyy finally i can solve the problem this form with 3 procdure:
///////
1.
EXEC sp_addlinkedserver
@server = 'SPSERVER16',
@srvproduct = '',
@provider = 'SQLNCLI',
@datasrc = 'SPSERVER16'
GO

////////
2.
EXEC sp_addlinkedsrvlogin spserver16, FALSE,SADAFIT-9D6E926\administrator,sa ,1234
////////
3.
EXEC sp_tables_ex spserver16
GO

thanks for ur help Vuyiswa Maseko Rose | [Rose]

Vimalsoft(Pty) Ltd15-Apr-09 1:47