How Can I check what service pack I have?

I need to Know waht service pack I have for sqlserver?
I possible to know that?
http://www.aspfaq.com/2160
http://www.aspfaq.com/
(Reverse address to reply.)
"Lorena" <Lorena@.discussions.microsoft.com> wrote in message
news:D7E0B2B0-A9D1-4BAD-8D8C-D31590BA3D2D@.microsoft.com...
> I need to Know waht service pack I have for sqlserver?
> I possible to know that?
>
>
sql

How Can I check what service pack I have?

I need to Know waht service pack I have for sqlserver?
I possible to know that?http://www.aspfaq.com/2160
http://www.aspfaq.com/
(Reverse address to reply.)
"Lorena" <Lorena@.discussions.microsoft.com> wrote in message
news:D7E0B2B0-A9D1-4BAD-8D8C-D31590BA3D2D@.microsoft.com...
> I need to Know waht service pack I have for sqlserver?
> I possible to know that?
>
>

How can I check the version?

Hi, I need to know what's is the latest service pack of my sql 7.0, how can
I check it?
How do I know which user is using sql database?
Thanks,
SarahHi, I need to know what's is the latest service pack of my sql 7.0, how canI
check it?
run
SELECT @.@.version statement to view the version
7.00.699 SP1
7.00.642 SP2
7.00.961 SP3
7.00.1063 SP4
How do I know which user is using sql database?
sp_who or sp_who2 to see who is logged in.
"Sarah G." <sguo@.coopervision.com> wrote in message
news:u%23lFgq0GEHA.3068@.TK2MSFTNGP11.phx.gbl...
> Hi, I need to know what's is the latest service pack of my sql 7.0, how
can
> I check it?
> How do I know which user is using sql database?
> Thanks,
> Sarah
>|||Thank you so much,
Sarah
"Prasad Koukuntla" <prasad.koukuntla@.scapromo.com> wrote in message
news:eh9exu0GEHA.1240@.TK2MSFTNGP10.phx.gbl...
> Hi, I need to know what's is the latest service pack of my sql 7.0, how
canI
> check it?
> run
> SELECT @.@.version statement to view the version
> 7.00.699 SP1
> 7.00.642 SP2
> 7.00.961 SP3
> 7.00.1063 SP4
> How do I know which user is using sql database?
> sp_who or sp_who2 to see who is logged in.
>
> "Sarah G." <sguo@.coopervision.com> wrote in message
> news:u%23lFgq0GEHA.3068@.TK2MSFTNGP11.phx.gbl...
> can
>

How can I be sure that MSDE is installed and running

How can I check to be sure that the MSDE is installed properly and that it is running?

Should I be able to see the Service Manger in the tray?

Thank you,Check it in task manager under the processes tab.

How can I Associate DataSource with Report using Code

