StrataFrame Forum
Back
Login
Login
Home
»
StrataFrame Database Deployment Toolkit
»
Database Deployment Toolkit (How do I?)
»
Unique Index Problem
Unique Index Problem
Post Reply
Like
1
Unique Index Problem
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
fansanitis
fansanitis
posted 17 Years Ago
ANSWER
Topic Details
Share Topic
Group: Forum Members
Posts: 45,
Visits: 103
I have a number of unique indexes on my database. When I import it into a DDT project, all the indexes imported as non-unique. So I changed them all in DDT to be unique and then deployed the database. Everything worked fine except 1 index got deployed as non-unique. So I checked the DDT project and it IS marked as unique. So I unchecked and checked Unique just to make sure. I redeployed the database and the progress log said the index in question was successfully altered. So I went into the SQL Server Management Studio and the index is still non-unique. Checked the DDT project again and the index is flagged as UNIQUE. Any idea why this index won't deploy as unique?
Thanks!!
Reply
Like
1
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Threaded View
Threaded View
Unique Index Problem
fansanitis
-
17 Years Ago
This type of thing is hard to diagnose over a post. If you deploy to a...
Trent L. Taylor
-
17 Years Ago
Post Reply
Like
1
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search