Forum Replies Created

Viewing 15 posts - 3,076 through 3,090 (of 4,477 total)

  • RE: Cannot remote connect report server outside virtual Machine using ssms 2016

    gissah - Thursday, September 14, 2017 7:24 AM

    I just installed a new SSRS 2016 on a windows server 2012 r2 vm. I...

    September 14, 2017 at 8:09 am

    #1959440

  • RE: Extended Events Parity with Trace

    Stewart "Arturius" Campbell - Thursday, September 14, 2017 6:48 AM

    Interesting question, thanks Steve
    Thought this came out with 2014, so learned something interesting...

    If...

    September 14, 2017 at 7:42 am

    #1959425

  • RE: Can the following NT SERVICE accounts be ignored for password rotational purposes

    caz100 - Thursday, September 14, 2017 2:49 AM

    Hi 

    Can the following accounts  be ignored for password rotation;

    September 14, 2017 at 6:35 am

    #1959406

  • RE: EXCEPT in a trigger

    Joie Andrew - Sunday, September 10, 2017 8:27 AM

    My mistake! Weird that the Microsoft documentation lists that EXCEPT starts with SQL Server...

    September 13, 2017 at 4:57 pm

    #1959352

  • RE: anybody know what this view is? sys.spt_sproc_columns_odbc_view

    krypto69 - Wednesday, September 13, 2017 8:01 AM

    HI,

    I am looking into a CX packet wait issue - so I ran sp_blitz.

    The...

    September 13, 2017 at 4:41 pm

    #1959349

  • RE: Can't connect to SQL Server via IP

    crvasquez1984 - Wednesday, September 13, 2017 2:14 PM

    Unfortunately they are not setting it up as a Domain.

    If it's not going to be...

    September 13, 2017 at 2:53 pm

    #1959341

  • RE: PL_SQL compares with T_SQL

    Chris Harshman - Wednesday, September 13, 2017 10:59 AM

    If I remember correctly, in Oracle everything is a cursor behind the scenes, even...

    September 13, 2017 at 11:13 am

    #1959297

  • RE: Determining Memory Pressure

    Arsh - Wednesday, September 13, 2017 5:33 AM

    Dear Experts,
    I'm trying to figure out if my SQL server is facing any memory pressure...

    September 13, 2017 at 7:12 am

    #1959236

  • RE: Maintenance Plan Failed/Error

    Looks like with your error of:
    Code: 0xC0024104     Source: Execute SQL Server Agent Job Task     
    Description: The Execute method on the task returned error code 0x80004003 (Object...

    September 12, 2017 at 5:27 pm

    #1959196

  • RE: This may be due to a connection failure, timeout or low disk condition within the database

    I would guess it's not that job. From what it looks like to me, It's the last step of a job that is automatically created when you install...

    September 12, 2017 at 5:19 pm

    #1959195

  • RE: PL_SQL compares with T_SQL

    sqlfriends - Tuesday, September 12, 2017 3:01 PM

    Thanks Sue, that makes a lot of sense.
    The stored procedure I saw in the database...

    September 12, 2017 at 3:11 pm

    #1959190

  • RE: PL_SQL compares with T_SQL

    Correct, the PL does stand for Procedural Language.
    Oracle has SQL and then extend that with PL/SQL
    SQL Server has SQL and then extends that with T-SQL.
    Both...

    September 12, 2017 at 2:46 pm

    #1959185

  • RE: How to maintain ReportServer and ReportServerTempDB

    kristoledo - Tuesday, September 12, 2017 7:48 AM

    Hi,

    We notice that our report server and report server tempdb databse is growing. I would...

    September 12, 2017 at 12:00 pm

    #1959163

  • RE: DBCC CHECKDB succeeds, Backup succeeds, but RESTORE/VERIFY fails

    wturner 57240 - Tuesday, September 12, 2017 8:38 AM

    This is the complete error message as far as I can find.  SQL error...

    September 12, 2017 at 11:51 am

    #1959162

  • RE: comma separated values

    Try something along the lines of this:
    SELECT DISTINCT ID ,
            STUFF(( SELECT    ',' + Commodity
                    FROM YourTable AS C2
                    WHERE C2.ID = C1.ID
                    ORDER...

    September 12, 2017 at 11:18 am

    #1959159

    • Viewing 15 posts - 3,076 through 3,090 (of 4,477 total)