hi,
Thx. in advance.
How can I Associate DataSource with Report using Code.I'm using Reporting
Service Web Serivice
I tried this below code but it is giving error
like
"The data source 'DS_Code_002' cannot be found in this report. --> The data
source 'DS_Code_002' cannot be found in this report"
DataSourceReference reference = new RS.DataSourceReference();
reference.Reference = txtDSPath.Text;
DataSource[] dataSources = new RS.DataSource[1];
DataSource ds = new RS.DataSource();
ds.Item = (RS.DataSourceDefinitionOrReference) reference;
ds.Name = txtDSPath.Text.Substring(txtDSPath.Text.LastIndexOf("/")+1);
dataSources[0] = ds;
rs.SetReportDataSources(txtReportPath.Text, dataSources);
Please help me to resolve the issue.
Thx. again.
regards,
Krishna.MIt took me 2 months to code this after hounding people and digging through
books. I look back and shake my head... :)
Note: FolderPath is the path of where the report root lives... i.e. if your
report was here and called "Top 50 Financial Statements" then the full path
is:
/reports/business/quarterly/Top 50 Financial Statements
and ReportRoot = "/reports/business/quarterly"
RSReports is my reference to the Reporting Service WSDL file (the variable
name you create when reference the reporting services web service)
MyDatasourceName is the name of your datasource. Be sure you specify where
it is exactly. :)
rsDeliverTo is just a variable of RSReports.ReportingService i.e.
Dim rsDeliverTo as RSReports.ReportingService
You should use "rsDeliverTo" to programmatically create your report, so you
can set the datasource in the code below as I have outlined:
Dim reference As New DataSourceReference
reference.Reference = ReportRoot & "/MyDatasourceName"
Dim ReportPathToReport As String = FolderPath + "/" + name
Dim rds() As RSReports.DataSource =rsDeliverTo.GetReportDataSources(ReportPathToReport)
Dim bflag As Boolean = False
Dim strResult As String = ""
For i As Integer = 0 To rds.Length - 1
If TypeOf rds(i).Item Is RSPolarisReports.InvalidDataSourceReference Then
rds(i).Item = CType(reference, DataSourceDefinitionOrReference)
bflag = True
End If
Next i
If (bflag) Then
rsDeliverTo.SetReportDataSources(ReportPathToReport, rds)
End If
Now that you have that, you can then proceed to set the report timeouts,
caching options, etc.
=-Chris
"Krishna kumar.M" <Krishna kumar.M@.discussions.microsoft.com> wrote in
message news:29C00F28-6ED1-4B1B-9BF6-9AFFB8C1CDD6@.microsoft.com...
> hi,
> Thx. in advance.
> How can I Associate DataSource with Report using Code.I'm using Reporting
> Service Web Serivice
> I tried this below code but it is giving error
> like
> "The data source 'DS_Code_002' cannot be found in this report. --> The
> data
> source 'DS_Code_002' cannot be found in this report"
>
> DataSourceReference reference = new RS.DataSourceReference();
> reference.Reference = txtDSPath.Text;
> DataSource[] dataSources = new RS.DataSource[1];
> DataSource ds = new RS.DataSource();
> ds.Item = (RS.DataSourceDefinitionOrReference) reference;
> ds.Name = txtDSPath.Text.Substring(txtDSPath.Text.LastIndexOf("/")+1);
> dataSources[0] = ds;
> rs.SetReportDataSources(txtReportPath.Text, dataSources);
>
> Please help me to resolve the issue.
> Thx. again.
> regards,
> Krishna.M

how can a trigger act asynchronously to the event that fired it in sql server 2005?

if service broker is not an option, how can the trigger and sp(s) called by our trigger act asynchronously to the event that fired the trigger in the first place. We are more concerned with the original event being committed than the actions that follow via the trigger.

Having the trigger call a job using sp_start_job would be one option if you don't want to use Service Broker, although Service broker would be a better approach.

-Sue

|||are jobs supported in all editions (including express)? I thought i read something once saying they (might have just been scheduling) are not supported in express.|||

You could also have the trigger just insert a request into a 'queue' of your own and have a SP that periodically wakes up and processes any pending requests. SSB and SQL Agent help this scenario by providing queues and jobs, respectively, but you could build some of this yourself (using WaitFor, etc.).

Don

|||

so service broker does come free and full featured (except for inter instance) with express? how about the sql job feature, except for maybe scheduling?

how can a trigger act asynchronously to the event that fired it in sql server 2005?

if service broker is not an option, how can the trigger and sp(s) called by our trigger act asynchronously to the event that fired the trigger in the first place. We are more concerned with the original event being committed than the actions that follow via the trigger.

Having the trigger call a job using sp_start_job would be one option if you don't want to use Service Broker, although Service broker would be a better approach.

-Sue

|||are jobs supported in all editions (including express)? I thought i read something once saying they (might have just been scheduling) are not supported in express.|||

You could also have the trigger just insert a request into a 'queue' of your own and have a SP that periodically wakes up and processes any pending requests. SSB and SQL Agent help this scenario by providing queues and jobs, respectively, but you could build some of this yourself (using WaitFor, etc.).

Don

|||

so service broker does come free and full featured (except for inter instance) with express? how about the sql job feature, except for maybe scheduling?

how can a sql server consume a web service

I am trying to figure out how I can have SQL server consume a web
service.Hello Simone,
See [0] and [1].
[0]: http://msdn2.microsoft.com/en-us/library/ms365190.aspx
[1]: http://blogs.msdn.com/sqlclr/archiv.../25/Vineet.aspx
Thanks,
Kent Tegels
http://staff.develop.com/ktegels/

how can a sql server consume a web service

I am trying to figure out how I can have SQL server consume a web
service.
Thanks for your help.
SimoneHi Simone
SQL Server 2005 can provide you with a XML Web Service, this is documented
in Books Online see http://msdn2.microsoft.com/en-us/library/ms345123.aspx or
http://msdn2.microsoft.com/en-us/library/ms191274.aspx
If you want to store information from an RSS feed in your database you may
want to check out
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/exchsqlxml.asp.
With SQL 2005 the CLR could be used to do this and there is an example in
"Pro SQL Server 2005" by Thomas Rizzo et al.
ISBN 1-59059-477-0
John
"Simone" wrote:
> I am trying to figure out how I can have SQL server consume a web
> service.
> Thanks for your help.
> Simone
>|||Hello Thanks for your reply.
We need this for SQL server 2000 and I tried to search at the Microsoft
website but I couldn't find.
Can you help me finding information for this but for SQL server 2000?
Thanks
Simone
John Bell wrote:
> Hi Simone
> SQL Server 2005 can provide you with a XML Web Service, this is documented
> in Books Online see http://msdn2.microsoft.com/en-us/library/ms345123.aspx or
> http://msdn2.microsoft.com/en-us/library/ms191274.aspx
> If you want to store information from an RSS feed in your database you may
> want to check out
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/exchsqlxml.asp.
> With SQL 2005 the CLR could be used to do this and there is an example in
> "Pro SQL Server 2005" by Thomas Rizzo et al.
> ISBN 1-59059-477-0
> John
> "Simone" wrote:
> > I am trying to figure out how I can have SQL server consume a web
> > service.
> >
> > Thanks for your help.
> > Simone
> >
> >|||Hi Simone
The ability to provide a HTTP endpoint directly in SQL Server is only
available in SQL 2005, with SQL 2000 you would need to use something like
IIS. The XML to SQL example
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/exchsqlxml.asp will work for SQL 2000 if you download SQLXML SP2 or higher.
John
"Simone" wrote:
> Hello Thanks for your reply.
> We need this for SQL server 2000 and I tried to search at the Microsoft
> website but I couldn't find.
> Can you help me finding information for this but for SQL server 2000?
> Thanks
> Simone
> John Bell wrote:
> > Hi Simone
> >
> > SQL Server 2005 can provide you with a XML Web Service, this is documented
> > in Books Online see http://msdn2.microsoft.com/en-us/library/ms345123.aspx or
> > http://msdn2.microsoft.com/en-us/library/ms191274.aspx
> >
> > If you want to store information from an RSS feed in your database you may
> > want to check out
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/exchsqlxml.asp.
> > With SQL 2005 the CLR could be used to do this and there is an example in
> > "Pro SQL Server 2005" by Thomas Rizzo et al.
> > ISBN 1-59059-477-0
> >
> > John
> >
> > "Simone" wrote:
> >
> > > I am trying to figure out how I can have SQL server consume a web
> > > service.
> > >
> > > Thanks for your help.
> > > Simone
> > >
> > >
>

how can a sql server consume a web service

I am trying to figure out how I can have SQL server consume a web
service.
Hello Simone,
See [0] and [1].
[0]: http://msdn2.microsoft.com/en-us/library/ms365190.aspx
[1]: http://blogs.msdn.com/sqlclr/archive...25/Vineet.aspx
Thanks,
Kent Tegels
http://staff.develop.com/ktegels/

how can a sql server consume a web service

I am trying to figure out how I can have SQL server consume a web
service.
Thanks for your help.
Simone
Hi Simone
SQL Server 2005 can provide you with a XML Web Service, this is documented
in Books Online see http://msdn2.microsoft.com/en-us/library/ms345123.aspx or
http://msdn2.microsoft.com/en-us/library/ms191274.aspx
If you want to store information from an RSS feed in your database you may
want to check out
http://msdn.microsoft.com/library/de...xchsqlxml.asp.
With SQL 2005 the CLR could be used to do this and there is an example in
"Pro SQL Server 2005" by Thomas Rizzo et al.
ISBN 1-59059-477-0
John
"Simone" wrote:

> I am trying to figure out how I can have SQL server consume a web
> service.
> Thanks for your help.
> Simone
>
|||Hello Thanks for your reply.
We need this for SQL server 2000 and I tried to search at the Microsoft
website but I couldn't find.
Can you help me finding information for this but for SQL server 2000?
Thanks
Simone
John Bell wrote:[vbcol=seagreen]
> Hi Simone
> SQL Server 2005 can provide you with a XML Web Service, this is documented
> in Books Online see http://msdn2.microsoft.com/en-us/library/ms345123.aspx or
> http://msdn2.microsoft.com/en-us/library/ms191274.aspx
> If you want to store information from an RSS feed in your database you may
> want to check out
> http://msdn.microsoft.com/library/de...xchsqlxml.asp.
> With SQL 2005 the CLR could be used to do this and there is an example in
> "Pro SQL Server 2005" by Thomas Rizzo et al.
> ISBN 1-59059-477-0
> John
> "Simone" wrote:
|||Hi Simone
The ability to provide a HTTP endpoint directly in SQL Server is only
available in SQL 2005, with SQL 2000 you would need to use something like
IIS. The XML to SQL example
http://msdn.microsoft.com/library/de...exchsqlxml.asp will work for SQL 2000 if you download SQLXML SP2 or higher.
John
"Simone" wrote:

> Hello Thanks for your reply.
> We need this for SQL server 2000 and I tried to search at the Microsoft
> website but I couldn't find.
> Can you help me finding information for this but for SQL server 2000?
> Thanks
> Simone
> John Bell wrote:
>

how can a sql server consume a web service

I am trying to figure out how I can have SQL server consume a web
service.
Thanks for your help.
SimoneHi Simone
SQL Server 2005 can provide you with a XML Web Service, this is documented
in Books Online see http://msdn2.microsoft.com/en-us/library/ms345123.aspx o
r
http://msdn2.microsoft.com/en-us/library/ms191274.aspx
If you want to store information from an RSS feed in your database you may
want to check out
http://msdn.microsoft.com/library/d.../>
sqlxml.asp.
With SQL 2005 the CLR could be used to do this and there is an example in
"Pro SQL Server 2005" by Thomas Rizzo et al.
ISBN 1-59059-477-0
John
"Simone" wrote:

> I am trying to figure out how I can have SQL server consume a web
> service.
> Thanks for your help.
> Simone
>|||Hello Thanks for your reply.
We need this for SQL server 2000 and I tried to search at the Microsoft
website but I couldn't find.
Can you help me finding information for this but for SQL server 2000?
Thanks
Simone
John Bell wrote:[vbcol=seagreen]
> Hi Simone
> SQL Server 2005 can provide you with a XML Web Service, this is documented
> in Books Online see http://msdn2.microsoft.com/en-us/library/ms345123.aspx
or
> http://msdn2.microsoft.com/en-us/library/ms191274.aspx
> If you want to store information from an RSS feed in your database you may
> want to check out
> http://msdn.microsoft.com/library/d...
chsqlxml.asp.
> With SQL 2005 the CLR could be used to do this and there is an example in
> "Pro SQL Server 2005" by Thomas Rizzo et al.
> ISBN 1-59059-477-0
> John
> "Simone" wrote:
>|||Hi Simone
The ability to provide a HTTP endpoint directly in SQL Server is only
available in SQL 2005, with SQL 2000 you would need to use something like
IIS. The XML to SQL example
http://msdn.microsoft.com/library/d... />
sqlxml.asp will work for SQL 2000 if you download SQLXML SP2 or higher.
John
"Simone" wrote:

> Hello Thanks for your reply.
> We need this for SQL server 2000 and I tried to search at the Microsoft
> website but I couldn't find.
> Can you help me finding information for this but for SQL server 2000?
> Thanks
> Simone
> John Bell wrote:
>

Hotfixes available SQL Server

Hello,
Is there a MS service available or a MS site that lists all (not just secuirty related) generally available hotfixes for SQL Server?
I am aware of the security notification. And also the information available here.
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
Just wondering if I can be alerted when all new hotfixes are available.
TIA
take a look at http://support.microsoft.com/default.aspx?kbid=290211 a link
seems to list all the fixes.
Tim S
"Joe" <anonymous@.discussions.microsoft.com> wrote in message
news:6549916A-680D-4F9F-A848-A4FA25F01CF1@.microsoft.com...
> Hello,
> Is there a MS service available or a MS site that lists all (not just
secuirty related) generally available hotfixes for SQL Server?
> I am aware of the security notification. And also the information
available here.
> http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
> Just wondering if I can be alerted when all new hotfixes are available.
> TIA
>

