Poison Message Question

I know I have to build in some ability to deal with a posion message. I was thinking that (sort of mentioned in the article http://msdn2.microsoft.com/en-us/library/ms166137.aspx) I would write a special stored procedure that would handle this situation. I don't know how I could activate this. I don't want to poll of course in a waitfor.

Does anyone have a good idea on this?

When a poison message is detected and a queue is disabled, an event notification is also fired. To subscribe to this event, create an event notification:

CREATE EVENT NOTIFICATION [QueueDisabled]

ON QUEUE [<queue name>]

FOR BROKER_QUEUE_DISABLED

TO SERVICE 'QueueDisabledServiceHandler', 'current database';

You can nou implment the procedure as an activated procedure on the queue servicing the 'QueueDisabledServiceHandler' service. The event message body contains the name and schema of the queue being disabled because of a poison message.

HTH,
~ Remus

Please Please Please

Hi,
How do i sort on calculate fields?
i have a group which will show the sum of all the details. how do i sort on
the group level ?
EX:
a 55
b 22
c 100
a 55
3
4
3
45
b 22
11
11
c 100
50
50
i want output as
b 22
a 55
c 100
Pls hlep meIn the sorting value of your group, enter this expression :
=Sum(Fields!MyField.Value, "group_name")|||I am doing dynamic sorting - column headers -
and the paramter doesnt take the value of an aggregate.
any other suggestions ?
"Julich" wrote:
> In the sorting value of your group, enter this expression :
> =Sum(Fields!MyField.Value, "group_name")
>|||If dynamic sorting means specifýing the sort column via report parameter
(e.g. "SortBy"), try that as the sorting value for your group:
=Sum(Fields(Parameters!SortBy.Value).Value, "group_name")
"RP" wrote:
> I am doing dynamic sorting - column headers -
> and the paramter doesnt take the value of an aggregate.
> any other suggestions ?
> "Julich" wrote:
> > In the sorting value of your group, enter this expression :
> >
> > =Sum(Fields!MyField.Value, "group_name")
> >
> >

Please help: what version of SQL Do I have/need??

I have a Small Business Server 2003, which comes w/some
sort of SQL, as I understand. However, one of my software
vendors asked me whether I am able to locate/start
the "SQL Enterprise Manager". Does this mean I need SQL
Enterprise Edition, or just a stand-alone SQL 2000 such
as this one: http://buycheapsoftware.com/details.asp?
productID=261?
Thanks.What edition of SBS do you have?
Enterprise Manager doesn't have anything to do with Enterprise Manager (EM). EM is just the GUI tool
that comes with SQL Server that allow you to administrate etc. SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Vlad P" <anonymous@.discussions.microsoft.com> wrote in message
news:2bd601c4ab13$8d813500$a501280a@.phx.gbl...
>I have a Small Business Server 2003, which comes w/some
> sort of SQL, as I understand. However, one of my software
> vendors asked me whether I am able to locate/start
> the "SQL Enterprise Manager". Does this mean I need SQL
> Enterprise Edition, or just a stand-alone SQL 2000 such
> as this one: http://buycheapsoftware.com/details.asp?
> productID=261?
> Thanks.|||Enterprise Manager is a management tool (GUI/program) that ships with the
editions of SQL Server including Personal, Developer, Standard and
Enterprise.
If you have installed this tool it will show up within the SQL Server
program group within your start menu.
--
Keith
"Vlad P" <anonymous@.discussions.microsoft.com> wrote in message
news:2bd601c4ab13$8d813500$a501280a@.phx.gbl...
> I have a Small Business Server 2003, which comes w/some
> sort of SQL, as I understand. However, one of my software
> vendors asked me whether I am able to locate/start
> the "SQL Enterprise Manager". Does this mean I need SQL
> Enterprise Edition, or just a stand-alone SQL 2000 such
> as this one: http://buycheapsoftware.com/details.asp?
> productID=261?
> Thanks.|||It's Standard Edition
>--Original Message--
>What edition of SBS do you have?
>Enterprise Manager doesn't have anything to do with
Enterprise Manager (EM). EM is just the GUI tool
>that comes with SQL Server that allow you to administrate
etc. SQL Server.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Vlad P" <anonymous@.discussions.microsoft.com> wrote in
message
>news:2bd601c4ab13$8d813500$a501280a@.phx.gbl...
>>I have a Small Business Server 2003, which comes w/some
>> sort of SQL, as I understand. However, one of my
software
>> vendors asked me whether I am able to locate/start
>> the "SQL Enterprise Manager". Does this mean I need SQL
>> Enterprise Edition, or just a stand-alone SQL 2000 such
>> as this one: http://buycheapsoftware.com/details.asp?
>> productID=261?
>> Thanks.
>
>.
>|||As far as I understand, SE of SBS doesn't come with the regular SQL Server. It comes with MSDE and
WMSDE (which is a special version of MSDE to be used only with Sharepoint).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Vlad P" <anonymous@.discussions.microsoft.com> wrote in message
news:017801c4abc5$442503c0$a301280a@.phx.gbl...
> It's Standard Edition
>>--Original Message--
>>What edition of SBS do you have?
>>Enterprise Manager doesn't have anything to do with
> Enterprise Manager (EM). EM is just the GUI tool
>>that comes with SQL Server that allow you to administrate
> etc. SQL Server.
>>--
>>Tibor Karaszi, SQL Server MVP
>>http://www.karaszi.com/sqlserver/default.asp
>>http://www.solidqualitylearning.com/
>>
>>"Vlad P" <anonymous@.discussions.microsoft.com> wrote in
> message
>>news:2bd601c4ab13$8d813500$a501280a@.phx.gbl...
>>I have a Small Business Server 2003, which comes w/some
>> sort of SQL, as I understand. However, one of my
> software
>> vendors asked me whether I am able to locate/start
>> the "SQL Enterprise Manager". Does this mean I need SQL
>> Enterprise Edition, or just a stand-alone SQL 2000 such
>> as this one: http://buycheapsoftware.com/details.asp?
>> productID=261?
>> Thanks.
>>
>>.

Please Help: Cannot Sort row of size 8104: any advice.

I have a database linked too a website that, we've just put the live data into and hay presto the thing has fallen over. The data has gone in fine but When we search on it it coming up with this error:

Microsoft OLE DB Provider for SQL Server (0x80040E14) Cannot sort a row of size 8104, which is greater than the allowable maximum of 8094.

Has anyone come across this kinda of problem before and is their any nice work arounds. Thanks EdObviously, you managed to get a row size which is 10 more than the maximum. Consider to shorten one of your VARCHAR(x) fields by 10.|||Okay I think I understand the problem now, But I'm still slightly stuck;
I've got the huge amount of data that I've imported and it gone in fine it just this search which throws up problems.

So as far as I can see the only two solution I can look at are some way to make the search accept these size of data or come up with some kind of way of identifing just those singler rows which are causing the problem and deal with them indevidually. Is their some kind of SQL statment that would just return the row where data is above a certain size?

If it any help the SQL look like this:

SELECT DISTINCT
terms.TermName, terms.TermAltName, terms.TermShortDesc, linkSectionSub.SectionID, linkSectionSub.SubID, terms.AutoId,
subSections.SUBName, sections.SCTName
FROM terms INNER JOIN
linkSectorSection INNER JOIN
linkSectionSub ON linkSectorSection.SectionID = linkSectionSub.SectionID INNER JOIN
linkSubTerm ON linkSectionSub.SubID = linkSubTerm.SubID ON terms.AutoId = linkSubTerm.TermID INNER JOIN
sections ON linkSectionSub.SectionID = sections.AutoId INNER JOIN
subSections ON linkSectionSub.SubID = subSections.AutoID
WHERE (linkSectorSection.SectorID = 1)
AND (terms.TermName LIKE '%mortgage%')
OR (linkSectorSection.SectorID = 1)
AND (terms.TermShortDesc LIKE '%mortgage%')
ORDER BY terms.TermName

And the field causing the problems is:
terms.TermShortDesc

Thanks Again|||Originally posted by Nixies
Okay I think I understand the problem now, But I'm still slightly stuck;
I've got the huge amount of data that I've imported and it gone in fine it just this search which throws up problems.

So as far as I can see the only two solution I can look at are some way to make the search accept these size of data or come up with some kind of way of identifing just those singler rows which are causing the problem and deal with them indevidually. Is their some kind of SQL statment that would just return the row where data is above a certain size?

If it any help the SQL look like this:

SELECT DISTINCT
terms.TermName, terms.TermAltName, terms.TermShortDesc, linkSectionSub.SectionID, linkSectionSub.SubID, terms.AutoId,
subSections.SUBName, sections.SCTName
FROM terms INNER JOIN
linkSectorSection INNER JOIN
linkSectionSub ON linkSectorSection.SectionID = linkSectionSub.SectionID INNER JOIN
linkSubTerm ON linkSectionSub.SubID = linkSubTerm.SubID ON terms.AutoId = linkSubTerm.TermID INNER JOIN
sections ON linkSectionSub.SectionID = sections.AutoId INNER JOIN
subSections ON linkSectionSub.SubID = subSections.AutoID
WHERE (linkSectorSection.SectorID = 1)
AND (terms.TermName LIKE '%mortgage%')
OR (linkSectorSection.SectorID = 1)
AND (terms.TermShortDesc LIKE '%mortgage%')
ORDER BY terms.TermName

And the field causing the problems is:
terms.TermShortDesc

Thanks Again

I'm assuming that TermShortDesc is a text field not a varchar.

You have two possible solutions:

Fix the problem short term:
SELECT terms.AutoId, LEN(terms.TermShortDesc) AS CHAR_LEN, terms.TermShortDesc
FROM TERMS
WHERE LEN(terms.TermShortDesc) >8093.
and then edit that data down in length.

The permanent solution is:
Before you get to deep into this, ask yourself these questions:
Do you have to search the entire field? Can you limit data to 8093 characters? In your search do you really have to go beyond the first 500 characters? 1000?

For a permanent solution if you only need the first 500 characters, then make an in your import that TermShortDescSort field and just take the LEFT(TermShortDesc,500) and insert them into TermShortDescSort on import. If you need to go beyond and have all 24,282, then make 3 fields TermShortDesc1, TermShortDesc2, TermShortDesc3 and on import insert into them as Substr(TermShortDesc,1,8094), Substr(TermShortDesc,8095,8094), Substr(TermShortDesc,16188,8094).

Just throwing in my 2 centavos....|||This is fantasic, we've found the offending rows and everything is up and working, Thanks for your Help, Ed