Error 17177

Getting error 17177, process in use since blah blah date. Anyone know what
this means?
Thanks!It's just an informational message that's logged - it
doesn't mean there is a problem.
-Sue
On Tue, 5 Jul 2005 19:17:02 -0700, "fnguy"
<fnguy@.discussions.microsoft.com> wrote:
>Getting error 17177, process in use since blah blah date. Anyone know what
>this means?
>Thanks!

Error 15457 in sql logs

Seeing an error 15457 in the error log. Anyone know what it means? Thanks
It generally appears when you use EM to look at a servers properties and you
are a sysadmin. It's just the output of making sure "show advanced options"
is on, nothing to worry about.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"fnguy" <fnguy@.discussions.microsoft.com> wrote in message
news:3CC4F5CE-81FF-44AD-804C-03BD84985423@.microsoft.com...
> Seeing an error 15457 in the error log. Anyone know what it means?
> Thanks

Error 15457 in sql logs

Seeing an error 15457 in the error log. Anyone know what it means? ThanksIt generally appears when you use EM to look at a servers properties and you
are a sysadmin. It's just the output of making sure "show advanced options"
is on, nothing to worry about.
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"fnguy" <fnguy@.discussions.microsoft.com> wrote in message
news:3CC4F5CE-81FF-44AD-804C-03BD84985423@.microsoft.com...
> Seeing an error 15457 in the error log. Anyone know what it means?
> Thanks

Error 15457 in sql logs

Seeing an error 15457 in the error log. Anyone know what it means? ThanksIt generally appears when you use EM to look at a servers properties and you
are a sysadmin. It's just the output of making sure "show advanced options"
is on, nothing to worry about.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"fnguy" <fnguy@.discussions.microsoft.com> wrote in message
news:3CC4F5CE-81FF-44AD-804C-03BD84985423@.microsoft.com...
> Seeing an error 15457 in the error log. Anyone know what it means?
> Thankssql

Error 0x8007F303 whilst printing

Can anyone tell me what the error code means when trying to print an
AutoRefresh report from Report Manager using the ActiveX print control?
Many thanks,
James SnapeHello James,
Based on my research, the issue occurs while "Printing has been cancelled".
However, there is no indication why this occurs when you refresh report via
print control. I suspect it is some issue insdie control.
To find out the root cause of this issue we may need to analyze memory
dumps, this work has to be done by contacting Microsoft Product Support
Services. Therefore, we probably will not be able to resolve the issue
through the newsgroups. I recommend that you open a Support incident with
Microsoft Product Support Services so that a dedicated Support Professional
can assist with this case. If you need any help in this regard, please let
me know.
For a complete list of Microsoft Product Support Services phone numbers,
please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "James Snape" <jim_snape.at.hotmail.com@.online.nospam>
>Subject: Error 0x8007F303 whilst printing
>Date: Tue, 24 Jan 2006 09:52:16 -0000
>Lines: 7
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
>X-RFC2646: Format=Flowed; Original
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
>Message-ID: <uOORdvMIGHA.3176@.TK2MSFTNGP12.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>NNTP-Posting-Host: exony-ltd-02.altohiway.com 213.83.66.226
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67383
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>Can anyone tell me what the error code means when trying to print an
>AutoRefresh report from Report Manager using the ActiveX print control?
>Many thanks,
>James Snape
>
>|||Any update on this issue? please reply..
"Peter Yang [MSFT]" wrote:
> Hello James,
> Based on my research, the issue occurs while "Printing has been cancelled".
> However, there is no indication why this occurs when you refresh report via
> print control. I suspect it is some issue insdie control.
> To find out the root cause of this issue we may need to analyze memory
> dumps, this work has to be done by contacting Microsoft Product Support
> Services. Therefore, we probably will not be able to resolve the issue
> through the newsgroups. I recommend that you open a Support incident with
> Microsoft Product Support Services so that a dedicated Support Professional
> can assist with this case. If you need any help in this regard, please let
> me know.
> For a complete list of Microsoft Product Support Services phone numbers,
> please go to the following address on the World Wide Web:
> http://support.microsoft.com/directory/overview.asp
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> --
> >From: "James Snape" <jim_snape.at.hotmail.com@.online.nospam>
> >Subject: Error 0x8007F303 whilst printing
> >Date: Tue, 24 Jan 2006 09:52:16 -0000
> >Lines: 7
> >X-Priority: 3
> >X-MSMail-Priority: Normal
> >X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> >X-RFC2646: Format=Flowed; Original
> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> >Message-ID: <uOORdvMIGHA.3176@.TK2MSFTNGP12.phx.gbl>
> >Newsgroups: microsoft.public.sqlserver.reportingsvcs
> >NNTP-Posting-Host: exony-ltd-02.altohiway.com 213.83.66.226
> >Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
> >Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67383
> >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> >
> >Can anyone tell me what the error code means when trying to print an
> >AutoRefresh report from Report Manager using the ActiveX print control?
> >
> >Many thanks,
> >James Snape
> >
> >
> >
>

Error - There is insufficient system memory to run this query.

Hello,

We receive this error after running a complex query. Could someone please shed some light on what this means exactly?

One of our developer said we needed to purchase a server with more memory, but would SQL Server not simply just run slower by using virtual memory instead of physical RAM?

I know there is a limit and servers must be upgraded as the processing requirements increase, due to data set size increases for example, but we have just been told to "purchase more power because after a while as you process more rows, SQL Server will require more resources"

Any comments on this would be really appreciated.the "complex query" may be written inefficiently. if you post the code, i am sure someone will help you. see Bretts sticky on the top of the page.|||The query is not important, meaning we wish to understand the specific cause of the error. Whilst executing the query, we observed that tempDB was only ~20% full and there was plently of virtual memory available. Does SQL Server require a certain amount of Physical RAM available even though there is an abundance of Virtual available.

Thanks.|||the "complex query" may be written inefficiently. if you post the code, i am sure someone will help you. see Bretts sticky on the top of the page.

Sean,
he will not post the code.Forget it.This is not the first time that he is not posting the code. http://www.dbforums.com/showthread.php?t=1211545|||I am perfectly happy if people choose not to reply, however I must point out that your previous comment was grossly inappropriate.

The code is in no way relevant to my question, which was further explained in my second reply. Whether or not the portion of code in question is complex or not is immaterial. I do not require assistant with optimizing this particular portion of SQL code, so please do not request I rewrite my question. I intentionally did not provide the code, as to take attention away from the real underlying issue.

I will also point out that as general courtesy both in an online and offline environment, should you not agree with another person's viewpoint or method of which they have gone about something, the mature response is to not get involved and leave it to those who may, should any chose to do so.

Thank You.|||I assume you have done a Google on the error message, and tried to exclude other causes of the message?|||It is not inappropriate or irrelevant. Bad sql can cause all kinds of trouble.