Hotfixes available SQL Server

Hello,
Is there a MS service available or a MS site that lists all (not just secuir
ty related) generally available hotfixes for SQL Server?
I am aware of the security notification. And also the information available
here.
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
Just wondering if I can be alerted when all new hotfixes are available.
TIAtake a look at http://support.microsoft.com/default.aspx?kbid=290211 a link
seems to list all the fixes.
Tim S
"Joe" <anonymous@.discussions.microsoft.com> wrote in message
news:6549916A-680D-4F9F-A848-A4FA25F01CF1@.microsoft.com...
> Hello,
> Is there a MS service available or a MS site that lists all (not just
secuirty related) generally available hotfixes for SQL Server?
> I am aware of the security notification. And also the information
available here.
> http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
> Just wondering if I can be alerted when all new hotfixes are available.
> TIA
>

hotfix/service pack directory

I remember seeing a post in this newsgroup for a website maintaining a
(fairly) comprehensive list of hotfixes, service packs and cumulative
update packs for SQL Server.
Anyone care to re-post?
Maybe Aaron Bertrand's blog?
http://sqlblog.com/blogs/aaron_bertrand/default.aspx
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"horseradish" wrote:

> I remember seeing a post in this newsgroup for a website maintaining a
> (fairly) comprehensive list of hotfixes, service packs and cumulative
> update packs for SQL Server.
> Anyone care to re-post?
>
|||take a look here
http://www.aspfaq.com/sql2005/show.asp?id=20
and here
http://www.aspfaq.com/sql2000Builds.asp
Denis The SQL Menace
http://sqlservercode.blogspot.com
http://sqlblog.com/blogs/denis_gobo/default.aspx
On Nov 27, 4:34 pm, horseradish <dontcal...@.illcallu.net> wrote:
> I remember seeing a post in this newsgroup for a website maintaining a
> (fairly) comprehensive list of hotfixes, service packs and cumulative
> update packs for SQL Server.
> Anyone care to re-post?
|||Check this one
http://sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
Manu
"horseradish" wrote:

> I remember seeing a post in this newsgroup for a website maintaining a
> (fairly) comprehensive list of hotfixes, service packs and cumulative
> update packs for SQL Server.
> Anyone care to re-post?
>

hotfix/service pack directory

I remember seeing a post in this newsgroup for a website maintaining a
(fairly) comprehensive list of hotfixes, service packs and cumulative
update packs for SQL Server.
Anyone care to re-post?Maybe Aaron Bertrand's blog?
http://sqlblog.com/blogs/aaron_bertrand/default.aspx
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"horseradish" wrote:
> I remember seeing a post in this newsgroup for a website maintaining a
> (fairly) comprehensive list of hotfixes, service packs and cumulative
> update packs for SQL Server.
> Anyone care to re-post?
>|||take a look here
http://www.aspfaq.com/sql2005/show.asp?id=20
and here
http://www.aspfaq.com/sql2000Builds.asp
Denis The SQL Menace
http://sqlservercode.blogspot.com
http://sqlblog.com/blogs/denis_gobo/default.aspx
On Nov 27, 4:34 pm, horseradish <dontcal...@.illcallu.net> wrote:
> I remember seeing a post in this newsgroup for a website maintaining a
> (fairly) comprehensive list of hotfixes, service packs and cumulative
> update packs for SQL Server.
> Anyone care to re-post?|||Check this one
http://sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
Manu
"horseradish" wrote:
> I remember seeing a post in this newsgroup for a website maintaining a
> (fairly) comprehensive list of hotfixes, service packs and cumulative
> update packs for SQL Server.
> Anyone care to re-post?
>|||It must be this one =)
http://sqlserverbuilds.blogspot.com/
--
Ekrem Önsoy
"horseradish" <dontcallme@.illcallu.net> wrote in message
news:Ot30H1TMIHA.6060@.TK2MSFTNGP05.phx.gbl...
>I remember seeing a post in this newsgroup for a website maintaining a
>(fairly) comprehensive list of hotfixes, service packs and cumulative
>update packs for SQL Server.
> Anyone care to re-post?

hotfix/service pack directory

