SimAda00 Posted January 10, 2007 Posted January 10, 2007 Ok, having errors when upgrading database structure through scripts. Currently occurs on script for 3.61.259 to 3.61.260. Error:Duplicate column names are not allowed in result sets obtained through OPENQUERY and OPENROWSET. The column name "code" is a duplicate. Duplicate column names are not allowed in result sets obtained through OPENQUERY and OPENROWSET. The column name "code" is a duplicate. Is that normal practice or something that i need to sort?
apeo Posted January 11, 2007 Posted January 11, 2007 At a guess its SIMS... as it looks like SIMS but if it threw up the error chances are it would roll back the database to the state it was in before you installed the script. There maybe something wrong with the script itself but not really sure. I would contact capita about it or post up on the capita support forum. This happening during Dec update?
SimAda00 Posted January 11, 2007 Author Posted January 11, 2007 Sorry, i figured it out. Someone had installed sims on a sql 2005 server. Have now moved it to sql 2000 and no problems
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now