How can I / Should I reuse SqlCacheDependency? thanks

I can create a SqlCacheDependency, and link it to a cached item in httpcontext cache. When something change, it will remove the cached item from the cache. I think I have to redo the process when that happens - prepare sql command, create SqlCacheDependency and insert the item into cache. Now I only need a notification from my SQL when something changes in one of my table, I don;t need read anything from db, and I think I should find a way to not recreate the SqlCacheDependency object everytime?

any suggestion?

Maybe you need a update/insert trigger that raise an error. For example, if you want to get notification when something changes in t1, you can use such T-SQL command to create a trigger:

create trigger trg_t1 on t1 for update,insert,delete
as
RAISERROR ('Some change has been made to table t1',16, 1)

go

To learn more about RAISERROR command, please take a look at:

http://msdn.microsoft.com/library/en-us/tsqlref/ts_ra-rz_5ooi.asp?frame=true

And for triggers you can start from here:

http://msdn.microsoft.com/library/en-us/createdb/cm_8_des_08_116g.asp?frame=true

|||I am not sure what the trigger you described can help in my case. What I need is a way to let DB notify ASP when something change, the change is made by other ASP httphandlers, so those change should go on without interrupt. Once the change is done, it should notify ASP, which will invalid the data that cached with SQLCacheDependency. The problem what I have is once that happens, the SQLCacheDepency object will be removed, I need recreate it again. I think it is unnecessory, since I only need a notification from DB.

Hotfix Post SP4

Hi all,
I am searching for a list of published hotfix posted after SQL Server SP4.
Is there such a link or URL, on the Microsoft site?
Thank you for your time.
Franco
Nope. You kind of have to poke around. There are 3 post-SP4 hotfixes that
I am aware of:
Build 2040, to fix the AWE memory issue.
Build 2148, to fix the SQLDiag issue, but also fixes another 10 or so.
Build 2151, to fix the Query Analyzer DTC issue.
This site can be helpful though.
SQL Server Version Database
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
Otherwise, you are stuck searching through the Microsoft Support site.
Build 2040:
FIX: Not all memory is available when AWE is enabled on a computer that is
running a 32-bit version of SQL Server 2000 SP4
http://support.microsoft.com/default...b;en-us;899761
Build 2148:
FIX: An access violation may occur when a deadlock graph is written to the
error log in SQL Server 2000
http://support.microsoft.com/default...b;en-us;898626
FIX: An access violation may occur when you run a SELECT query and the
NO_BROWSETABLE option is set to ON in Microsoft SQL Server 2000
http://support.microsoft.com/default...b;en-us;899430
FIX: An access violation occurs in the Mssdi98.dll file, and SQL Server
crashes when you use SQL Query Analyzer to debug a stored procedure in SQL
Server 2000 Service Pack 4
http://support.microsoft.com/default...b;en-us;899431
FIX: The Mssdmn.exe process may use lots of CPU capacity when you perform a
SQL Server 2000 full text search of Office Word documents
http://support.microsoft.com/default...b;en-us;900390
FIX: The results of the query may be returned much slower than you expect
when you run a query that includes a GROUP BY statement in SQL Server 2000
http://support.microsoft.com/default...b;en-us;900404
FIX: You receive a "Failed to open a table" error message when you try to
open a trace table by using SQL Profiler after you upgrade to SQL Server
2000 Service Pack 4
http://support.microsoft.com/default...b;en-us;900629
FIX: You may receive a "Server: Msg 7358, Level 16, State 1, Line 1" error
message after you run a linked server query in SQL Server 2000 Service Pack
4
http://support.microsoft.com/default...b;en-us;901200
FIX: You receive an error message if you use the sp_addalias or sp_dropalias
procedures when the IMPLICIT_TRANSACTIONS option is set to ON in SQL Server
2000 SP4
http://support.microsoft.com/default...b;en-us;901212
FIX: Some 32-bit applications that use SQL-DMO and SQL-VDI APIs may stop
working after you install SQL Server 2000 Service Pack 4 on an Itanium-based
computer
http://support.microsoft.com/default...b;en-us;902150
FIX: You receive a "Getting registry information" message when you run the
Sqldiag.exe utility after you install SQL Server 2000 SP4
http://support.microsoft.com/default...b;en-us;902955
FIX: The batch job stops running, and job output is truncated when you run a
Transact-SQL script as a SQL Server Agent job in SQL Server 2000
http://support.microsoft.com/default...b;en-us;903086
Build 2151:
FIX: You receive an "Error: 8526, Severity: 16, State: 2" error message in
SQL Profiler when you use SQL Query Analyzer to start or to enlist into a
distributed transaction after you have installed SQL Server 2000 SP4
http://support.microsoft.com/default...b;en-us;903742
Sincerely,
Anthony Thomas