I remember seeing a post in this newsgroup for a website maintaining a
(fairly) comprehensive list of hotfixes, service packs and cumulative
update packs for SQL Server.
Anyone care to re-post?Maybe Aaron Bertrand's blog?
http://sqlblog.com/blogs/aaron_bertrand/default.aspx
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"horseradish" wrote:

> I remember seeing a post in this newsgroup for a website maintaining a
> (fairly) comprehensive list of hotfixes, service packs and cumulative
> update packs for SQL Server.
> Anyone care to re-post?
>|||take a look here
http://www.aspfaq.com/sql2005/show.asp?id=20
and here
http://www.aspfaq.com/sql2000Builds.asp
Denis The SQL Menace
http://sqlservercode.blogspot.com
http://sqlblog.com/blogs/denis_gobo/default.aspx
On Nov 27, 4:34 pm, horseradish <dontcal...@.illcallu.net> wrote:
> I remember seeing a post in this newsgroup for a website maintaining a
> (fairly) comprehensive list of hotfixes, service packs and cumulative
> update packs for SQL Server.
> Anyone care to re-post?|||Check this one
http://sqlsecurity.com/FAQs/SQLServ...63/Default.aspx
Manu
"horseradish" wrote:

> I remember seeing a post in this newsgroup for a website maintaining a
> (fairly) comprehensive list of hotfixes, service packs and cumulative
> update packs for SQL Server.
> Anyone care to re-post?
>|||It must be this one =)
http://sqlserverbuilds.blogspot.com/
Ekrem nsoy
"horseradish" <dontcallme@.illcallu.net> wrote in message
news:Ot30H1TMIHA.6060@.TK2MSFTNGP05.phx.gbl...
>I remember seeing a post in this newsgroup for a website maintaining a
>(fairly) comprehensive list of hotfixes, service packs and cumulative
>update packs for SQL Server.
> Anyone care to re-post?

Hot Fix Prerequisites and Need with Service Packs

We are looking at the possible deployment of the SQL 2005 hot fix
described in http://support.microsoft.com/kb/916002#appliesto to
resolve connection issues with .net to SQL. However, we are unable to
determine if this hot fix has any prerequisites (such as sp1), or if
it fixed in sp1 or even in sp2. I have searched extensively online,
and I do not see this as fixed in any service pack documents (although
the lists are seldom complete), and the prerequisites are missing in
the KB article.
Any help would be appreciated.
TerryIt's not a SQL Server hotfix:
APPLIES TO
. Microsoft ADO.NET 2.0
So in theory, you could be running RTM SQL 2005 and this would work after
applying the fix.
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Terry" <tduffy@.calamos.com> wrote in message
news:1170253010.111201.95670@.p10g2000cwp.googlegroups.com...
> We are looking at the possible deployment of the SQL 2005 hot fix
> described in http://support.microsoft.com/kb/916002#appliesto to
> resolve connection issues with .net to SQL. However, we are unable to
> determine if this hot fix has any prerequisites (such as sp1), or if
> it fixed in sp1 or even in sp2. I have searched extensively online,
> and I do not see this as fixed in any service pack documents (although
> the lists are seldom complete), and the prerequisites are missing in
> the KB article.
> Any help would be appreciated.
> Terry
>|||On Jan 31, 9:47 am, "Kevin3NF" <k...@.SPAMTRAP.3nf-inc.com> wrote:
> It's not a SQL Server hotfix:
> APPLIES TO
> . Microsoft ADO.NET 2.0
> So in theory, you could be running RTM SQL 2005 and this would work after
> applying the fix.
> --
> Kevin Hill
> 3NF Consultinghttp://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:http://kevin3nf.blogspot.com
> "Terry" <tdu...@.calamos.com> wrote in message
> news:1170253010.111201.95670@.p10g2000cwp.googlegroups.com...
>
> > We are looking at the possible deployment of the SQL 2005 hot fix
> > described inhttp://support.microsoft.com/kb/916002#appliestoto
> > resolve connection issues with .net to SQL. However, we are unable to
> > determine if this hot fix has any prerequisites (such as sp1), or if
> > it fixed in sp1 or even in sp2. I have searched extensively online,
> > and I do not see this as fixed in any service pack documents (although
> > the lists are seldom complete), and the prerequisites are missing in
> > the KB article.
> > Any help would be appreciated.
> > Terry- Hide quoted text -
> - Show quoted text -
The KB Article mentions. BUG #: 483 (SQL Hotfix). What makes you say
this is not a SQL hotfix?
Terry|||The "applies to" is the defining term here, not the (SQL Hotfix) part...that
simply means the portion of ADO that is being fixed.
SQL Hotfix KBs have a list of the files that are being replaced, this KB
does not.
I tried to install it on my box and was told I did not have the product that
it applied to, but I do have the correct versions of SQL Server on my test
box.
Hope that helps :)
You can always call PSS and get a free incident opened and ask the same
question...just give them the KB article number when you call,
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
> The KB Article mentions. BUG #: 483 (SQL Hotfix). What makes you say
> this is not a SQL hotfix?
> Terry
>|||On Feb 1, 12:40 pm, "Kevin3NF" <k...@.SPAMTRAP.3nf-inc.com> wrote:
> The "applies to" is the defining term here, not the (SQL Hotfix) part...that
> simply means the portion of ADO that is being fixed.
> SQL Hotfix KBs have a list of the files that are being replaced, this KB
> does not.
> I tried to install it on my box and was told I did not have the product that
> it applied to, but I do have the correct versions of SQL Server on my test
> box.
> Hope that helps :)
> You can always call PSS and get a free incident opened and ask the same
> question...just give them the KB article number when you call,
> --
> Kevin Hill
> 3NF Consultinghttp://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:http://kevin3nf.blogspot.com
>
> > The KB Article mentions. BUG #: 483 (SQL Hotfix). What makes you say
> > this is not a SQL hotfix?
> > Terry- Hide quoted text -
> - Show quoted text -
Thank you Kevin. Your efforts and responses are greatly appreciated.
Terry

