SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Restore Column from Previous Database		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

MurphyL
Starting Member

3 Posts
Posted - 07/30/2012 :  04:15:57  Show Profile  Reply with Quote
we had an accidental update to one column on a table. I need to work out what is wrong with the script below. I am trying to uddate a table column from a backup to a new database. I am getting an error The Multi part Identifier "acedbak.dbo.dbo.SystemObjectUserFieldData"Could not be bound
update [BarcodeTest].dbo.SystemObjectUserFieldData
set [BarcodeTest].dbo.SystemObjectUserFieldData.String1 = [acedbak].dbo.SystemObjectUserFieldData.string1
from [BarcodeTest].dbo..SystemObjectUserFieldData
inner join [acedbak].dbo.SystemObjectUserFieldData.String1
on [BarcodeTest].dbo.SystemObjectUserFieldData.SystemObjectKey = [acedbak].dbo.SystemObjectUserFieldData.SystemObjectKey

webfred
Flowing Fount of Yak Knowledge

Germany
8513 Posts
Posted - 07/30/2012 :  04:50:27  Show Profile  Visit webfred's Homepage  Reply with Quote
quote:
Originally posted by MurphyL

we had an accidental update to one column on a table. I need to work out what is wrong with the script below. I am trying to uddate a table column from a backup to a new database. I am getting an error The Multi part Identifier "acedbak.dbo.dbo.SystemObjectUserFieldData"Could not be bound
update [BarcodeTest].dbo.SystemObjectUserFieldData
set [BarcodeTest].dbo.SystemObjectUserFieldData.String1 = [acedbak].dbo.SystemObjectUserFieldData.string1
from [BarcodeTest].dbo..SystemObjectUserFieldData
inner join [acedbak].dbo.SystemObjectUserFieldData.String1
on [BarcodeTest].dbo.SystemObjectUserFieldData.SystemObjectKey = [acedbak].dbo.SystemObjectUserFieldData.SystemObjectKey


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

MurphyL
Starting Member

3 Posts
Posted - 07/30/2012 :  05:06:05  Show Profile  Reply with Quote
Removed the extra . Still no Joy.
Go to Top of Page

webfred
Flowing Fount of Yak Knowledge

Germany
8513 Posts
Posted - 07/30/2012 :  05:11:51  Show Profile  Visit webfred's Homepage  Reply with Quote
Any new error messages?
We can't see what you are doing and what you can see...

And this:
quote:
inner join [acedbak].dbo.SystemObjectUserFieldData.String1


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

MurphyL
Starting Member

3 Posts
Posted - 07/31/2012 :  02:25:41  Show Profile  Reply with Quote
Let me start over. I am getting an error The Multi part Identifier "acedbak.dbo.dbo.SystemObjectUserFieldData"Could not be bound in the following areas in red. Sting1 is a column name.
update [BarcodeTest].dbo.SystemObjectUserFieldData
set [BarcodeTest].dbo.SystemObjectUserFieldData.String1 = [acedbak].dbo.SystemObjectUserFieldData.string1
from [BarcodeTest].dbo.SystemObjectUserFieldData
inner join [acedbak].dbo.SystemObjectUserFieldData.String1
on [BarcodeTest].dbo.SystemObjectUserFieldData.SystemObjectKey = [acedbak].dbo.SystemObjectUserFieldData.SystemObjectKey
The purpose of this is to restore a table column with a previous backup. The only issue I am having is with the Error stated above. If I can get past that I can deal with the rest.

Thanks for all of your help.
Go to Top of Page

webfred
Flowing Fount of Yak Knowledge

Germany
8513 Posts
Posted - 07/31/2012 :  03:10:54  Show Profile  Visit webfred's Homepage  Reply with Quote
quote:
Originally posted by webfred

Any new error messages?
We can't see what you are doing and what you can see...

And this:
quote:
inner join [acedbak].dbo.SystemObjectUserFieldData.String1


No, you're never too old to Yak'n'Roll if you're too young to die.

Consider this please!
You can join a table - you cant join a column - so remove that please.

No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000