"Franco" <Franco@.discussions.microsoft.com> wrote in message
news:6C7551B7-1250-4504-B844-D81BCCDEF252@.microsoft.com...
> Hi all,
> I am searching for a list of published hotfix posted after SQL Server SP4.
> Is there such a link or URL, on the Microsoft site?
> Thank you for your time.
> --
> Franco
|||Thank you very much.
I really appreciate your answer.
Kind regards.
Franco
"Anthony Thomas" wrote:

> Nope. You kind of have to poke around. There are 3 post-SP4 hotfixes that
> I am aware of:
> Build 2040, to fix the AWE memory issue.
> Build 2148, to fix the SQLDiag issue, but also fixes another 10 or so.
> Build 2151, to fix the Query Analyzer DTC issue.
> This site can be helpful though.
>
> SQL Server Version Database
> http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
>
> Otherwise, you are stuck searching through the Microsoft Support site.
>
> Build 2040:
> FIX: Not all memory is available when AWE is enabled on a computer that is
> running a 32-bit version of SQL Server 2000 SP4
> http://support.microsoft.com/default...b;en-us;899761
>
> Build 2148:
> FIX: An access violation may occur when a deadlock graph is written to the
> error log in SQL Server 2000
> http://support.microsoft.com/default...b;en-us;898626
> FIX: An access violation may occur when you run a SELECT query and the
> NO_BROWSETABLE option is set to ON in Microsoft SQL Server 2000
> http://support.microsoft.com/default...b;en-us;899430
> FIX: An access violation occurs in the Mssdi98.dll file, and SQL Server
> crashes when you use SQL Query Analyzer to debug a stored procedure in SQL
> Server 2000 Service Pack 4
> http://support.microsoft.com/default...b;en-us;899431
> FIX: The Mssdmn.exe process may use lots of CPU capacity when you perform a
> SQL Server 2000 full text search of Office Word documents
> http://support.microsoft.com/default...b;en-us;900390
> FIX: The results of the query may be returned much slower than you expect
> when you run a query that includes a GROUP BY statement in SQL Server 2000
> http://support.microsoft.com/default...b;en-us;900404
> FIX: You receive a "Failed to open a table" error message when you try to
> open a trace table by using SQL Profiler after you upgrade to SQL Server
> 2000 Service Pack 4
> http://support.microsoft.com/default...b;en-us;900629
> FIX: You may receive a "Server: Msg 7358, Level 16, State 1, Line 1" error
> message after you run a linked server query in SQL Server 2000 Service Pack
> 4
> http://support.microsoft.com/default...b;en-us;901200
> FIX: You receive an error message if you use the sp_addalias or sp_dropalias
> procedures when the IMPLICIT_TRANSACTIONS option is set to ON in SQL Server
> 2000 SP4
> http://support.microsoft.com/default...b;en-us;901212
> FIX: Some 32-bit applications that use SQL-DMO and SQL-VDI APIs may stop
> working after you install SQL Server 2000 Service Pack 4 on an Itanium-based
> computer
> http://support.microsoft.com/default...b;en-us;902150
> FIX: You receive a "Getting registry information" message when you run the
> Sqldiag.exe utility after you install SQL Server 2000 SP4
> http://support.microsoft.com/default...b;en-us;902955
> FIX: The batch job stops running, and job output is truncated when you run a
> Transact-SQL script as a SQL Server Agent job in SQL Server 2000
> http://support.microsoft.com/default...b;en-us;903086
>
> Build 2151:
> FIX: You receive an "Error: 8526, Severity: 16, State: 2" error message in
> SQL Profiler when you use SQL Query Analyzer to start or to enlist into a
> distributed transaction after you have installed SQL Server 2000 SP4
> http://support.microsoft.com/default...b;en-us;903742
>
> Sincerely,
>
> Anthony Thomas
>
> --
> "Franco" <Franco@.discussions.microsoft.com> wrote in message
> news:6C7551B7-1250-4504-B844-D81BCCDEF252@.microsoft.com...
>
>

