Comments
Sort by recent activity
That doesn't sound right.
What happens if you try to commit the object that's already been added to TFS? Does the blue indicator go away, or does it throw an error? / comments
That doesn't sound right.
What happens if you try to commit the object that's already been added to TFS? Does the blue indicator go away, or does it throw an error?
Thanks for your post.
Are you using the shared or the dedicated development model with SQL Source Control?
If you're using the shared model then there isn't really a concept of 'get latest' as the database will always be up-to-date.
If you're using the dedicated model, then if the files are committed to the same TFS repository, then a 'get latest' should pull them down. / comments
Thanks for your post.
Are you using the shared or the dedicated development model with SQL Source Control?
If you're using the shared model then there isn't really a concept of 'get latest' as the ...
Sorry for the delay, I've been on holiday.
I can confirm that if you supply ? as a value for a parameter, the 'Format SQL' causes SSMS to crash.
I've logged bug SP-4489 for our developers to take a look at.
Thanks for finding the cause of the problem for us. / comments
Sorry for the delay, I've been on holiday.
I can confirm that if you supply ? as a value for a parameter, the 'Format SQL' causes SSMS to crash.
I've logged bug SP-4489 for our developers to take a...
Thanks for your post. I'm not sure why it keeps crashing SSMS for you. Did it give you the chance to submit a bug report when it crashed? If it does, can you send it in with your email address?
Could you also take a look at the log file? This can be found in SQL Prompt 5 > Help > Show log
With regards to the problem with the toolbar, I think this is a known issue. I'll just confirm that and let you know if/when it's going to be fixed. / comments
Thanks for your post. I'm not sure why it keeps crashing SSMS for you. Did it give you the chance to submit a bug report when it crashed? If it does, can you send it in with your email address?
Cou...
Thanks for your post.
Writing a custom migration script sounds like it should be what you need, so I'm glad you found the documentation.
With regards to the first question, SQL Source Control doesn't create the database for you, so you could create the user when you create the new database that you deploy to. If that's not ideal you could set up a migration script to create the new user when you deploy to revision 0. A new blank database will be assumed to be revision 0. / comments
Thanks for your post.
Writing a custom migration script sounds like it should be what you need, so I'm glad you found the documentation.
With regards to the first question, SQL Source Control doesn...
I'm not sure. Could you post the DDL for the type and I'll see if I can reproduce it here? / comments
I'm not sure. Could you post the DDL for the type and I'll see if I can reproduce it here?
Sorry for the delay, this is definitely a bug.
I've logged it under the bug tracking code SOC-4068. I'll let you know as soon as I find out when it's expected to be fixed.
Sorry for the inconvenience. / comments
Sorry for the delay, this is definitely a bug.
I've logged it under the bug tracking code SOC-4068. I'll let you know as soon as I find out when it's expected to be fixed.
Sorry for the inconvenience.
I might have misunderstood, but if you generate data for a encrypted column, then as long as the account that you use to generate the data has access to the key and certificate then the newly inserted data would be encrypted.
However, I haven't really played around with encrypted columns, so I don't know that this is definitely correct.
If you manually insert a row to you encrypted column, is it automatically encrypted, or does it only encrypt if you insert in a certain way? / comments
I might have misunderstood, but if you generate data for a encrypted column, then as long as the account that you use to generate the data has access to the key and certificate then the newly inser...
Sorry for the delay.
You're right then; I think this could only be done through a custom generator.
You might be able to do it with a SQL Statement generator pulling the unencrypted data from another table and then inserting it thought the sp, but I haven't ever tried it myself. / comments
Sorry for the delay.
You're right then; I think this could only be done through a custom generator.
You might be able to do it with a SQL Statement generator pulling the unencrypted data from anoth...
Thanks for you post.
I haven't been able to reproduce this myself using SSMS 2008 R2. Does this only happen with databases that you have linked to source control, or does it happen with other databases too? As far as I know we don't change the behaviour of the object explorer at apart from adding the blobs when the object changes.
When a new object is added, SSMS normally puts it at the bottom if the list until you refresh, but an altered object should stay where it is.
What kind of modification are you performing? Would you be able to post some steps that reproduce it on you system? Can you also send me the exact version of SSMS you're using? / comments
Thanks for you post.
I haven't been able to reproduce this myself using SSMS 2008 R2. Does this only happen with databases that you have linked to source control, or does it happen with other datab...