Hi,
I tried to use 'Minimum Conflict Resolver' for Orders table of Northwind.
I entered EmployeeID as 'the information needed by the resolver' and also
modified this column for a same row in two different subscribers.
I updated one of them to 1 and the other to 5. I expected 1 become the
winner but the merge agent fails with an error regarding EmployeeID.
Should I expect anything different or the resolver needs other information
than EmployeeID?
Any help would be greatly appreciated.
Leila
are you using column level tracking?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Leila" <leilas@.hotpop.com> wrote in message
news:ez2ezm7YFHA.3320@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I tried to use 'Minimum Conflict Resolver' for Orders table of Northwind.
> I entered EmployeeID as 'the information needed by the resolver' and also
> modified this column for a same row in two different subscribers.
> I updated one of them to 1 and the other to 5. I expected 1 become the
> winner but the merge agent fails with an error regarding EmployeeID.
> Should I expect anything different or the resolver needs other information
> than EmployeeID?
> Any help would be greatly appreciated.
> Leila
>
|||If you mean the item "treat changes to the same row as a conflict", I have
tried both items. This is the error:
The specified conflict resolution column 'employeeid' could not be found.
(Source: Merge Process (Agent); Error number: -2147467259)
Leila
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OZ3m0cQZFHA.1404@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> are you using column level tracking?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Leila" <leilas@.hotpop.com> wrote in message
> news:ez2ezm7YFHA.3320@.TK2MSFTNGP12.phx.gbl...
Northwind.[vbcol=seagreen]
also[vbcol=seagreen]
information
>
|||I'm getting the same error. I will be reporting this to MS - it looks like a
bug.
I'll try to follow up with you using your hotpop email address if this is
legit.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Leila" <leilas@.hotpop.com> wrote in message
news:eHXSnzUZFHA.3184@.TK2MSFTNGP15.phx.gbl...
> If you mean the item "treat changes to the same row as a conflict", I have
> tried both items. This is the error:
> The specified conflict resolution column 'employeeid' could not be found.
> (Source: Merge Process (Agent); Error number: -2147467259)
> Leila
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:OZ3m0cQZFHA.1404@.TK2MSFTNGP09.phx.gbl...
> Northwind.
> also
> information
>
|||trying a simpler table
However, a more simple table, i.e.
create table mergetest
(pk int not null identity constraint primarykey primary key,
charcol1 char(20),
intcol int)
will work i.e.
update mergetest set charcol1='publisher', intcol=2 where pk=1
update northwindsub.dbo.mergetest set charcol1='subscriber', intcol=1 where
pk=1
works where the northwindsub conflict wins (if the intcol column is used as
the basis of the column for the minimum conflict resolver).
Not sure what the problem is.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uLaM4NYZFHA.4088@.TK2MSFTNGP15.phx.gbl...
> I'm getting the same error. I will be reporting this to MS - it looks like
a[vbcol=seagreen]
> bug.
> I'll try to follow up with you using your hotpop email address if this is
> legit.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Leila" <leilas@.hotpop.com> wrote in message
> news:eHXSnzUZFHA.3184@.TK2MSFTNGP15.phx.gbl...
have[vbcol=seagreen]
found.[vbcol=seagreen]
the
>
|||Thanks indeed!
Please keep me informed: leilas@.hotpop.com
Leila
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uLaM4NYZFHA.4088@.TK2MSFTNGP15.phx.gbl...
> I'm getting the same error. I will be reporting this to MS - it looks like
a[vbcol=seagreen]
> bug.
> I'll try to follow up with you using your hotpop email address if this is
> legit.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Leila" <leilas@.hotpop.com> wrote in message
> news:eHXSnzUZFHA.3184@.TK2MSFTNGP15.phx.gbl...
have[vbcol=seagreen]
found.[vbcol=seagreen]
the
>
Showing posts with label northwind. Show all posts
Showing posts with label northwind. Show all posts
Wednesday, March 21, 2012
Friday, March 9, 2012
Migration to sql server on network for access database
hi,
I migrated the Northwind database using SQL Migration Assistant for Access. it worked fine and I was able to link the access forms to Local machine SQL Server 2005 and it worked fine.
Now i want to link the same Northwind access database to Another Server on the network.
When i try to run the wizard again, it won't migrate the user objects like tables to server, it will just create a database and that is it.
it will give me this error too.
No User objects were selected.
any idea,
Thanks,
Fahim
Since you have already migrated to your local SQL Server, you could use the Import/Export Wizard to move the tables to a different SQL Server.
In the Object Explorer, right-click on the database, select [Task..], and then click on Export Data...
Monday, February 20, 2012
migrating to 2005 troubles :(
hey guys
just to do a test run i wanted to migrate the northwind database from
2000 to 2005
when i do a backup and try to restore on the new machine ... i receive
this message
i know its probably something trivial ... but can anyone give me a
hand with this ?
TITLE: Microsoft SQL Server Management Studio
Restore failed for Server 'NAMECLapps\ins1'.
(Microsoft.SqlServer.Smo)
For help, click:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00. 2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo. ExceptionTemplates.FailedOperationExceptionText&Ev tID=Restore+Server&LinkId=20476[/url]
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: Cannot use file 'C:\test\northwnd.mdf'
for clustered server. Only formatted files on which the cluster
resource of the server has a dependency can be used.
(Microsoft.SqlServer.Smo)
For help, click: [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00. 2047.00&LinkId=20476[/url]
You can't put a user db on the local drive of a cluster. It must be one of
the drives in the cluster resource group.
Andrew J. Kelly SQL MVP
<glombica@.hotmail.com> wrote in message
news:1185286074.533480.16750@.m3g2000hsh.googlegrou ps.com...
> hey guys
> just to do a test run i wanted to migrate the northwind database from
> 2000 to 2005
> when i do a backup and try to restore on the new machine ... i receive
> this message
> i know its probably something trivial ... but can anyone give me a
> hand with this ?
>
> TITLE: Microsoft SQL Server Management Studio
> --
> Restore failed for Server 'NAMECLapps\ins1'.
> (Microsoft.SqlServer.Smo)
> For help, click:
> [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00. 2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo. ExceptionTemplates.FailedOperationExceptionText&Ev tID=Restore+Server&LinkId=20476[/url]
> --
> ADDITIONAL INFORMATION:
> System.Data.SqlClient.SqlError: Cannot use file 'C:\test\northwnd.mdf'
> for clustered server. Only formatted files on which the cluster
> resource of the server has a dependency can be used.
> (Microsoft.SqlServer.Smo)
> For help, click:
> [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00. 2047.00&LinkId=20476[/url]
>
just to do a test run i wanted to migrate the northwind database from
2000 to 2005
when i do a backup and try to restore on the new machine ... i receive
this message
i know its probably something trivial ... but can anyone give me a
hand with this ?
TITLE: Microsoft SQL Server Management Studio
Restore failed for Server 'NAMECLapps\ins1'.
(Microsoft.SqlServer.Smo)
For help, click:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00. 2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo. ExceptionTemplates.FailedOperationExceptionText&Ev tID=Restore+Server&LinkId=20476[/url]
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: Cannot use file 'C:\test\northwnd.mdf'
for clustered server. Only formatted files on which the cluster
resource of the server has a dependency can be used.
(Microsoft.SqlServer.Smo)
For help, click: [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00. 2047.00&LinkId=20476[/url]
You can't put a user db on the local drive of a cluster. It must be one of
the drives in the cluster resource group.
Andrew J. Kelly SQL MVP
<glombica@.hotmail.com> wrote in message
news:1185286074.533480.16750@.m3g2000hsh.googlegrou ps.com...
> hey guys
> just to do a test run i wanted to migrate the northwind database from
> 2000 to 2005
> when i do a backup and try to restore on the new machine ... i receive
> this message
> i know its probably something trivial ... but can anyone give me a
> hand with this ?
>
> TITLE: Microsoft SQL Server Management Studio
> --
> Restore failed for Server 'NAMECLapps\ins1'.
> (Microsoft.SqlServer.Smo)
> For help, click:
> [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00. 2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo. ExceptionTemplates.FailedOperationExceptionText&Ev tID=Restore+Server&LinkId=20476[/url]
> --
> ADDITIONAL INFORMATION:
> System.Data.SqlClient.SqlError: Cannot use file 'C:\test\northwnd.mdf'
> for clustered server. Only formatted files on which the cluster
> resource of the server has a dependency can be used.
> (Microsoft.SqlServer.Smo)
> For help, click:
> [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00. 2047.00&LinkId=20476[/url]
>
migrating to 2005 troubles :(
hey guys
just to do a test run i wanted to migrate the northwind database from
2000 to 2005
when i do a backup and try to restore on the new machine ... i receive
this message
i know its probably something trivial ... but can anyone give me a
hand with this ?
TITLE: Microsoft SQL Server Management Studio
--
Restore failed for Server 'NAMECLapps\ins1'.
(Microsoft.SqlServer.Smo)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
--
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: Cannot use file 'C:\test\northwnd.mdf'
for clustered server. Only formatted files on which the cluster
resource of the server has a dependency can be used.
(Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476You can't put a user db on the local drive of a cluster. It must be one of
the drives in the cluster resource group.
--
Andrew J. Kelly SQL MVP
<glombica@.hotmail.com> wrote in message
news:1185286074.533480.16750@.m3g2000hsh.googlegroups.com...
> hey guys
> just to do a test run i wanted to migrate the northwind database from
> 2000 to 2005
> when i do a backup and try to restore on the new machine ... i receive
> this message
> i know its probably something trivial ... but can anyone give me a
> hand with this ?
>
> TITLE: Microsoft SQL Server Management Studio
> --
> Restore failed for Server 'NAMECLapps\ins1'.
> (Microsoft.SqlServer.Smo)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
> --
> ADDITIONAL INFORMATION:
> System.Data.SqlClient.SqlError: Cannot use file 'C:\test\northwnd.mdf'
> for clustered server. Only formatted files on which the cluster
> resource of the server has a dependency can be used.
> (Microsoft.SqlServer.Smo)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476
>
just to do a test run i wanted to migrate the northwind database from
2000 to 2005
when i do a backup and try to restore on the new machine ... i receive
this message
i know its probably something trivial ... but can anyone give me a
hand with this ?
TITLE: Microsoft SQL Server Management Studio
--
Restore failed for Server 'NAMECLapps\ins1'.
(Microsoft.SqlServer.Smo)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
--
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: Cannot use file 'C:\test\northwnd.mdf'
for clustered server. Only formatted files on which the cluster
resource of the server has a dependency can be used.
(Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476You can't put a user db on the local drive of a cluster. It must be one of
the drives in the cluster resource group.
--
Andrew J. Kelly SQL MVP
<glombica@.hotmail.com> wrote in message
news:1185286074.533480.16750@.m3g2000hsh.googlegroups.com...
> hey guys
> just to do a test run i wanted to migrate the northwind database from
> 2000 to 2005
> when i do a backup and try to restore on the new machine ... i receive
> this message
> i know its probably something trivial ... but can anyone give me a
> hand with this ?
>
> TITLE: Microsoft SQL Server Management Studio
> --
> Restore failed for Server 'NAMECLapps\ins1'.
> (Microsoft.SqlServer.Smo)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
> --
> ADDITIONAL INFORMATION:
> System.Data.SqlClient.SqlError: Cannot use file 'C:\test\northwnd.mdf'
> for clustered server. Only formatted files on which the cluster
> resource of the server has a dependency can be used.
> (Microsoft.SqlServer.Smo)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476
>
migrating to 2005 troubles :(
hey guys
just to do a test run i wanted to migrate the northwind database from
2000 to 2005
when i do a backup and try to restore on the new machine ... i receive
this message
i know its probably something trivial ... but can anyone give me a
hand with this ?
TITLE: Microsoft SQL Server Management Studio
--
Restore failed for Server 'NAMECLapps\ins1'.
(Microsoft.SqlServer.Smo)
For help, click:
http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: Cannot use file 'C:\test\northwnd.mdf'
for clustered server. Only formatted files on which the cluster
resource of the server has a dependency can be used.
(Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?Prod...00&LinkId=20476You can't put a user db on the local drive of a cluster. It must be one of
the drives in the cluster resource group.
Andrew J. Kelly SQL MVP
<glombica@.hotmail.com> wrote in message
news:1185286074.533480.16750@.m3g2000hsh.googlegroups.com...
> hey guys
> just to do a test run i wanted to migrate the northwind database from
> 2000 to 2005
> when i do a backup and try to restore on the new machine ... i receive
> this message
> i know its probably something trivial ... but can anyone give me a
> hand with this ?
>
> TITLE: Microsoft SQL Server Management Studio
> --
> Restore failed for Server 'NAMECLapps\ins1'.
> (Microsoft.SqlServer.Smo)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
> --
> ADDITIONAL INFORMATION:
> System.Data.SqlClient.SqlError: Cannot use file 'C:\test\northwnd.mdf'
> for clustered server. Only formatted files on which the cluster
> resource of the server has a dependency can be used.
> (Microsoft.SqlServer.Smo)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...
0&LinkId=20476
>
just to do a test run i wanted to migrate the northwind database from
2000 to 2005
when i do a backup and try to restore on the new machine ... i receive
this message
i know its probably something trivial ... but can anyone give me a
hand with this ?
TITLE: Microsoft SQL Server Management Studio
--
Restore failed for Server 'NAMECLapps\ins1'.
(Microsoft.SqlServer.Smo)
For help, click:
http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: Cannot use file 'C:\test\northwnd.mdf'
for clustered server. Only formatted files on which the cluster
resource of the server has a dependency can be used.
(Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?Prod...00&LinkId=20476You can't put a user db on the local drive of a cluster. It must be one of
the drives in the cluster resource group.
Andrew J. Kelly SQL MVP
<glombica@.hotmail.com> wrote in message
news:1185286074.533480.16750@.m3g2000hsh.googlegroups.com...
> hey guys
> just to do a test run i wanted to migrate the northwind database from
> 2000 to 2005
> when i do a backup and try to restore on the new machine ... i receive
> this message
> i know its probably something trivial ... but can anyone give me a
> hand with this ?
>
> TITLE: Microsoft SQL Server Management Studio
> --
> Restore failed for Server 'NAMECLapps\ins1'.
> (Microsoft.SqlServer.Smo)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
> --
> ADDITIONAL INFORMATION:
> System.Data.SqlClient.SqlError: Cannot use file 'C:\test\northwnd.mdf'
> for clustered server. Only formatted files on which the cluster
> resource of the server has a dependency can be used.
> (Microsoft.SqlServer.Smo)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...
0&LinkId=20476
>
Subscribe to:
Posts (Atom)