Forum Replies Created

Viewing 15 posts - 46 through 60 (of 312 total)

  • Reply To: sp_MSforeachDB

    Yep, I was missing an END. That fixed the issue. Thanks!

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • Reply To: Run SQL agent job if the server is primary

    Not trying to be lazy but one of the server has 128 jobs and some of the jobs have multiple steps, some have SSIS packages. Am I to go through...

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • Reply To: Having issues with Excel source in SSIS

    Tried string, Unicode string but nothing. Still see NULL value

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • Reply To: Unable to send email

    It's working now.

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • RE: syspolicy_purge_history failing on step 3

    John Mitchell-245523 - Monday, March 11, 2019 7:37 AM

    Check whether the SQLPS Powershell module is located in the folder specified in the...

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • RE: Conversion failed when converting from a character string to uniqueidentifier.

    Some of them.

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • RE: Log file and data file growth

    Do you take log backups? The reason why I am asking is because if you do then you just have to find out the pattern. I mean look at the log backups...

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • RE: The target principal name is incorrect. Cannot generate SSPI context.

    Its fixed.
    We don't use our regular account to log onto instances. Instead we use admusername. So what I did was I logged into my laptop using adm account, changed...

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • RE: The requested OLE DB provider Microsoft.ACE.OLEDB.16.0 is not registered. If the 32-bit driver is not installed, run the package in 64-bit mode.

    Thom A - Friday, December 21, 2018 9:12 AM

    Seeing as you get the error in both 32 and 64 mode, this suggest...

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • RE: The requested OLE DB provider Microsoft.ACE.OLEDB.16.0 is not registered. If the 32-bit driver is not installed, run the package in 64-bit mode.

    Phil Parkin - Friday, December 21, 2018 9:06 AM

    Now I was asked to changed the source file 

    From what, to what?

    Sorry, source...

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • RE: If condition when running SSIS package on the secondary server which is part of AG

    I am using the listener name instead of the server name and it is working just fine. Tested the job by manually failing over so no issues so far.

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • RE: Migrating DBs to another server

    This is the script I am using which I found online, made some changes and it's working just fine.

    DECLARE @name VARCHAR(256) -- database name

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • RE: AG Failover alert

    RVSC48 - Tuesday, December 18, 2018 10:24 AM

    Just curious, does the test e-mail option located in the Sql Server Agent properties work? ...

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • RE: AG Failover alert

    Emails are being sent fine. I checked the DB mail log and I don't see any issue.

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • RE: AG Failover alert

    still no email after I failed it over to the secondary. I did receive an email when I sent myself a test email so its not the SMTP server. There is something...

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

Viewing 15 posts - 46 through 60 (of 312 total)