Hot Fix Prerequisites and Need with Service Packs

We are looking at the possible deployment of the SQL 2005 hot fix
described in http://support.microsoft.com/kb/916002#appliesto to
resolve connection issues with .net to SQL. However, we are unable to
determine if this hot fix has any prerequisites (such as sp1), or if
it fixed in sp1 or even in sp2. I have searched extensively online,
and I do not see this as fixed in any service pack documents (although
the lists are seldom complete), and the prerequisites are missing in
the KB article.
Any help would be appreciated.
TerryIt's not a SQL Server hotfix:
APPLIES TO
. Microsoft ADO.NET 2.0
So in theory, you could be running RTM SQL 2005 and this would work after
applying the fix.
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Terry" <tduffy@.calamos.com> wrote in message
news:1170253010.111201.95670@.p10g2000cwp.googlegroups.com...
> We are looking at the possible deployment of the SQL 2005 hot fix
> described in http://support.microsoft.com/kb/916002#appliesto to
> resolve connection issues with .net to SQL. However, we are unable to
> determine if this hot fix has any prerequisites (such as sp1), or if
> it fixed in sp1 or even in sp2. I have searched extensively online,
> and I do not see this as fixed in any service pack documents (although
> the lists are seldom complete), and the prerequisites are missing in
> the KB article.
> Any help would be appreciated.
> Terry
>|||On Jan 31, 9:47 am, "Kevin3NF" <k...@.SPAMTRAP.3nf-inc.com> wrote:
> It's not a SQL Server hotfix:
> APPLIES TO
> . Microsoft ADO.NET 2.0
> So in theory, you could be running RTM SQL 2005 and this would work after
> applying the fix.
> --
> Kevin Hill
> 3NF Consultinghttp://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:http://kevin3nf.blogspot.com
> "Terry" <tdu...@.calamos.com> wrote in message
> news:1170253010.111201.95670@.p10g2000cwp.googlegroups.com...
>
>
>
> - Show quoted text -
The KB Article mentions. BUG #: 483 (SQL Hotfix). What makes you say
this is not a SQL hotfix?
Terry|||The "applies to" is the defining term here, not the (SQL Hotfix) part...that
simply means the portion of ADO that is being fixed.
SQL Hotfix KBs have a list of the files that are being replaced, this KB
does not.
I tried to install it on my box and was told I did not have the product that
it applied to, but I do have the correct versions of SQL Server on my test
box.
Hope that helps
You can always call PSS and get a free incident opened and ask the same
question...just give them the KB article number when you call,
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com

