Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MurphyL
Starting Member
3 Posts |
 Posted - 2012-07-30 : 04:15:57
|
| 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 boundupdate [BarcodeTest].dbo.SystemObjectUserFieldDataset [BarcodeTest].dbo.SystemObjectUserFieldData.String1 = [acedbak].dbo.SystemObjectUserFieldData.string1 from [BarcodeTest].dbo..SystemObjectUserFieldDatainner join [acedbak].dbo.SystemObjectUserFieldData.String1 on [BarcodeTest].dbo.SystemObjectUserFieldData.SystemObjectKey = [acedbak].dbo.SystemObjectUserFieldData.SystemObjectKey |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-07-30 : 04:50:27
|
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 boundupdate [BarcodeTest].dbo.SystemObjectUserFieldDataset [BarcodeTest].dbo.SystemObjectUserFieldData.String1 = [acedbak].dbo.SystemObjectUserFieldData.string1 from [BarcodeTest].dbo..SystemObjectUserFieldDatainner 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. |
 |
|
|
MurphyL
Starting Member
3 Posts |
Posted - 2012-07-30 : 05:06:05
|
| Removed the extra . Still no Joy. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-07-30 : 05:11:51
|
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. |
|
|
|
MurphyL
Starting Member
3 Posts |
Posted - 2012-07-31 : 02:25:41
|
| 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.SystemObjectUserFieldDataset [BarcodeTest].dbo.SystemObjectUserFieldData.String1 = [acedbak].dbo.SystemObjectUserFieldData.string1 from [BarcodeTest].dbo.SystemObjectUserFieldDatainner join [acedbak].dbo.SystemObjectUserFieldData.String1 on [BarcodeTest].dbo.SystemObjectUserFieldData.SystemObjectKey = [acedbak].dbo.SystemObjectUserFieldData.SystemObjectKeyThe 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. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-07-31 : 03:10:54
|
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. |
|
|
|
|
|
|
Restore Column from Previous Database