Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Script view dependices for a Stored proc

    You can use this query to find all the tables used in a stored procedure.

    ;WITH stored_procedures AS (

    SELECT

    o.name AS proc_name, oo.name AS table_name,

    ROW_NUMBER() OVER(partition by o.name,oo.name ORDER BY o.name,oo.name)...

  • RE: String length?

    So it will execute this forever? But obviously it won't execute forever, correct? Is there a time limit within SQL Server after which long running queries will be killed? How...

Viewing 2 posts - 1 through 2 (of 2 total)