Forum Replies Created

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

  • Reply To: sp_what

    In fact, it is sqlservercentral mangling the formatting.

    /*
    --Original inspiration: https://simplesqlserver.com/tag/sys-dm_exec_requests/

    /// On Blocks and SQL Statements:///
    Sometimes the most *recent* sql cmd does not reflect the source of the...
  • Reply To: sp_what

    There were numerous syntax errors as the there were hundreds of missing spaces. I slogged through and did a few search and replaces. After fixing that, I renamed some of...

  • Reply To: how to catch previous error message

    This returns:

    the actual error message
    --------------------------------------------------------------------------------------------------------------------------
    Cannot open backup device 'https://<url>/aaa.bak'. Operating system error 2(The system cannot find the file specified.).
  • Reply To: how to catch previous error message

    use dba 
    go

    create or alter procedure sqlserver.PollForURLBackup (
    -- @URL nvarchar(500),
    @DBBackup nvarchar(500),
    @TimeOutSeconds int
    ) as

    set nocount on
    drop...

    • This reply was modified 8 months, 2 weeks ago by  John Trollope.

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