Viewing 15 posts - 1 through 15 (of 102 total)
Rune, I agree with you. I looked up the command and this would see the way to go.
ALTER DATABASE ENCRYPTION KEY REGENERATE WITH ALGORITHM = { AES_128 | AES_192 |...
June 3, 2022 at 7:23 pm
Steve, per the reference "Returns the Showplan in XML format for the batch specified by the plan handle. The plan specified by the plan handle can either be cached or...
March 9, 2022 at 8:32 pm
It is unfortunate that the problem text in the email for which the final answer is correct and the text of the problem on the answer page, and for which...
October 15, 2021 at 7:23 pm
sagar, for those of us who make minimal use of SSIS and house SSIS packages in MSDB or in an SSIS catalog then how do we find the value for...
September 27, 2021 at 3:15 pm
Good point Larry. If I add an ELSE to Larry's query and try to define @NumOfHolidys with a different data type I get an error that the variable name has...
August 13, 2021 at 3:25 pm
I always use fixed size file growth for database and log files. This is a nightly restore over an existing database so some of your suggestions will not apply, but...
September 18, 2020 at 1:16 am
Alejandro, thank you for the reply. The database is in SIMPLE recovery mode with the backup coming from another server where the database is also in SIMPLE recovery mode. But...
July 24, 2020 at 6:29 pm
Update the developer modified the task to run sequentially instead of having the SSIS package launch the various modules in parallel and it has ran for the last couple days...
September 8, 2017 at 2:23 pm
I do not know if it is wise or not but we run several different SQL Server installations using the same domain username for the SQL Service account and the...
August 29, 2017 at 2:14 pm
No, remember the job sometimes worked initially and then stated to fail as often as not. The job history only has three days in it as of today so I...
August 28, 2017 at 1:55 pm
I will have to inquire on executing the SP as the SQL Server user. All of the SP execute fine when executed as the Application user.
August 28, 2017 at 11:13 am
The job runs at the SQL Agent user which is the same as the database server user and the user is a System Administrator on the box.
- -
The...
August 28, 2017 at 10:52 am
SSCertifiable, I have asked the developer about your concerns on some of the routines running twice.
- -
Here is the developer response >>
August 25, 2017 at 1:05 pm
Here is the description of the diagram boxes:
There is a procedure under everytask as shown in diagram below.
August 25, 2017 at 11:26 am
Here is the SSIS package functionality as provided by the developer. I have asked for a brief description of what each box does.
August 25, 2017 at 10:45 am
Viewing 15 posts - 1 through 15 (of 102 total)