Viewing 15 posts - 2,491 through 2,505 (of 5,109 total)
Is that output table a single column...? I'd suggest it would be better to have each item as a column. Why do you want to convert it into Delimited Tab...
November 30, 2017 at 8:07 am
I assume you mean that you want the recipient to be dynamic based on something? This is achievable. with SSRS.
Don't quote me on it, but I believe it's...
November 30, 2017 at 1:52 am
Going to be honest, but the sea of images and a mad morning at work, have made me completely loss track what your aim is now. We've identified that the...
November 29, 2017 at 5:47 am
Indeed. You need to know what is right for you. For example, like I said, mine is set to 7 days. The reason being that we run a LOT of...
November 29, 2017 at 2:30 am
November 29, 2017 at 1:55 am
This is development environment. in PROD, situation is much differente. Let...
November 28, 2017 at 9:50 am
As Anthony said, I treat SSISDB just like any other user database. it is backed up on the same schedules, by the same scripts etc.
November 28, 2017 at 9:41 am
Hmm, I'll create a container on the desktop and have a go myself quickly. I'll let you know how it goes.
edit: Sorry, not in a position to give...
November 28, 2017 at 7:50 am
It's your log file that is large. That screen shot says that it has a initial size of 8.7GB~. Why is it so large when you have a Simple Recovery...
November 28, 2017 at 7:41 am
I'm pretty surprised that your SSISDB is 10Gb in size then. If we have an look at my SSISDB database, it is 4.5GB~ in size, of which 900MB~ is available...
November 28, 2017 at 7:22 am
What have you set the "Operations log Retention Period" to?...
November 28, 2017 at 5:56 am
river1 - Tuesday, November 28, 2017 5:36 AMThank you for your reply. Where can I check those?
Integration Services Catalogs -> SSISDB ->...
November 28, 2017 at 5:40 am
What have you set the "Operations log Retention Period" to? Also what about the "Maximum Number of Version per Project" and "Periodically Remove Old Versions" Settings?
November 28, 2017 at 4:36 am
Changing the Collation of the server, post install, is quite a different task. It's much easier to do at install. Have a look here for post installation: https://docs.microsoft.com/en-us/sql/relational-databases/collations/set-or-change-the-server-collation
November 27, 2017 at 1:04 pm
Viewing 15 posts - 2,491 through 2,505 (of 5,109 total)