> The KB Article mentions. BUG #: 483 (SQL Hotfix). What makes you say
> this is not a SQL hotfix?
> Terry
>|||On Feb 1, 12:40 pm, "Kevin3NF" <k...@.SPAMTRAP.3nf-inc.com> wrote:
> The "applies to" is the defining term here, not the (SQL Hotfix) part...th
at
> simply means the portion of ADO that is being fixed.
> SQL Hotfix KBs have a list of the files that are being replaced, this KB
> does not.
> I tried to install it on my box and was told I did not have the product th
at
> it applied to, but I do have the correct versions of SQL Server on my test
> box.
> Hope that helps
> You can always call PSS and get a free incident opened and ask the same
> question...just give them the KB article number when you call,
> --
> Kevin Hill
> 3NF Consultinghttp://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:http://kevin3nf.blogspot.com
>
>
> - Show quoted text -
Thank you Kevin. Your efforts and responses are greatly appreciated.
Terry

Hot Fix Prerequisites and Need with Service Packs

We are looking at the possible deployment of the SQL 2005 hot fix
described in http://support.microsoft.com/kb/916002#appliesto to
resolve connection issues with .net to SQL. However, we are unable to
determine if this hot fix has any prerequisites (such as sp1), or if
it fixed in sp1 or even in sp2. I have searched extensively online,
and I do not see this as fixed in any service pack documents (although
the lists are seldom complete), and the prerequisites are missing in
the KB article.
Any help would be appreciated.
Terry
It's not a SQL Server hotfix:
APPLIES TO
. Microsoft ADO.NET 2.0
So in theory, you could be running RTM SQL 2005 and this would work after
applying the fix.
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Terry" <tduffy@.calamos.com> wrote in message
news:1170253010.111201.95670@.p10g2000cwp.googlegro ups.com...
> We are looking at the possible deployment of the SQL 2005 hot fix
> described in http://support.microsoft.com/kb/916002#appliesto to
> resolve connection issues with .net to SQL. However, we are unable to
> determine if this hot fix has any prerequisites (such as sp1), or if
> it fixed in sp1 or even in sp2. I have searched extensively online,
> and I do not see this as fixed in any service pack documents (although
> the lists are seldom complete), and the prerequisites are missing in
> the KB article.
> Any help would be appreciated.
> Terry
>
|||On Jan 31, 9:47 am, "Kevin3NF" <k...@.SPAMTRAP.3nf-inc.com> wrote:
> It's not a SQL Server hotfix:
> APPLIES TO
> . Microsoft ADO.NET 2.0
> So in theory, you could be running RTM SQL 2005 and this would work after
> applying the fix.
> --
> Kevin Hill
> 3NF Consultinghttp://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:http://kevin3nf.blogspot.com
> "Terry" <tdu...@.calamos.com> wrote in message
> news:1170253010.111201.95670@.p10g2000cwp.googlegro ups.com...
>
>
> - Show quoted text -
The KB Article mentions. BUG #: 483 (SQL Hotfix). What makes you say
this is not a SQL hotfix?
Terry
|||The "applies to" is the defining term here, not the (SQL Hotfix) part...that
simply means the portion of ADO that is being fixed.
SQL Hotfix KBs have a list of the files that are being replaced, this KB
does not.
I tried to install it on my box and was told I did not have the product that
it applied to, but I do have the correct versions of SQL Server on my test
box.
Hope that helps
You can always call PSS and get a free incident opened and ask the same
question...just give them the KB article number when you call,
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com

> The KB Article mentions. BUG #: 483 (SQL Hotfix). What makes you say
> this is not a SQL hotfix?
> Terry
>
|||On Feb 1, 12:40 pm, "Kevin3NF" <k...@.SPAMTRAP.3nf-inc.com> wrote:
> The "applies to" is the defining term here, not the (SQL Hotfix) part...that
> simply means the portion of ADO that is being fixed.
> SQL Hotfix KBs have a list of the files that are being replaced, this KB
> does not.
> I tried to install it on my box and was told I did not have the product that
> it applied to, but I do have the correct versions of SQL Server on my test
> box.
> Hope that helps
> You can always call PSS and get a free incident opened and ask the same
> question...just give them the KB article number when you call,
> --
> Kevin Hill
> 3NF Consultinghttp://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:http://kevin3nf.blogspot.com
>
>
> - Show quoted text -
Thank you Kevin. Your efforts and responses are greatly appreciated.
Terry