an ASP.NET Open Source CMS & eCommerce platform
Search:
SQL Error
Last Post 8/10/2009 9:55:38 AM By lukezy. 3 replies.
8/10/2009 6:48:28 AM
4safety
Posts: 124
Joined: 5/11/2009
SQL Error
Luke,
 
I am getting this in a SQL error log and its racking up huge text files.
 
The query notification dialog on conversation handle '{8D7EF5BC-544A-DB11-B6E0-000F1FD735BF}.' closed due to the following error: '<?xml version="1.0"?><Error xmlns="http://schemas.microsoft.com/SQL/ServiceBroker/Error"><Code>-8490</Code><Description>Cannot find the remote service &apos;SqlQueryNotificationService-d61fa581-0567-43ba-991f-37499e87cbf6&apos; because it does not exist.</Description></Error>'.
 
 
Please advise on how to fix this?
 
thanks
8/10/2009 8:37:05 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: SQL Error
If you search SQL books online, you should find there is nothing to fix here. It's just notification only. Where did you get this message from?
DotShoppingCart Staff
8/10/2009 8:42:42 AM
4safety
Posts: 124
Joined: 5/11/2009
Re: SQL Error
Well I had noticed that my server space on my Virtual dedicated was almost used up so i did some searching and found error logs in MSSQL folder that were 1.5GB to 2.5GB.  That seems to be the error that kept showing up the most.  Is there away to limit the size of those error logs?
8/10/2009 9:55:38 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: SQL Error
Please refere to SQL books online for more database maintanence guide. You can use sp_cycle_errorlog and limit the number of error log files.
DotShoppingCart Staff
Project hosted at CodePlex.com
Copyright © 2013 DotShoppingCart. All rights reserved.