Forum Replies Created

Viewing 12 posts - 1 through 13 (of 13 total)

  • Reply To: ssms crashes when editing .sql script

    I have this problem regardless of how many tabs I have open and I am currently running the latest release 17.9.1.

  • RE: Log file doesn't clear after backup

    I'm now seeing that mirroring is suspended on these databases and that may be the root of my problem. I am checking with the software vendor to determine next steps....

  • RE: CmdExec to delete files not working

    It's running as a SQL Agent job and the service account running SQL Agent has permissions to that folder. It can create the files.

  • RE: spn won't register on restart

    I set the sql services to start automatically with delay and that seems to have resolved the issue.

  • RE: spn won't register on restart

    Folks, ReadServicePrincipalName and WriteServicePrincipalName permissions have already been assigned. I have several servers using the same domain svc account and they have no issue registering the SPN.

    Specifically, the SPN...

  • RE: spn won't register on restart

    I've already worked with my network admins to get these permissions assigned. Besides, I don't think the SPN would register when I restart the service if those permissions weren't there.

  • RE: SSMS breakpoint won't add

    RAM was checked and I was only using about half.

  • RE: SSMS breakpoint won't add

    I should add that I was running the debugger and setting breakpoints successfully and stepping through code and hour before this problem started. I received no error messages or indication...

  • RE: SSMS breakpoint won't add

    What references are available to determine if the debugger is properly configured?

  • RE: SQLServerAgent Error 22022

    The job is run from a schedule and the user is Schedule XXX but that number doesn't correspond to any schedule in dbo.sysjobschedules.

  • RE: CDC State is not well formed

    There is a CommandTimeout property of the CDC Get Processing Range task of the SSIS package that was increased. In researching the error, it was discovered that the run of...

  • RE: Run SSIS package from stored proc

    You can create a SQL Agent Job that runs the SSIS package and start that job using sp_start_job. There is no way to pass a value to SQL Agent job,...

Viewing 12 posts - 1 through 13 (of 13 total)