Product Version query

I've just downloaded SQL Server Express (with advanced services) from both the main SQL Server Express website and from MSDN. When I right click on the exe I downloaded and go into properties the Product Version says SQLEVALVER. To me this implies it is an evaluation.

Can I confirm this is just a mistake and if we start to redistribute the product it won't timeout in the future? I am sure it is not an evaluation but just want to make absolutely sure.

hi,

, yep... it's true ...

but as long as you downloaded the correct binaries there's no problem, and it will install the appropriate SQLExpress version..

and this are not Eval binaries... they are just "free"..

regards

Product Search question

I have a search box on my website which is used to search the products database.

I will be using the search text in an SQL stored procedure that uses LIKE statements. The search string could realistically contain any character.

How do I prevent SQL injection when any search string is reasonably feasible? .

supergriff:

How do I prevent SQL injection when any search string is reasonably feasible?

I recommend that you read the weblog entry by Microsoft's Bertrand Le Roy,Please, please, please, learn about injection attacks!|||

Great, so if i'm using stored procedures, rather than string concatenation, this inherently prevents SQL injection? My search function is below:

' Select all ProductsPublicFunction GetAllVisibleProductsBySearchString(ByVal SearchStringAsString)As DataTable

Dim connAs SqlConnection =New SqlConnection(_connectionString)Dim cmdStoredProcedureAsNew SqlCommand("dis_GetAllVisibleProductsBySearchString", conn)

cmdStoredProcedure.CommandType = CommandType.StoredProcedure

cmdStoredProcedure.Parameters.Add(

"@.SearchString", SqlDbType.VarChar, 250).Value = SearchStringDim daAs SqlDataAdapter =New SqlDataAdapter(cmdStoredProcedure)Dim dsAs DataSet =New DataSet()Try

conn.Open()

da.Fill(ds,

"Products")

Catch eAs SqlException

' Handle exception.Finally

conn.Close()

EndTryReturn ds.Tables("Products")EndFunction

Process ID 65 attempting to unlock unowned resource

