Forum Replies Created

Viewing 15 posts - 1 through 15 (of 83 total)

  • Reply To: Missing 'sys.sp_MSIsContainedAGSession' causing failure in CU13 update script

    Posting this in case it ends up helping someone else.

    Client requested in-place upgrade of SQL 2012 to 2019.  Upgrade ran flawlessly.  Ran CU24 update, update had no problems until the...

  • RE: Issue with network permissions to Sql Service AD Account

    Have you checked the NTFS permissions (not just the share permissions) for the folder you want to check?

    Mark

  • RE: Runaway Job Management

    Lawrence-136504 (3/18/2010)


    Yes. I was manually starting this job so there was no schedule.

    I created a schedule that runs every 1 minute. This job has one step that has WAITFOR DELAY...

  • RE: Runaway Job Management

    Lawrence-136504 (3/18/2010)


    I re-copied the logic and then pasted it into ssms (query window) and removed some hidden characters and I'm getting below error now.

    EXEC [master].dbo.xp_sqlagent_enum_jobs 1, 'DomainName\lawrence', 'B508F33F-8C69-42B9-9635-4CA66C05548D'

    Msg 241, Level...

  • RE: Runaway Job Management

    Lawrence-136504 (3/18/2010)


    Which versions have you tested this logic on? I'm getting below error.

    Msg 8114, Level 16, State 1, Procedure xp_sqlagent_enum_jobs, Line 1

    Error converting data type nvarchar to int.

    Lawrence:

    I have this...

  • RE: Combine Datetime

    Date/time calculations can be a pain, especially if the components are stored as INT's, VARCHAR, etc. The below code will take (presumably an INT representation of time), CAST it...

  • RE: Query Help

    mbrady, I am a visual learner 😛

    Could you post a quick CREATE/INSERT script with some dummy data and the results you expect to see? Most likely the issue is...

  • RE: Trapping for Foreign Key Constraint Errors

    meichner (10/9/2009)


    Option #1 - Question

    The problem with this option is that everytime a new table is created that depends on the Customer table, I would need to change this stored...

  • RE: Stored Procedure to Clone a Table Database Object

    I should remark that I did this on SQL 2008 EE. SPARSE columns types are new in that version...try comenting out that column or running a profiler session on...

  • RE: Query Help

    Thanks, Jeff - good catch. Depending on your specific requirements, you can also look into using the CAST function on the dividend to get the specificity needed (e.g. NUMERIC(19,5),...

  • RE: Stored Procedure to Clone a Table Database Object

    Jeff Moden (10/8/2009)


    It is a nice hint. I wonder if Profiler will actually pick it up.

    Yes sir, it does 😀

    Here is what the SSMS UI uses to generate the...

  • RE: Trapping for Foreign Key Constraint Errors

    mtassin (10/8/2009)


    Trust me when I say this.

    Yes, trust him ^^. Usually if there's any kind of purge occuring in a system (an actual DELETE, especially for customer data) I...

  • RE: How to configure sql mail

    Here's the (anonymized) script I use to set up Database Mail on all new SQL installations. Please change the variables to ones appropriate for your environment.

    MJM

    --******************************************************************************************

    --Purpose : The purpose...

  • RE: Query Help

    Try this...the two additional columns I added are set apart with a carriage return before and after.

    SELECT [CWS Division],

    [Zone],

    ...

  • RE: Restore Database - Is Fully Restored or Not

    That depends on your definition of "Restored Completely". If you can access the database (period), then your database is recovered. Could you give us some details on the...

Viewing 15 posts - 1 through 15 (of 83 total)