Last post Dec 04, 2018 02:10 PM by devo2017
Nov 30, 2018 09:41 PM|devo2017|LINK
I have the problem that if I generate a script via SQL Server Express 2017, it will take a long time. It keeps hanging at 'Getting the list of objects of [DATABASE]'. In the beginning I could easily and quickly generate a scheme + data script, but since
a few months I have run into this problem. Someone who knows what the problem might be?
Sometimes when I open a table to view the data, it may take some time and makes the SQL server slow, causing my websites to load slowly.
Dec 03, 2018 02:50 AM|Nan Yu|LINK
Hi devo2017 ,
That sounds like network problem. Do you host the sql server in a remote server ? And how many records exist in your table ?
Dec 04, 2018 02:10 PM|devo2017|LINK
thanks for your answer
It is probably not a network problem because i'm generating the script from the server it self. While the server is generating the script, other queries (from websites etc) are waiting to be executed when the generation is completed. Even if i try to generate
a script from a small database with no records, it would still not continue