Hot fix 821334

Hi,
Anyone knows where to download the above? The kb article doesn't have a link
to download it.
--
Best Regards,
Kit Kai
MVP (asp.net)
SgDotNet Council Member
Visit Us @. http://www.sgdotnet.org
My Blog: http://community.sgdotnet.org/blogs/kitkaiHello Loke,
you could contact Microsoft Product Support Services directly to obtain the
fix. For a complete list of Microsoft Product Support Services phone
numbers and information about support costs, visit the following Microsoft
Web site:
http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS
NOTE: In special cases, charges that are ordinarily incurred for support
calls may be canceled if a Microsoft Support Professional determines that a
specific update will resolve your problem. The typical support costs will
apply to additional support questions and issues that do not qualify for
the specific update in question.
Thanks & 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: "Loke Kit Kai" <kitkai@.community.nospam>
| Subject: Hot fix 821334
| Date: Fri, 6 May 2005 11:16:07 +0800
| Lines: 14
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
| X-RFC2646: Format=Flowed; Original
| Message-ID: <eeYtzneUFHA.544@.TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 203.118.60.18
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:42947
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hi,
| Anyone knows where to download the above? The kb article doesn't have a
link
| to download it.
|
|
| --
| Best Regards,
| Kit Kai
| MVP (asp.net)
| SgDotNet Council Member
| Visit Us @. http://www.sgdotnet.org
| My Blog: http://community.sgdotnet.org/blogs/kitkai
|
|
||||Hi Peter,
I just called the PSS, but they say there is not such hotfix. Could you help
me check please?
--
Best Regards,
Kit Kai
MVP (asp.net)
SgDotNet Council Member
Visit Us @. http://www.sgdotnet.org
My Blog: http://community.sgdotnet.org/blogs/kitkai
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:KwS4EOgUFHA.3928@.TK2MSFTNGXA01.phx.gbl...
> Hello Loke,
> you could contact Microsoft Product Support Services directly to obtain
> the
> fix. For a complete list of Microsoft Product Support Services phone
> numbers and information about support costs, visit the following Microsoft
> Web site:
> http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS
> NOTE: In special cases, charges that are ordinarily incurred for support
> calls may be canceled if a Microsoft Support Professional determines that
> a
> specific update will resolve your problem. The typical support costs will
> apply to additional support questions and issues that do not qualify for
> the specific update in question.
> Thanks & 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: "Loke Kit Kai" <kitkai@.community.nospam>
> | Subject: Hot fix 821334
> | Date: Fri, 6 May 2005 11:16:07 +0800
> | Lines: 14
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
> | X-RFC2646: Format=Flowed; Original
> | Message-ID: <eeYtzneUFHA.544@.TK2MSFTNGP15.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: 203.118.60.18
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:42947
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Hi,
> | Anyone knows where to download the above? The kb article doesn't have a
> link
> | to download it.
> |
> |
> | --
> | Best Regards,
> | Kit Kai
> | MVP (asp.net)
> | SgDotNet Council Member
> | Visit Us @. http://www.sgdotnet.org
> | My Blog: http://community.sgdotnet.org/blogs/kitkai
> |
> |
> |
>

Hot fix 821334

Hi,
Anyone knows where to download the above? The kb article doesn't have a link
to download it.
--
Best Regards,
Kit Kai
MVP (asp.net)
SgDotNet Council Member
Visit Us @. http://www.sgdotnet.org
My Blog: http://community.sgdotnet.org/blogs/kitkaiContact MS Product Support if you need a fix that isn't in a Service Pack.
--
David Portas
SQL Server MVP
--|||Or hang on a little while for SP4. :-)
--
David Portas
SQL Server MVP
--|||http://www.microsoft.com/sql/downloads/2000/sp4.asp
--
David Portas
SQL Server MVP
--|||Thanks :)
--
Best Regards,
Kit Kai
MVP (asp.net)
SgDotNet Council Member
Visit Us @. http://www.sgdotnet.org
My Blog: http://community.sgdotnet.org/blogs/kitkai
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:2_mdnZoBj_RPXObfRVn-vQ@.giganews.com...
> http://www.microsoft.com/sql/downloads/2000/sp4.asp
> --
> David Portas
> SQL Server MVP
> --
>