Forum Replies Created

Viewing 15 posts - 2,026 through 2,040 (of 4,477 total)

  • RE: What to do IN RECOVEY and lock database in the same time does not allow to be ONLINE

    luismarinaray - Friday, April 20, 2018 2:15 PM

    7    0    1900-01-01 00:00:00.000    background    DB STARTUP    NULL    NULL    NULL    NULL    1    1    NULL    0    SLEEP_DBSTARTUP    88    SLEEP_DBSTARTUP        0    1    0    NULL    0    0
        46    81051588    1    0x0000000006012988    558    124    2935    4096    us_english    mdy    7    0    0    0    0    0    0    0    0    2    -1    0    0    0  
      1    0    0    1    NULL    NULL

    14    0    1900-01-01 00:00:00.000    background    DB STARTUP    NULL    NULL    NULL    NULL    0    1    NULL    -3    LCK_M_S    81045798    LCK_M_S    KEY: 5:196608 (2d188ef96974)    0    1    0    NULL    8    932043145    452    81048034    0    0x0000000006008BC8    21914
        1933    586856    4096    us_english    mdy    7    0    0    0    0    0    0    0    0    2    -1    0    0    0    1    0    0    1    NULL  
      NULL

    It appears like a lock, and I'm thinking that...

  • RE: PowerShell Sql job

    vincenzo_capelli - Friday, April 20, 2018 2:06 PM

    Hi,
    I 'm working to launch with a Sql Agent Job a powershell script. (the script is...

  • RE: Replicating NonClustered Indexes

    Del Lee - Friday, April 20, 2018 1:38 PM

    I am changing by selecting all articles.

    Try individual article and see if that makes...

  • RE: How to stop execution the report if there is no parameter values inSSRS 2012

    asita - Tuesday, April 10, 2018 6:43 AM

    I have SSRS report it has Two parameters string parameters (text boxes) 1.SearchByFirstName, 2.SearchByLastName

    how to...

  • RE: Replicating NonClustered Indexes

    Del Lee - Friday, April 20, 2018 1:00 PM

    Still trying to get this to work.  Rather than trying to change the setting...

  • RE: How to show a percentage with out the decimal

    itmasterw 60042 - Friday, April 20, 2018 11:39 AM

    Hi 
    I have this 
    OP_Percentage * 100 as 'OP %'

    April 20, 2018 at 12:42 pm

    #1987739

  • RE: SQL Agent not automatically restarting on a server with two instances.

    After verifying all the settings, I've seen this happen at times and I think it's been due to SQL Agent trying to start up before SQL Server...

  • RE: VB Script Task - Running

    ringovski - Monday, April 16, 2018 7:38 PM

    Hi All,
    I am new to VB so not sure what the issue is. I am...

  • RE: Ssrs folder path

    zest.trainee067 - Thursday, April 19, 2018 1:34 AM

    How can I get physical path of ssrs folder?

    Do you mean the folders you see...

  • RE: SSRS Stuck on Loading Page

    John-271860 - Thursday, April 19, 2018 9:13 AM

    The report server db is up and running and responsive.  I can see subscription reports...

  • RE: One or the other parameter to consider

    asita - Tuesday, April 17, 2018 8:45 PM

    Hello Good Morning,

    I Have a report in ssrs 2012, I use Visual studio data tools...

  • RE: Could not load file or assembly Microsoft.SqlServer.Smo, Version=9.0.242.0

    doodlingdba - Tuesday, April 17, 2018 5:36 AM

    Hi all
    A lot happened on my machine at work last week - I installed Visual...

  • RE: Sql Loader - oracle

    gopi_annain - Tuesday, April 17, 2018 9:08 PM

    My table column type is clob. Field value contain double quotes

    id,text_clob,date1

    1,"\"data1\",0,1,1,1,\"data2\"","2018-03-03 09:08:45"

    can you kindly...

  • RE: SQL text cannot be represented in the grid pane and diagram pane - View Creation

    daleyvinod - Wednesday, April 18, 2018 2:23 AM

    Dear All,

    I have a query which brings the results of Financial Account Statement. I...

  • RE: SQL Server services and domain accounts / permissions

    hurricaneDBA - Wednesday, April 18, 2018 1:07 AM

    Hi Sue
    Yeah apparently in our windows build there is a group which is called...

Viewing 15 posts - 2,026 through 2,040 (of 4,477 total)