Skip to content

SQL Server stored procedure create code and routine body is invalid. #667

@elky84

Description

@elky84

Steps to reproduce this issue

SQL Server stored procedure create code and routine body is invalid.
always.

Current behavior

i go to procedure tab.
but i can't show all stored procedure content.
i don't know standard for stored procedure content.

image

image

Expected behavior

show all stored procedure content.

Possible solution

EXEC sp_helptext 'dbo.P_Guild_Present_Point_Add';

image

to above text to show all procedure code.

Environment

  • HeidiSQL version:
    10.1.0.5581 64bit

  • Database system and version:
    Microsoft SQL Server 2016 (RTM-GDR) (KB4019088) - 13.0.1742.0 (X64)
    Jul 5 2017 23:41:17
    Copyright (c) Microsoft Corporation
    Developer Edition (64-bit) on Windows 10 Enterprise 6.3 (Build 17763: )

  • Operating system:
    Windows 10 Enterprise 64bit

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugDefective behaviour in HeidiSQLconfirmedIssue verified by project membernettype-mssqlSQL Server specific issue

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions