New install: SSMS cannot open new empty query or select top 1000
I have a new hp 2010 laptop. SQL Server 2017 and SSMS were installed and it worked.
I then needed to uninstall SQL Server 2017 and reinstall with mixed authentication enabled during the install.
Today my SSMS will not allow me to create a new query and I cannot select the top 1000 records of a table.
I select "New Query" and get the error:
Insufficient memory to continue the execution of the program. (mscorlib)
I have tried multiple uninstalls and resinstalled this and an older version of SSMS.
I believe SQL Server is running okay.
Any ideas?
Thanks
travelerhj
ssms
add a comment |
I have a new hp 2010 laptop. SQL Server 2017 and SSMS were installed and it worked.
I then needed to uninstall SQL Server 2017 and reinstall with mixed authentication enabled during the install.
Today my SSMS will not allow me to create a new query and I cannot select the top 1000 records of a table.
I select "New Query" and get the error:
Insufficient memory to continue the execution of the program. (mscorlib)
I have tried multiple uninstalls and resinstalled this and an older version of SSMS.
I believe SQL Server is running okay.
Any ideas?
Thanks
travelerhj
ssms
Have you checked this? stackoverflow.com/questions/17918770/…
– Praneet Nadkar
Nov 27 '18 at 5:31
Yes I reviewed those answers. Those posts relate to running a large sql query against a database. I am only trying to open a new empty query. I fear my issue is due to uninstalling then reinstalling.
– travelerhj
Nov 27 '18 at 13:11
add a comment |
I have a new hp 2010 laptop. SQL Server 2017 and SSMS were installed and it worked.
I then needed to uninstall SQL Server 2017 and reinstall with mixed authentication enabled during the install.
Today my SSMS will not allow me to create a new query and I cannot select the top 1000 records of a table.
I select "New Query" and get the error:
Insufficient memory to continue the execution of the program. (mscorlib)
I have tried multiple uninstalls and resinstalled this and an older version of SSMS.
I believe SQL Server is running okay.
Any ideas?
Thanks
travelerhj
ssms
I have a new hp 2010 laptop. SQL Server 2017 and SSMS were installed and it worked.
I then needed to uninstall SQL Server 2017 and reinstall with mixed authentication enabled during the install.
Today my SSMS will not allow me to create a new query and I cannot select the top 1000 records of a table.
I select "New Query" and get the error:
Insufficient memory to continue the execution of the program. (mscorlib)
I have tried multiple uninstalls and resinstalled this and an older version of SSMS.
I believe SQL Server is running okay.
Any ideas?
Thanks
travelerhj
ssms
ssms
edited Nov 27 '18 at 5:26
marc_s
578k12911161262
578k12911161262
asked Nov 27 '18 at 4:56
travelerhjtravelerhj
11
11
Have you checked this? stackoverflow.com/questions/17918770/…
– Praneet Nadkar
Nov 27 '18 at 5:31
Yes I reviewed those answers. Those posts relate to running a large sql query against a database. I am only trying to open a new empty query. I fear my issue is due to uninstalling then reinstalling.
– travelerhj
Nov 27 '18 at 13:11
add a comment |
Have you checked this? stackoverflow.com/questions/17918770/…
– Praneet Nadkar
Nov 27 '18 at 5:31
Yes I reviewed those answers. Those posts relate to running a large sql query against a database. I am only trying to open a new empty query. I fear my issue is due to uninstalling then reinstalling.
– travelerhj
Nov 27 '18 at 13:11
Have you checked this? stackoverflow.com/questions/17918770/…
– Praneet Nadkar
Nov 27 '18 at 5:31
Have you checked this? stackoverflow.com/questions/17918770/…
– Praneet Nadkar
Nov 27 '18 at 5:31
Yes I reviewed those answers. Those posts relate to running a large sql query against a database. I am only trying to open a new empty query. I fear my issue is due to uninstalling then reinstalling.
– travelerhj
Nov 27 '18 at 13:11
Yes I reviewed those answers. Those posts relate to running a large sql query against a database. I am only trying to open a new empty query. I fear my issue is due to uninstalling then reinstalling.
– travelerhj
Nov 27 '18 at 13:11
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53492987%2fnew-install-ssms-cannot-open-new-empty-query-or-select-top-1000%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53492987%2fnew-install-ssms-cannot-open-new-empty-query-or-select-top-1000%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Have you checked this? stackoverflow.com/questions/17918770/…
– Praneet Nadkar
Nov 27 '18 at 5:31
Yes I reviewed those answers. Those posts relate to running a large sql query against a database. I am only trying to open a new empty query. I fear my issue is due to uninstalling then reinstalling.
– travelerhj
Nov 27 '18 at 13:11