Process ID 65 attempting to unlock unowned resource PAG: 7:1:166448.
I am getting the above error in the event log for my website.
Can someone help me and tell me what this means?
thansk in Advance. Kim
Hi
See if this applies:
http://support.microsoft.com/?kbid=814654
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kim" <kim@.xxx.com> wrote in message
news:ZW_he.25101$0i3.23178@.bignews3.bellsouth.net. ..
> Process ID 65 attempting to unlock unowned resource PAG: 7:1:166448.
> I am getting the above error in the event log for my website.
> Can someone help me and tell me what this means?
> thansk in Advance. Kim
>
|||Hi,
It looks to be the exact problem - except we are running with service pak 4
here's the version info
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Developer
Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:%23px3ddhWFHA.2960@.TK2MSFTNGP15.phx.gbl...
> Hi
> See if this applies:
> http://support.microsoft.com/?kbid=814654
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Kim" <kim@.xxx.com> wrote in message
> news:ZW_he.25101$0i3.23178@.bignews3.bellsouth.net. ..
>
|||Hi
You are running Windows SP4, but SQL Server SP3 (8.00.760)
The problem was fixed in build 765 which was after SP3.
You can do one of the following:
Download the Security Hotfix Rollup that will take you build to 818
(http://www.microsoft.com/downloads/d...displaylang=en)
Download build 878,
http://support.microsoft.com/default...b;en-us;838166
Or apply SP4 for SQL Server. If you are going to apply SP4, make sure that
your server is not using AWE or PAE as there is a known issue with it and
SP4. http://www.microsoft.com/sql/downloads/2000/sp4.asp and
http://msmvps.com/epprecht/archive/2.../14/46940.aspx
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kim" <kim@.xxx.com> wrote in message
news:LY0ie.14211$7A2.2550@.bignews6.bellsouth.net.. .
> Hi,
> It looks to be the exact problem - except we are running with service pak
> 4
> here's the version info
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Developer
> Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:%23px3ddhWFHA.2960@.TK2MSFTNGP15.phx.gbl...
>
|||Hi,
Thanks for your help.
I will pass this on to the guy who will do the updates.
Kim
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:eoxzWthWFHA.2976@.TK2MSFTNGP10.phx.gbl...
> Hi
> You are running Windows SP4, but SQL Server SP3 (8.00.760)
> The problem was fixed in build 765 which was after SP3.
> You can do one of the following:
> Download the Security Hotfix Rollup that will take you build to 818
>
(http://www.microsoft.com/downloads/d...ae9d-bd44-40c5
-add3-b8c99618e68d&displaylang=en)[vbcol=seagreen]
> Download build 878,
> http://support.microsoft.com/default...b;en-us;838166
> Or apply SP4 for SQL Server. If you are going to apply SP4, make sure that
> your server is not using AWE or PAE as there is a known issue with it and
> SP4. http://www.microsoft.com/sql/downloads/2000/sp4.asp and
> http://msmvps.com/epprecht/archive/2.../14/46940.aspx
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Kim" <kim@.xxx.com> wrote in message
> news:LY0ie.14211$7A2.2550@.bignews6.bellsouth.net.. .
pak
>

Process ID 65 attempting to unlock unowned resource

Process ID 65 attempting to unlock unowned resource PAG: 7:1:166448.
I am getting the above error in the event log for my website.
Can someone help me and tell me what this means?
thansk in Advance. KimHi
See if this applies:
http://support.microsoft.com/?kbid=814654
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kim" <kim@.xxx.com> wrote in message
news:ZW_he.25101$0i3.23178@.bignews3.bellsouth.net...
> Process ID 65 attempting to unlock unowned resource PAG: 7:1:166448.
> I am getting the above error in the event log for my website.
> Can someone help me and tell me what this means?
> thansk in Advance. Kim
>|||Hi,
It looks to be the exact problem - except we are running with service pak 4
here's the version info
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Developer
Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:%23px3ddhWFHA.2960@.TK2MSFTNGP15.phx.gbl...
> Hi
> See if this applies:
> http://support.microsoft.com/?kbid=814654
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Kim" <kim@.xxx.com> wrote in message
> news:ZW_he.25101$0i3.23178@.bignews3.bellsouth.net...
> > Process ID 65 attempting to unlock unowned resource PAG: 7:1:166448.
> >
> > I am getting the above error in the event log for my website.
> > Can someone help me and tell me what this means?
> >
> > thansk in Advance. Kim
> >
> >
>|||Hi
You are running Windows SP4, but SQL Server SP3 (8.00.760)
The problem was fixed in build 765 which was after SP3.
You can do one of the following:
Download the Security Hotfix Rollup that will take you build to 818
(http://www.microsoft.com/downloads/details.aspx?FamilyID=9814ae9d-bd44-40c5-add3-b8c99618e68d&displaylang=en)
Download build 878,
http://support.microsoft.com/default.aspx?scid=kb;en-us;838166
Or apply SP4 for SQL Server. If you are going to apply SP4, make sure that
your server is not using AWE or PAE as there is a known issue with it and
SP4. http://www.microsoft.com/sql/downloads/2000/sp4.asp and
http://msmvps.com/epprecht/archive/2005/05/14/46940.aspx
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kim" <kim@.xxx.com> wrote in message
news:LY0ie.14211$7A2.2550@.bignews6.bellsouth.net...
> Hi,
> It looks to be the exact problem - except we are running with service pak
> 4
> here's the version info
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Developer
> Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:%23px3ddhWFHA.2960@.TK2MSFTNGP15.phx.gbl...
>> Hi
>> See if this applies:
>> http://support.microsoft.com/?kbid=814654
>> Regards
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> IM: mike@.epprecht.net
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>> "Kim" <kim@.xxx.com> wrote in message
>> news:ZW_he.25101$0i3.23178@.bignews3.bellsouth.net...
>> > Process ID 65 attempting to unlock unowned resource PAG: 7:1:166448.
>> >
>> > I am getting the above error in the event log for my website.
>> > Can someone help me and tell me what this means?
>> >
>> > thansk in Advance. Kim
>> >
>> >
>>
>|||Hi,
Thanks for your help.
I will pass this on to the guy who will do the updates.
Kim
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:eoxzWthWFHA.2976@.TK2MSFTNGP10.phx.gbl...
> Hi
> You are running Windows SP4, but SQL Server SP3 (8.00.760)
> The problem was fixed in build 765 which was after SP3.
> You can do one of the following:
> Download the Security Hotfix Rollup that will take you build to 818
>
(http://www.microsoft.com/downloads/details.aspx?FamilyID=9814ae9d-bd44-40c5
-add3-b8c99618e68d&displaylang=en)
> Download build 878,
> http://support.microsoft.com/default.aspx?scid=kb;en-us;838166
> Or apply SP4 for SQL Server. If you are going to apply SP4, make sure that
> your server is not using AWE or PAE as there is a known issue with it and
> SP4. http://www.microsoft.com/sql/downloads/2000/sp4.asp and
> http://msmvps.com/epprecht/archive/2005/05/14/46940.aspx
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Kim" <kim@.xxx.com> wrote in message
> news:LY0ie.14211$7A2.2550@.bignews6.bellsouth.net...
> > Hi,
> > It looks to be the exact problem - except we are running with service
pak
> > 4
> > here's the version info
> >
> > Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> > Copyright (c) 1988-2003 Microsoft Corporation Developer
> > Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
> >
> >
> > "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> > news:%23px3ddhWFHA.2960@.TK2MSFTNGP15.phx.gbl...
> >> Hi
> >>
> >> See if this applies:
> >>
> >> http://support.microsoft.com/?kbid=814654
> >>
> >> Regards
> >> --
> >> Mike Epprecht, Microsoft SQL Server MVP
> >> Zurich, Switzerland
> >>
> >> IM: mike@.epprecht.net
> >>
> >> MVP Program: http://www.microsoft.com/mvp
> >>
> >> Blog: http://www.msmvps.com/epprecht/
> >>
> >> "Kim" <kim@.xxx.com> wrote in message
> >> news:ZW_he.25101$0i3.23178@.bignews3.bellsouth.net...
> >> > Process ID 65 attempting to unlock unowned resource PAG: 7:1:166448.
> >> >
> >> > I am getting the above error in the event log for my website.
> >> > Can someone help me and tell me what this means?
> >> >
> >> > thansk in Advance. Kim
> >> >
> >> >
> >>
> >>
> >
> >
>

Process ID 65 attempting to unlock unowned resource

Process ID 65 attempting to unlock unowned resource PAG: 7:1:166448.
I am getting the above error in the event log for my website.
Can someone help me and tell me what this means?
thansk in Advance. KimHi
See if this applies:
http://support.microsoft.com/?kbid=814654
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kim" <kim@.xxx.com> wrote in message
news:ZW_he.25101$0i3.23178@.bignews3.bellsouth.net...
> Process ID 65 attempting to unlock unowned resource PAG: 7:1:166448.
> I am getting the above error in the event log for my website.
> Can someone help me and tell me what this means?
> thansk in Advance. Kim
>|||Hi,
It looks to be the exact problem - except we are running with service pak 4
here's the version info
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Developer
Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:%23px3ddhWFHA.2960@.TK2MSFTNGP15.phx.gbl...
> Hi
> See if this applies:
> http://support.microsoft.com/?kbid=814654
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Kim" <kim@.xxx.com> wrote in message
> news:ZW_he.25101$0i3.23178@.bignews3.bellsouth.net...
>|||Hi
You are running Windows SP4, but SQL Server SP3 (8.00.760)
The problem was fixed in build 765 which was after SP3.
You can do one of the following:
Download the Security Hotfix Rollup that will take you build to 818
(http://www.microsoft.com/downloads/...&displaylang=en)
Download build 878,
http://support.microsoft.com/defaul...kb;en-us;838166
Or apply SP4 for SQL Server. If you are going to apply SP4, make sure that
your server is not using AWE or PAE as there is a known issue with it and
SP4. http://www.microsoft.com/sql/downloads/2000/sp4.asp and
http://msmvps.com/epprecht/archive/...5/14/46940.aspx
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kim" <kim@.xxx.com> wrote in message
news:LY0ie.14211$7A2.2550@.bignews6.bellsouth.net...
> Hi,
> It looks to be the exact problem - except we are running with service pak
> 4
> here's the version info
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Developer
> Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:%23px3ddhWFHA.2960@.TK2MSFTNGP15.phx.gbl...
>|||Hi,
Thanks for your help.
I will pass this on to the guy who will do the updates.
Kim
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:eoxzWthWFHA.2976@.TK2MSFTNGP10.phx.gbl...
> Hi
> You are running Windows SP4, but SQL Server SP3 (8.00.760)
> The problem was fixed in build 765 which was after SP3.
> You can do one of the following:
> Download the Security Hotfix Rollup that will take you build to 818
>
(http://www.microsoft.com/downloads/...4ae9d-bd44-40c5
-add3-b8c99618e68d&displaylang=en)
> Download build 878,
> http://support.microsoft.com/defaul...kb;en-us;838166
> Or apply SP4 for SQL Server. If you are going to apply SP4, make sure that
> your server is not using AWE or PAE as there is a known issue with it and
> SP4. http://www.microsoft.com/sql/downloads/2000/sp4.asp and
> http://msmvps.com/epprecht/archive/...5/14/46940.aspx
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Kim" <kim@.xxx.com> wrote in message
> news:LY0ie.14211$7A2.2550@.bignews6.bellsouth.net...
pak[vbcol=seagreen]
>