Viewing 15 posts - 1,156 through 1,170 (of 5,111 total)
In the 2008 R2 release they introduced SSIS project deployment model which uses SSISDB. Only the package deployment model is available in the 2008 release.
SSISDB was added in 2012,...
April 7, 2019 at 4:08 pm
April 7, 2019 at 12:03 pm
I don't want to store pass in plain text. I would like to check it strength in DB and then hash it as I wrote in the first post.
Why...
April 6, 2019 at 2:53 pm
Well, your collation has CI, which means Case Insensitive. CS means Case Sensitive. But do we really need to pretend that you aren't going to use this answer to store...
April 5, 2019 at 11:01 pm
It's latest topics, not posts. It does do what it says on the tin. 🙂
Steve has said that they will be changing "Most Active" but no change yet; that is...
April 5, 2019 at 6:24 pm
What you have here is an XY Problem; you think the problem is fixing the case sensitivity, but really the problem you need to fix is the design.
Your problem isn't...
April 5, 2019 at 5:41 pm
I've been getting mine through all of the changes. I got Monday's twice - you can have the extra one if you want 🙂 Sue
Thanks Sue, but that's...
April 5, 2019 at 5:22 pm
Thanks for the update Steve. It's good to see some things are being fixed quickly, and appreciate others take a little longer. Appreciate that sometimes it takes awhile to acknowledge...
April 5, 2019 at 4:03 pm
SSDT for Visual Studio 2017 15.9.0 added back the support for SQL Server 2012. Release notes
Ha! Pleased they did, honestly was stupid that Microsoft removed it.
Thanks for sharing.
April 5, 2019 at 12:27 pm
We are on 2008 going to end up on 2016 what exactly is SSISDB and how do I create it? Thanks
It's all covered in that link I posted above,...
April 5, 2019 at 12:18 pm
I assume your not upgrading to SQL Server 2008 (which is the forum you've posted in). If you are, you need to reconsider as 2008 is about to run out...
April 5, 2019 at 11:49 am
What have you tried so far? Have you had a look at the ALTER TABLE syntax? There are loads of examples in the documentation, why didn't your attempt work?
April 5, 2019 at 11:14 am
Cross post: https://www.sqlservercentral.com/forums/topic/adding-default-column-with-type-bit-and-default-value-as-y-2
Please don't post questions twice (especially when it's different versions of SQL Server). Please direct answers to the link above.
April 5, 2019 at 11:12 am
I assume you mean article, rather than (forum) posts? That's on the article. For example, this article has 2,109 (at the time of posting). It's on the right hand...
April 5, 2019 at 9:25 am
Title says it all here, but when quoting a post with line breaks in, the line breaks are lost. This actually can easily make the previous quote an unreablemess,...
April 4, 2019 at 3:15 pm
Viewing 15 posts - 1,156 through 1,170 (of 5,111 total)