Forum Replies Created

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

  • RE: expecting ID or quoted_ID. Help!

    Jeff Moden - Wednesday, October 11, 2017 11:02 PM

    Michael_O - Tuesday, October 10, 2017 9:32 AM

    October 12, 2017 at 10:54 am


  • RE: expecting ID or quoted_ID. Help!

    Thom A - Tuesday, October 10, 2017 9:01 AM

    You can reference the db name more than once in your query using ?....

  • RE: expecting ID or quoted_ID. Help!

    The query that got me the above resultset

    Declare @unuseddbs Table([last_read] NVARCHAR(255), [last_write] NVARCHAR(255) )
    INSERT INTO @unuseddbs
    EXECUTE master.sys.sp_MSforeachdb 'USE [?]; WITH agg AS

  • RE: expecting ID or quoted_ID. Help!

    Avi1 - Monday, October 9, 2017 8:51 AM

    If you want to get the data in as single resultset, then rather then using...

  • RE: expecting ID or quoted_ID. Help!

    Thom A - Monday, October 9, 2017 8:02 AM

    The syntax "USE @DatabaseName" isn't valid. You can't provide a variable as...

  • RE: XP_CMDSHELL access denied when accessing shared location

    Lowell - Monday, October 26, 2009 6:51 AM

    Ranga it doesn't matter which account YOU logged in with.when SQL server tries to access...


    sgmunson - Monday, February 13, 2017 2:05 PM

    Most everything I see in your post appears okay, except perhaps the UPDATE.   Seems more...

  • RE: Procedure Cache Hit Ratio

    Eirikur Eiriksson (10/22/2016)

    MVP_enthusiast (10/22/2016)

    Last night I just migrated one of my busiest databases from SQL 2008 to 2012. Max server memory allocated to SQL Server In 2008 was 50000 and...

  • RE: Procedure Cache Hit Ratio

    Jeff Moden (10/22/2016)

    Personally, I think that if you have a heavy (read that as "frequent") usage database and it takes more than 5-10 minutes for most everything to settle into...

  • RE: Database Mail

    kfewer (12/28/2009)

    Finally success! It turned out to be a missed configuration step: Setting the public profile as "Default". Thanks everyone for your help!

    Hello! what do you mean when you say...

  • RE: Conversion failed because the data value overflowed the data type used by the provider.

    Mladen Krstonosic (10/27/2008)

    Maybe will help to someone:

    here is what i did,

    select * from openquery

    (LINK_LINUX, 'SELECT id, inf_date_open, inf_date_clos, inf_prob_type_no,

    CAST(inf_prob_desc AS varchar(4000)) AS inf_prob_desc,


  • RE: Do not SELECT if in Table B

    I appreciate your response but I'm not really sure how you intended for me to use that. Can you make it a little clearer for me? I appreciate

  • RE: Availability Groups

    Beatrix Kiddo (3/3/2016)

    amickey84 (3/2/2016)

    I've been tasked with restoring a backup of a prod db to a shell db on another instance.

    Hi- I'm not really sure why you're referring to a...

  • RE: Scheduling Job Steps

    Orlando Colamatteo (2/16/2016)

    TheSQLGuru (2/16/2016)

    Just have a job step that starts the next job you want to run AFTER the completion of the first job. Easy-peasy-lemon-squeezy! 🙂

    sp_job_start is the sproc IIRC....

  • RE: Scheduling Job Steps

    Orlando Colamatteo (2/16/2016)

    Maybe semantics, but wasn't thinking of anything to incorporate in your existing code. I was proposing new code and a new step 2 in your job.

    Suggestion: make...

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