HomeApplianceSQL Server Parallel Data Warehouse (PDW) Appliance Update 3 (AU3)

Comments

SQL Server Parallel Data Warehouse (PDW) Appliance Update 3 (AU3) — 13 Comments

  1. Hi James,
    Do you know when I can find a doc. about limitation/features not supported for stored procedures? Like cursors and so on….
    Thanks

  2. Hi James,

    Do you know where can i find my stored procedures on Nexus Chameleon?

    I just can see Databases, Tables, Views and Security but nothing about SP’s.

    Thanks..
    Ahmet

  3. —— it’s ok ;

    SELECT *
    FROM dw_production.sys.all_objects
    WHERE
    is_ms_shipped = 0 AND type = ‘P’

    ——– you can find prodecure name here and search it like ;

    SELECT text
    FROM
    dbo.syscomments c
    JOIN sys.procedures p ON p.object_id = c.id
    WHERE
    p.name = ‘procedure_name’
    ORDER BY number, colid

Leave a Reply

Your email address will not be published. Required fields are marked *

HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>