Forum Replies Created

Viewing 15 posts - 616 through 630 (of 7,506 total)

  • Reply To: How to put a variable content as attachment file saida.txt ?

    Best is to have sp_send_dbmail execute the query and store the result in a given filename to be added to the email

    e.g:

    declare @subject varchar(1000)
    set @subject = @@servername...

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

  • Reply To: Can show trigger be granted without the update trigger credential in Aurora or m

    I don't know for Aurora and mysql

     

    In SQLServer you can just use "GRANT view definition TO ..."

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

  • Reply To: Upgrading SQL Server 2008 R2 to 2017

    I would not rename the new server (to much a hassle ), but have an alias for the name of the old server point to the new server.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

  • Reply To: Restore multiple transaction logs from disk

    ashatimjohn wrote:

    I figured out why the exec @cmd wasn't working. I was filtering out the files before it got to the cursor. Now I have one last problem. I am...

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

  • Reply To: Restore multiple transaction logs from disk

    Does your service account have access to 'D:\TelcorLogDump\' ?

     

    crossed with your last reply 😉

     

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

  • Reply To: Alter Huge Table

    1. Of course, updating the existing table will cause splits / fragmentation
    2. My guess, your primary key is non-clustered ( dbatools scenario ), so insert into a heap ( quickest...

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

  • Reply To: Restore multiple transaction logs from disk

    Using "with standby" you force the engine to make your database available in a read-only state.

    If you know you'll have to restore all log backup files, use NoRecovery in stead...

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

  • Reply To: Alter Huge Table

    SQLServer will have to rewrite the whole table as internal workings of varchar(n) versus varchar(max) !

    1. You could also prepare the modification via SSMS and script the operation.

    It will probably...

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

  • Reply To: Linked Servers for Dummies; Troubleshooting access over VPN...

    So, someone has a local instance of SQLServer on his/her/its client and declared a Linked Server pointing to another SQLServer instance which can be available with an active VPN connection.

      ...

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

  • Viewing 15 posts - 616 through 630 (of 7,506 total)