check sql licence: version

Showing posts with label version. Show all posts

Tuesday, March 27, 2012

Cleanup Task / xp_delete_file

Hello together,
I found some posts but not really a solution. Environment: SQL 2005 EE, SP1,
english version but german regional settings
The following code does nothing in the file system, but allways states
success:
EXECUTE master.dbo.xp_delete_file 0,N'D:\test\',N'.bak',N'06/03/2006 15:06:29'
nor does it work with 'bak" ,'trn, '*.trn' or '*.*' or the seeting to
include subfolders.
Any ideas ?
MichaelOne problem is that xp_delete_file belongs to the sys schema
not the dbo schema.
-Sue
On Tue, 6 Jun 2006 06:17:01 -0700, Michael Roedeske
<MichaelRoedeske@.discussions.microsoft.com> wrote:
>Hello together,
>I found some posts but not really a solution. Environment: SQL 2005 EE, SP1,
>english version but german regional settings
>The following code does nothing in the file system, but allways states
>success:
>EXECUTE master.dbo.xp_delete_file 0,N'D:\test\',N'.bak',N'06/03/2006 15:06:29'
>nor does it work with 'bak" ,'trn, '*.trn' or '*.*' or the seeting to
>include subfolders.
>Any ideas ?
>Michael
>|||Dear Sue,
even when I call the sp with the sys schema it happes nothing in the
filesystem.
Any other idea?
Regards
Michael
"Sue Hoegemeier" wrote:
> One problem is that xp_delete_file belongs to the sys schema
> not the dbo schema.
> -Sue
> On Tue, 6 Jun 2006 06:17:01 -0700, Michael Roedeske
> <MichaelRoedeske@.discussions.microsoft.com> wrote:
> >Hello together,
> >
> >I found some posts but not really a solution. Environment: SQL 2005 EE, SP1,
> >english version but german regional settings
> >
> >The following code does nothing in the file system, but allways states
> >success:
> >
> >EXECUTE master.dbo.xp_delete_file 0,N'D:\test\',N'.bak',N'06/03/2006 15:06:29'
> >
> >nor does it work with 'bak" ,'trn, '*.trn' or '*.*' or the seeting to
> >include subfolders.
> >
> >Any ideas ?
> >
> >Michael
> >
>|||Others have had the same issue - and others do not. I
haven't seen anyone post what solved the issue.
Try removing the dot from the extension - for example have
it list as just BAK without the dot before BAK. Make sure
the extension is exactly what you are using for your
backups.
It was suppose to be fixed in SP1 but you may also want to
try creating a cleanup task for each subdirectory.
People sometimes spend too much time troubleshooting
maintenance plans when they can just write scripts that have
more flexibility in less time then they spend addressing
maintenance plan issue.
-Sue
On Wed, 7 Jun 2006 01:06:02 -0700, Michael Roedeske
<MichaelRoedeske@.discussions.microsoft.com> wrote:
>Dear Sue,
>even when I call the sp with the sys schema it happes nothing in the
>filesystem.
>Any other idea?
>Regards
>Michael
>"Sue Hoegemeier" wrote:
>> One problem is that xp_delete_file belongs to the sys schema
>> not the dbo schema.
>> -Sue
>> On Tue, 6 Jun 2006 06:17:01 -0700, Michael Roedeske
>> <MichaelRoedeske@.discussions.microsoft.com> wrote:
>> >Hello together,
>> >
>> >I found some posts but not really a solution. Environment: SQL 2005 EE, SP1,
>> >english version but german regional settings
>> >
>> >The following code does nothing in the file system, but allways states
>> >success:
>> >
>> >EXECUTE master.dbo.xp_delete_file 0,N'D:\test\',N'.bak',N'06/03/2006 15:06:29'
>> >
>> >nor does it work with 'bak" ,'trn, '*.trn' or '*.*' or the seeting to
>> >include subfolders.
>> >
>> >Any ideas ?
>> >
>> >Michael
>> >
>>

Sunday, March 25, 2012

Cleaning up goldmine Data

Hi,
We are running version 6.5 of Goldmine, which I am migrating to CRM
3.0 - I used access to get the data into SQL, but am now stuck with a
Last Name Column and a Name Column. To get the data into CRM Server
(which the boss is very keen to have done ASAP) I need to have First
Name and Last Name.
Is there an easy (!?) way to get the SQL server to remove the last
name data from name data? For example as it stands at the moment I
would have two cells:
Last Name: Smith
Name: John Smith
What I want to end up with is:
First Name: John
Last Name: Smith
Any suggestions gratefully received!
Many thanks
BlairIf there are only ever two names (one first name followed by one last name,
separated by a space or other distinct charactere) you can simply use
SUBSTRING and CHARINDEX (maybe even PATINDEX). Books Online has several
examples.
ML
--
Matija Lah, SQL Server MVP
http://milambda.blogspot.com/

Cleaning up goldmine Data

Hi,
We are running version 6.5 of Goldmine, which I am migrating to CRM
3.0 - I used access to get the data into SQL, but am now stuck with a
Last Name Column and a Name Column. To get the data into CRM Server
(which the boss is very keen to have done ASAP) I need to have First
Name and Last Name.
Is there an easy (!?) way to get the SQL server to remove the last
name data from name data? For example as it stands at the moment I
would have two cells:
Last Name: Smith
Name: John Smith
What I want to end up with is:
First Name: John
Last Name: Smith
Any suggestions gratefully received!
Many thanks
Blair
If there are only ever two names (one first name followed by one last name,
separated by a space or other distinct charactere) you can simply use
SUBSTRING and CHARINDEX (maybe even PATINDEX). Books Online has several
examples.
ML
Matija Lah, SQL Server MVP
http://milambda.blogspot.com/

Cleaning up goldmine Data

Hi,
We are running version 6.5 of Goldmine, which I am migrating to CRM
3.0 - I used access to get the data into SQL, but am now stuck with a
Last Name Column and a Name Column. To get the data into CRM Server
(which the boss is very keen to have done ASAP) I need to have First
Name and Last Name.
Is there an easy (!?) way to get the SQL server to remove the last
name data from name data? For example as it stands at the moment I
would have two cells:
Last Name: Smith
Name: John Smith
What I want to end up with is:
First Name: John
Last Name: Smith
Any suggestions gratefully received!
Many thanks
BlairIf there are only ever two names (one first name followed by one last name,
separated by a space or other distinct charactere) you can simply use
SUBSTRING and CHARINDEX (maybe even PATINDEX). Books Online has several
examples.
ML
Matija Lah, SQL Server MVP
http://milambda.blogspot.com/

Sunday, March 11, 2012

Chinese garbled in MSSQL2000 - by ASP

Hi experts,

Here I got some problems with my application. (ASP & English Version SQL Server 2000)

As we are using English MSSQL Server 2000, we got some new functions and we have to facilitate support of Chinese characters in the DB. I have set the collation for those Chinese fields already and those queries or Stored Procs for Chinese are working fine, ONLY if I execute them in Enterprise Manager. Chinese characters can be displayed in the relevant tables.

However here comes the big problem and I got really frustrated. As we will provide user interface in ASP pages, we 'll let users to insert the information which will be sent to the DB. If there's Chinese characters in the query string, the Chinese characters added in the DB would be garbled.

e.g. EXECUTE proc_TestChinese 'XYZ', 'test123' (assume XYZ be those Chinese words)

I am wondering if there's any way I can solve this problem. Should I add special handling for these Chinese words? I have set the ASP pages in UTF-8 or Big5 encoding but it doesn't help. Hope you experts can show me the way out of the mess. Thanks in advance!

Manfred

Is your input variabl for the stored procedure a NVARCHAR or any other unicode data type, if not the data will be converted, leading to the problems you described. if you are fine on the database side you should consider posting some code in here which is used for getting the data in the database using ASP Code.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi Jens,

For that particular field for storing Chinese characters, I have set it as nvarchar already with collation settting as Chinese_Taiwan_Stroke_BIN. Here below is the Stored Procedure for testing.

Thanks in advance!

Manfred

to insert the Chinese characters for Germany: 德國 (德國)

use N'xxxx' for nvarchar

EXECUTE proc_TestChinese N'德國', 'Germany'

CREATE Procedure dbo.proc_TestChinese

@.chineseCharacters nvarchar(20),
@.Description varchar(50)

AS
BEGIN

INSERT INTO dbo.tblTestChinese
VALUES(@.chineseCharacters, @.Description)

END
GO

After the SP is executed, the table would shown as ?w°ê for those Chinese characters.

If I have a html file, see http://www.neocollage.com/de.htm . If you change the encoding to Western European then you 'll see the garbled text as in the DB.

Wednesday, March 7, 2012

Checksum Transformation

An updated version of the Checksum Transformation has finally made it out into the big wide world.

Checksum Transformation
(http://www.sqlis.com/default.aspx?21)Any details on how "unique" a checksum value is?

The inbuilt SQL Server CHECKSUM() function seems to have a pretty horrible collision rate due to being only a INT. It's not very useful in determining unique rows amongst anything more than a small handful of rows.|||I have no real numbers on how unique it is, only my testing, which seemed rather good. It uses the .Net Hash function (C#), and the internals of that are not documented.

Feel free to try it.

Using an Int makes it easier to combine multiple columns, where as most other methods would produce a very large value, or just not be capable of handling multiple values.

Darren

Sunday, February 19, 2012

checking if no record is returned

hi,

I basically want the .net version of rs.eof
does anyone know what the code would be using the execute scalar method?

Thanks>>does anyone know what the code would be using the execute scalar method?

executeScalar returns only one record. so theres no such thing as EOF. you are prbly talking of datareader...you just loop through the datareader using


while dr.read()
 ...
end while

if you want more info, you need to give us more details on what xactly it is that you are trying to do.

hth|||or,


if(dr.HasRows)
{
 while(dr.read())
 {
 // Read some stuff
 }
}
else
{
 // no results were found
}

Sunday, February 12, 2012

check version of sql 2005

how do i check whether i have installed 64 bit /32 bit sql server 2005... if i see Program files and Program files (x86) directory can i be sure...

one more query..Is windows 2003 enterprise edition 64 bit Itanium based operating systems

Thanks in advance

Is this really a SSIS question or the SQL engine?

The standard SELECT/PRINT @.@.VERSION command works here for the SQL engine, just look in the output for x64 vs x86, or Itanium I presume, but cannot confirm, e.g.

Microsoft SQL Server 2005 - 9.00.2153.00 (X64)
Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit)
on Windows NT 5.2 (Build 3790: Service Pack 1)

The presence of the Program Files (x86) directory means you are running on a 64-bit OS with WOW support. The 64-bit applications are installed in the alternative Program Files, so the presence of SQL in there would indicate you have a 64-bit install of SQL as well.

Windows 2003 Enterprise Edition comes in Itanium, x64 and x86 flavours.

|||

Is there a mapping table available between @.@.version string and the SQL Server 2005?

For example,

SQL Server 2005 RTM x86 (32-bit) Enterprise Edition --> @.@.version=?

SQL Server 2005 RTM x64 (32-bit) Enterprise Edition --> @.@.version =?

SQL Server 2005 RTM IA64 (64-bit) Enterprise Edition -->@.@.version=?

SQL Server 2005 with SP1 (32-bit) --> @.@.version=?

etc, etc.

I am particularly interested in the build number of SP1 vs. RTM so that I can build a process to check if SP1 has been deployed successfully or not.

Thanks

Sean

|||The "current" release with all the hot fixes is 9.00.2153. If you version is other, you need updates.

See: http://support.microsoft.com/kb/321185|||

SQL Server Version Database
(http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx)

The versions will also be included in any KB that accompanies a service pack or hotfix, for the latter at a file level as well, since not all fixes change the @.@.version result.

The edition is not considered part of the version (build number), but is included in the @.@.version result.

For SSIS, there are some more notes here, as off course you may have patched SSIS independently of the engine, or may not even have the engine installed-

Service Pack Versions
(http://wiki.sqlis.com/default.aspx/SQLISWiki/ServicePackVersions.html)

Check version of SQL 2000 w/ select @@version

Can anybody tell me when i complete the sp4 upgrade to my sql server
2000 why when I type "select @.@.version" under sql query analyzer it
doesn't releft latest upgrade to sevice pack 4?
ie. it still shows Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug
2000 00:57:48
Any reply to help would be much appreciated... email:
mlajoinie@.gmail.com
-thanksThat is rtm. Better reapply the sp again.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"frizzzdog" <mlajoinie@.gmail.com> wrote in message
news:1159588073.880553.264310@.m73g2000cwd.googlegroups.com...
> Can anybody tell me when i complete the sp4 upgrade to my sql server
> 2000 why when I type "select @.@.version" under sql query analyzer it
> doesn't releft latest upgrade to sevice pack 4?
> ie. it still shows Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug
> 2000 00:57:48
> Any reply to help would be much appreciated... email:
> mlajoinie@.gmail.com
> -thanks
>|||Thanks, but I have reapplied this sp4 with same results, also tried it
on a sql 2000 dvlp ed. on xp with same results. I read something about
having the services stopped prior to running the service pack so tried
that too with same results after the select @.@.version command. Are
there any cmd lines to force the sp upgrade?
frizzzdog wrote:
> Can anybody tell me when i complete the sp4 upgrade to my sql server
> 2000 why when I type "select @.@.version" under sql query analyzer it
> doesn't releft latest upgrade to sevice pack 4?
> ie. it still shows Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug
> 2000 00:57:48
> Any reply to help would be much appreciated... email:
> mlajoinie@.gmail.com
> -thanks|||Hi
Have you extracted the service pack and then run the upgrade or just
extracted it?
John
"frizzzdog" wrote:
> Thanks, but I have reapplied this sp4 with same results, also tried it
> on a sql 2000 dvlp ed. on xp with same results. I read something about
> having the services stopped prior to running the service pack so tried
> that too with same results after the select @.@.version command. Are
> there any cmd lines to force the sp upgrade?
> frizzzdog wrote:
> > Can anybody tell me when i complete the sp4 upgrade to my sql server
> > 2000 why when I type "select @.@.version" under sql query analyzer it
> > doesn't releft latest upgrade to sevice pack 4?
> > ie. it still shows Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug
> > 2000 00:57:48
> > Any reply to help would be much appreciated... email:
> > mlajoinie@.gmail.com
> > -thanks
>|||John,
I extracted the service pack then ran it from a saved folder with same
reszults from sql query. Read somewhere that the services must stopped
when running the service pack but only saw it once. Any more thoughts -
same results from the query...
Marc
John Bell wrote:
> Hi
> Have you extracted the service pack and then run the upgrade or just
> extracted it?
> John
> "frizzzdog" wrote:
> > Thanks, but I have reapplied this sp4 with same results, also tried it
> > on a sql 2000 dvlp ed. on xp with same results. I read something about
> > having the services stopped prior to running the service pack so tried
> > that too with same results after the select @.@.version command. Are
> > there any cmd lines to force the sp upgrade?
> >
> > frizzzdog wrote:
> > > Can anybody tell me when i complete the sp4 upgrade to my sql server
> > > 2000 why when I type "select @.@.version" under sql query analyzer it
> > > doesn't releft latest upgrade to sevice pack 4?
> > > ie. it still shows Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug
> > > 2000 00:57:48
> > > Any reply to help would be much appreciated... email:
> > > mlajoinie@.gmail.com
> > > -thanks
> >
> >|||Do you have multiple SQL 2000 instances installed? Each must be upgraded
independently.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"frizzzdog" <mlajoinie@.gmail.com> wrote in message
news:1159637870.608584.51190@.m73g2000cwd.googlegroups.com...
> John,
> I extracted the service pack then ran it from a saved folder with same
> reszults from sql query. Read somewhere that the services must stopped
> when running the service pack but only saw it once. Any more thoughts -
> same results from the query...
> Marc
> John Bell wrote:
>> Hi
>> Have you extracted the service pack and then run the upgrade or just
>> extracted it?
>> John
>> "frizzzdog" wrote:
>> > Thanks, but I have reapplied this sp4 with same results, also tried it
>> > on a sql 2000 dvlp ed. on xp with same results. I read something about
>> > having the services stopped prior to running the service pack so tried
>> > that too with same results after the select @.@.version command. Are
>> > there any cmd lines to force the sp upgrade?
>> >
>> > frizzzdog wrote:
>> > > Can anybody tell me when i complete the sp4 upgrade to my sql server
>> > > 2000 why when I type "select @.@.version" under sql query analyzer it
>> > > doesn't releft latest upgrade to sevice pack 4?
>> > > ie. it still shows Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
>> > > Aug
>> > > 2000 00:57:48
>> > > Any reply to help would be much appreciated... email:
>> > > mlajoinie@.gmail.com
>> > > -thanks
>> >
>> >
>|||Have you tried:
SELECT SERVERPROPERTY('productversion') Version,
SERVERPROPERTY ('productlevel') Level,
SERVERPROPERTY ('edition') Edition,
SERVERPROPERTY ('LicenseType') LicenseType,
SERVERPROPERTY ('Engine Edition') EngineEdition,
SERVERPROPERTY ('InstanceName') InstanceName,
SERVERPROPERTY ('IsClustered') IsClustered,
SERVERPROPERTY ('IsFullTextInstalled') IsFullTextInstalled,
SERVERPROPERTY ('IsIntegratedSecurityOnly') IsIntegratedSecurityOnly,
SERVERPROPERTY ('IsSingleUser') IsSingleUser,
SERVERPROPERTY ('IsSyncWithBackup') IsSyncWithBackup,
SERVERPROPERTY ('MachineName') MachineName,
SERVERPROPERTY ('ProcessID') ProcessID,
SERVERPROPERTY ('ServerName') ServerName|||Dan, under Microsoft SQL Server folder, isn't this where I'd see my
named instances? Running straight SQL Server 2000, not MSDE, if that
helps. When I run, the SP3 package save and extract (sql2ksp3.exe then
sql2kasp.exe are run it afterwards), I still get the RTM return value -
not anything with reflected SP3 in return. Can I integrate SP3 into
bart's PE CD with SQL 2000 so that when I reinstall, it'll extract and
install SP3 ?
thanks, Marc
Dan Guzman wrote:
> Do you have multiple SQL 2000 instances installed? Each must be upgraded
> independently.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "frizzzdog" <mlajoinie@.gmail.com> wrote in message
> news:1159637870.608584.51190@.m73g2000cwd.googlegroups.com...
> > John,
> >
> > I extracted the service pack then ran it from a saved folder with same
> > reszults from sql query. Read somewhere that the services must stopped
> > when running the service pack but only saw it once. Any more thoughts -
> > same results from the query...
> >
> > Marc
> >
> > John Bell wrote:
> >> Hi
> >>
> >> Have you extracted the service pack and then run the upgrade or just
> >> extracted it?
> >>
> >> John
> >>
> >> "frizzzdog" wrote:
> >>
> >> > Thanks, but I have reapplied this sp4 with same results, also tried it
> >> > on a sql 2000 dvlp ed. on xp with same results. I read something about
> >> > having the services stopped prior to running the service pack so tried
> >> > that too with same results after the select @.@.version command. Are
> >> > there any cmd lines to force the sp upgrade?
> >> >
> >> > frizzzdog wrote:
> >> > > Can anybody tell me when i complete the sp4 upgrade to my sql server
> >> > > 2000 why when I type "select @.@.version" under sql query analyzer it
> >> > > doesn't releft latest upgrade to sevice pack 4?
> >> > > ie. it still shows Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
> >> > > Aug
> >> > > 2000 00:57:48
> >> > > Any reply to help would be much appreciated... email:
> >> > > mlajoinie@.gmail.com
> >> > > -thanks
> >> >
> >> >
> >|||> Dan, under Microsoft SQL Server folder, isn't this where I'd see my
> named instances?
Yes, but only if the default installation location(s) was chosen. You can
see all installed instances from Service Manager or under the registry key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server.
> When I run, the SP3 package save and extract (sql2ksp3.exe then
> sql2kasp.exe are run it afterwards), I still get the RTM return value -
> not anything with reflected SP3 in return.
Just to be clear, did you run setup.bat from the sql2ksp3 folder? The
sql2ksp3 setup will prompt you for the target instance after the EULA
dialog. Also, be sure you are connecting to that same instance when you
verify the installation. Personally, I prefer to use SELECT
SERVERPROPERTY('ProductLevel') so I don't have to remember the build
numbers.
The AS service pack (sql2kasp.exe) isn't related to the database engine
version. Also, your original post said SP4 but you now mention SP3.
Service packs are cumulative so you don't need to install both.
> Can I integrate SP3 into
> bart's PE CD with SQL 2000 so that when I reinstall, it'll extract and
> install SP3 ?
Sorry, but I know nothing about bart's PE CD. Maybe someone else can jump
in about that.
Hope this helps.
Dan Guzman
SQL Server MVP
"frizzzdog" <mlajoinie@.gmail.com> wrote in message
news:1159664323.042983.24610@.k70g2000cwa.googlegroups.com...
> Dan, under Microsoft SQL Server folder, isn't this where I'd see my
> named instances? Running straight SQL Server 2000, not MSDE, if that
> helps. When I run, the SP3 package save and extract (sql2ksp3.exe then
> sql2kasp.exe are run it afterwards), I still get the RTM return value -
> not anything with reflected SP3 in return. Can I integrate SP3 into
> bart's PE CD with SQL 2000 so that when I reinstall, it'll extract and
> install SP3 ?
> thanks, Marc
> Dan Guzman wrote:
>> Do you have multiple SQL 2000 instances installed? Each must be upgraded
>> independently.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "frizzzdog" <mlajoinie@.gmail.com> wrote in message
>> news:1159637870.608584.51190@.m73g2000cwd.googlegroups.com...
>> > John,
>> >
>> > I extracted the service pack then ran it from a saved folder with same
>> > reszults from sql query. Read somewhere that the services must stopped
>> > when running the service pack but only saw it once. Any more thoughts -
>> > same results from the query...
>> >
>> > Marc
>> >
>> > John Bell wrote:
>> >> Hi
>> >>
>> >> Have you extracted the service pack and then run the upgrade or just
>> >> extracted it?
>> >>
>> >> John
>> >>
>> >> "frizzzdog" wrote:
>> >>
>> >> > Thanks, but I have reapplied this sp4 with same results, also tried
>> >> > it
>> >> > on a sql 2000 dvlp ed. on xp with same results. I read something
>> >> > about
>> >> > having the services stopped prior to running the service pack so
>> >> > tried
>> >> > that too with same results after the select @.@.version command. Are
>> >> > there any cmd lines to force the sp upgrade?
>> >> >
>> >> > frizzzdog wrote:
>> >> > > Can anybody tell me when i complete the sp4 upgrade to my sql
>> >> > > server
>> >> > > 2000 why when I type "select @.@.version" under sql query analyzer
>> >> > > it
>> >> > > doesn't releft latest upgrade to sevice pack 4?
>> >> > > ie. it still shows Microsoft SQL Server 2000 - 8.00.194 (Intel
>> >> > > X86)
>> >> > > Aug
>> >> > > 2000 00:57:48
>> >> > > Any reply to help would be much appreciated... email:
>> >> > > mlajoinie@.gmail.com
>> >> > > -thanks
>> >> >
>> >> >
>> >
>|||Dan Guzman wrote:
> > Dan, under Microsoft SQL Server folder, isn't this where I'd see my
> > named instances?
> Yes, but only if the default installation location(s) was chosen. You can
> see all installed instances from Service Manager or under the registry key
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server.
> > When I run, the SP3 package save and extract (sql2ksp3.exe then
> > sql2kasp.exe are run it afterwards), I still get the RTM return value -
> > not anything with reflected SP3 in return.
> Just to be clear, did you run setup.bat from the sql2ksp3 folder? The
> sql2ksp3 setup will prompt you for the target instance after the EULA
> dialog. Also, be sure you are connecting to that same instance when you
> verify the installation. Personally, I prefer to use SELECT
> SERVERPROPERTY('ProductLevel') so I don't have to remember the build
> numbers.
> The AS service pack (sql2kasp.exe) isn't related to the database engine
> version. Also, your original post said SP4 but you now mention SP3.
> Service packs are cumulative so you don't need to install both.
> > Can I integrate SP3 into
> > bart's PE CD with SQL 2000 so that when I reinstall, it'll extract and
> > install SP3 ?
> Sorry, but I know nothing about bart's PE CD. Maybe someone else can jump
> in about that.
>
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "frizzzdog" <mlajoinie@.gmail.com> wrote in message
> news:1159664323.042983.24610@.k70g2000cwa.googlegroups.com...
> > Dan, under Microsoft SQL Server folder, isn't this where I'd see my
> > named instances? Running straight SQL Server 2000, not MSDE, if that
> > helps. When I run, the SP3 package save and extract (sql2ksp3.exe then
> > sql2kasp.exe are run it afterwards), I still get the RTM return value -
> > not anything with reflected SP3 in return. Can I integrate SP3 into
> > bart's PE CD with SQL 2000 so that when I reinstall, it'll extract and
> > install SP3 ?
> >
> > thanks, Marc
> >
> > Dan Guzman wrote:
> >> Do you have multiple SQL 2000 instances installed? Each must be upgraded
> >> independently.
> >>
> >> --
> >> Hope this helps.
> >>
> >> Dan Guzman
> >> SQL Server MVP
> >>
> >> "frizzzdog" <mlajoinie@.gmail.com> wrote in message
> >> news:1159637870.608584.51190@.m73g2000cwd.googlegroups.com...
> >> > John,
> >> >
> >> > I extracted the service pack then ran it from a saved folder with same
> >> > reszults from sql query. Read somewhere that the services must stopped
> >> > when running the service pack but only saw it once. Any more thoughts -
> >> > same results from the query...
> >> >
> >> > Marc
> >> >
> >> > John Bell wrote:
> >> >> Hi
> >> >>
> >> >> Have you extracted the service pack and then run the upgrade or just
> >> >> extracted it?
> >> >>
> >> >> John
> >> >>
> >> >> "frizzzdog" wrote:
> >> >>
> >> >> > Thanks, but I have reapplied this sp4 with same results, also tried
> >> >> > it
> >> >> > on a sql 2000 dvlp ed. on xp with same results. I read something
> >> >> > about
> >> >> > having the services stopped prior to running the service pack so
> >> >> > tried
> >> >> > that too with same results after the select @.@.version command. Are
> >> >> > there any cmd lines to force the sp upgrade?
> >> >> >
> >> >> > frizzzdog wrote:
> >> >> > > Can anybody tell me when i complete the sp4 upgrade to my sql
> >> >> > > server
> >> >> > > 2000 why when I type "select @.@.version" under sql query analyzer
> >> >> > > it
> >> >> > > doesn't releft latest upgrade to sevice pack 4?
> >> >> > > ie. it still shows Microsoft SQL Server 2000 - 8.00.194 (Intel
> >> >> > > X86)
> >> >> > > Aug
> >> >> > > 2000 00:57:48
> >> >> > > Any reply to help would be much appreciated... email:
> >> >> > > mlajoinie@.gmail.com
> >> >> > > -thanks
> >> >> >
> >> >> >
> >> >
> >|||Running setup.bat from the sql2ksp3 folder did the trick after a reboot
- and running
SELECT SERVERPROPERTY('ProductLevel') resulted in SP3 for text output -
thanks!
I think personally I was reading some other (bogus and misleading )
blogs off scroogle.org then choosing "google scraper" - this way Im not
a stat for google but rather use their engine via scroogle.org -
besides they've got some hilarious not so PC comments about big bro
google on the search engine. That is running sql2ksp.exe then
sql2kasp.exe. Sorry heard SP4 isn't for the faint of heart - this is
just a lab I'm setting up so will stick with SP3 sorry for the
confusion.. I also wonder out loud if I have an msdn subscription but
don't see office server 2007 as a download there yet do you know if the
msdn subscriber community will be privy to this release prior to final
release later this year? Thanks again, you were very helpful and onward
to laying down the tracks to Sharepoint 2003 (via a couple of vmware
workstations).
Marc
Dan Guzman wrote:
> > Dan, under Microsoft SQL Server folder, isn't this where I'd see my
> > named instances?
> Yes, but only if the default installation location(s) was chosen. You can
> see all installed instances from Service Manager or under the registry key
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server.
> > When I run, the SP3 package save and extract (sql2ksp3.exe then
> > sql2kasp.exe are run it afterwards), I still get the RTM return value -
> > not anything with reflected SP3 in return.
> Just to be clear, did you run setup.bat from the sql2ksp3 folder? The
> sql2ksp3 setup will prompt you for the target instance after the EULA
> dialog. Also, be sure you are connecting to that same instance when you
> verify the installation. Personally, I prefer to use SELECT
> SERVERPROPERTY('ProductLevel') so I don't have to remember the build
> numbers.
> The AS service pack (sql2kasp.exe) isn't related to the database engine
> version. Also, your original post said SP4 but you now mention SP3.
> Service packs are cumulative so you don't need to install both.
> > Can I integrate SP3 into
> > bart's PE CD with SQL 2000 so that when I reinstall, it'll extract and
> > install SP3 ?
> Sorry, but I know nothing about bart's PE CD. Maybe someone else can jump
> in about that.
>
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "frizzzdog" <mlajoinie@.gmail.com> wrote in message
> news:1159664323.042983.24610@.k70g2000cwa.googlegroups.com...
> > Dan, under Microsoft SQL Server folder, isn't this where I'd see my
> > named instances? Running straight SQL Server 2000, not MSDE, if that
> > helps. When I run, the SP3 package save and extract (sql2ksp3.exe then
> > sql2kasp.exe are run it afterwards), I still get the RTM return value -
> > not anything with reflected SP3 in return. Can I integrate SP3 into
> > bart's PE CD with SQL 2000 so that when I reinstall, it'll extract and
> > install SP3 ?
> >
> > thanks, Marc
> >
> > Dan Guzman wrote:
> >> Do you have multiple SQL 2000 instances installed? Each must be upgraded
> >> independently.
> >>
> >> --
> >> Hope this helps.
> >>
> >> Dan Guzman
> >> SQL Server MVP
> >>
> >> "frizzzdog" <mlajoinie@.gmail.com> wrote in message
> >> news:1159637870.608584.51190@.m73g2000cwd.googlegroups.com...
> >> > John,
> >> >
> >> > I extracted the service pack then ran it from a saved folder with same
> >> > reszults from sql query. Read somewhere that the services must stopped
> >> > when running the service pack but only saw it once. Any more thoughts -
> >> > same results from the query...
> >> >
> >> > Marc
> >> >
> >> > John Bell wrote:
> >> >> Hi
> >> >>
> >> >> Have you extracted the service pack and then run the upgrade or just
> >> >> extracted it?
> >> >>
> >> >> John
> >> >>
> >> >> "frizzzdog" wrote:
> >> >>
> >> >> > Thanks, but I have reapplied this sp4 with same results, also tried
> >> >> > it
> >> >> > on a sql 2000 dvlp ed. on xp with same results. I read something
> >> >> > about
> >> >> > having the services stopped prior to running the service pack so
> >> >> > tried
> >> >> > that too with same results after the select @.@.version command. Are
> >> >> > there any cmd lines to force the sp upgrade?
> >> >> >
> >> >> > frizzzdog wrote:
> >> >> > > Can anybody tell me when i complete the sp4 upgrade to my sql
> >> >> > > server
> >> >> > > 2000 why when I type "select @.@.version" under sql query analyzer
> >> >> > > it
> >> >> > > doesn't releft latest upgrade to sevice pack 4?
> >> >> > > ie. it still shows Microsoft SQL Server 2000 - 8.00.194 (Intel
> >> >> > > X86)
> >> >> > > Aug
> >> >> > > 2000 00:57:48
> >> >> > > Any reply to help would be much appreciated... email:
> >> >> > > mlajoinie@.gmail.com
> >> >> > > -thanks
> >> >> >
> >> >> >
> >> >
> >|||Running setup.bat from the sql2ksp3 folder did the trick after a reboot
- and running
SELECT SERVERPROPERTY('ProductLevel') resulted in SP3 for text output -
thanks!
I think personally I was reading some other (bogus and misleading )
blogs off scroogle.org then choosing "google scraper" - this way Im not
a stat for google but rather use their engine via scroogle.org -
besides they've got some hilarious not so PC comments about big bro
google on the search engine. That is running sql2ksp.exe then
sql2kasp.exe. Sorry heard SP4 isn't for the faint of heart - this is
just a lab I'm setting up so will stick with SP3 sorry for the
confusion.. I also wonder out loud if I have an msdn subscription but
don't see office server 2007 as a download there yet do you know if the
msdn subscriber community will be privy to this release prior to final
release later this year? Thanks again, you were very helpful and onward
to laying down the tracks to Sharepoint 2003 (via a couple of vmware
workstations).
Marc
Dan Guzman wrote:
> > Dan, under Microsoft SQL Server folder, isn't this where I'd see my
> > named instances?
> Yes, but only if the default installation location(s) was chosen. You can
> see all installed instances from Service Manager or under the registry key
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server.
> > When I run, the SP3 package save and extract (sql2ksp3.exe then
> > sql2kasp.exe are run it afterwards), I still get the RTM return value -
> > not anything with reflected SP3 in return.
> Just to be clear, did you run setup.bat from the sql2ksp3 folder? The
> sql2ksp3 setup will prompt you for the target instance after the EULA
> dialog. Also, be sure you are connecting to that same instance when you
> verify the installation. Personally, I prefer to use SELECT
> SERVERPROPERTY('ProductLevel') so I don't have to remember the build
> numbers.
> The AS service pack (sql2kasp.exe) isn't related to the database engine
> version. Also, your original post said SP4 but you now mention SP3.
> Service packs are cumulative so you don't need to install both.
> > Can I integrate SP3 into
> > bart's PE CD with SQL 2000 so that when I reinstall, it'll extract and
> > install SP3 ?
> Sorry, but I know nothing about bart's PE CD. Maybe someone else can jump
> in about that.
>
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "frizzzdog" <mlajoinie@.gmail.com> wrote in message
> news:1159664323.042983.24610@.k70g2000cwa.googlegroups.com...
> > Dan, under Microsoft SQL Server folder, isn't this where I'd see my
> > named instances? Running straight SQL Server 2000, not MSDE, if that
> > helps. When I run, the SP3 package save and extract (sql2ksp3.exe then
> > sql2kasp.exe are run it afterwards), I still get the RTM return value -
> > not anything with reflected SP3 in return. Can I integrate SP3 into
> > bart's PE CD with SQL 2000 so that when I reinstall, it'll extract and
> > install SP3 ?
> >
> > thanks, Marc
> >
> > Dan Guzman wrote:
> >> Do you have multiple SQL 2000 instances installed? Each must be upgraded
> >> independently.
> >>
> >> --
> >> Hope this helps.
> >>
> >> Dan Guzman
> >> SQL Server MVP
> >>
> >> "frizzzdog" <mlajoinie@.gmail.com> wrote in message
> >> news:1159637870.608584.51190@.m73g2000cwd.googlegroups.com...
> >> > John,
> >> >
> >> > I extracted the service pack then ran it from a saved folder with same
> >> > reszults from sql query. Read somewhere that the services must stopped
> >> > when running the service pack but only saw it once. Any more thoughts -
> >> > same results from the query...
> >> >
> >> > Marc
> >> >
> >> > John Bell wrote:
> >> >> Hi
> >> >>
> >> >> Have you extracted the service pack and then run the upgrade or just
> >> >> extracted it?
> >> >>
> >> >> John
> >> >>
> >> >> "frizzzdog" wrote:
> >> >>
> >> >> > Thanks, but I have reapplied this sp4 with same results, also tried
> >> >> > it
> >> >> > on a sql 2000 dvlp ed. on xp with same results. I read something
> >> >> > about
> >> >> > having the services stopped prior to running the service pack so
> >> >> > tried
> >> >> > that too with same results after the select @.@.version command. Are
> >> >> > there any cmd lines to force the sp upgrade?
> >> >> >
> >> >> > frizzzdog wrote:
> >> >> > > Can anybody tell me when i complete the sp4 upgrade to my sql
> >> >> > > server
> >> >> > > 2000 why when I type "select @.@.version" under sql query analyzer
> >> >> > > it
> >> >> > > doesn't releft latest upgrade to sevice pack 4?
> >> >> > > ie. it still shows Microsoft SQL Server 2000 - 8.00.194 (Intel
> >> >> > > X86)
> >> >> > > Aug
> >> >> > > 2000 00:57:48
> >> >> > > Any reply to help would be much appreciated... email:
> >> >> > > mlajoinie@.gmail.com
> >> >> > > -thanks
> >> >> >
> >> >> >
> >> >
> >|||Glad to see you got it installed.
> Sorry heard SP4 isn't for the faint of heart
That's a bit of an exaggeration, IMHO. We have SP4 installed on all of our
SQL 2000 servers plus the AWE hotfix
(http://support.microsoft.com/default.aspx?kbid=899761) and have had no
problems. Note that SP3 is no longer supported. See
http://support.microsoft.com/gp/lifesupsps#Windows
> I also wonder out loud if I have an msdn subscription but
> don't see office server 2007 as a download there yet do you know if the
> msdn subscriber community will be privy to this release prior to final
> release later this year?
I see the Office 2007 beta 2 downloads currently available on MSDN for
Grove, Project and Sharepoint server.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"frizzzdog" <mlajoinie@.gmail.com> wrote in message
news:1159703063.424054.269200@.m7g2000cwm.googlegroups.com...
> Running setup.bat from the sql2ksp3 folder did the trick after a reboot
> - and running
> SELECT SERVERPROPERTY('ProductLevel') resulted in SP3 for text output -
> thanks!
> I think personally I was reading some other (bogus and misleading )
> blogs off scroogle.org then choosing "google scraper" - this way Im not
> a stat for google but rather use their engine via scroogle.org -
> besides they've got some hilarious not so PC comments about big bro
> google on the search engine. That is running sql2ksp.exe then
> sql2kasp.exe. Sorry heard SP4 isn't for the faint of heart - this is
> just a lab I'm setting up so will stick with SP3 sorry for the
> confusion.. I also wonder out loud if I have an msdn subscription but
> don't see office server 2007 as a download there yet do you know if the
> msdn subscriber community will be privy to this release prior to final
> release later this year? Thanks again, you were very helpful and onward
> to laying down the tracks to Sharepoint 2003 (via a couple of vmware
> workstations).
> Marc
> Dan Guzman wrote:
>> > Dan, under Microsoft SQL Server folder, isn't this where I'd see my
>> > named instances?
>> Yes, but only if the default installation location(s) was chosen. You
>> can
>> see all installed instances from Service Manager or under the registry
>> key
>> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server.
>> > When I run, the SP3 package save and extract (sql2ksp3.exe then
>> > sql2kasp.exe are run it afterwards), I still get the RTM return value -
>> > not anything with reflected SP3 in return.
>> Just to be clear, did you run setup.bat from the sql2ksp3 folder? The
>> sql2ksp3 setup will prompt you for the target instance after the EULA
>> dialog. Also, be sure you are connecting to that same instance when you
>> verify the installation. Personally, I prefer to use SELECT
>> SERVERPROPERTY('ProductLevel') so I don't have to remember the build
>> numbers.
>> The AS service pack (sql2kasp.exe) isn't related to the database engine
>> version. Also, your original post said SP4 but you now mention SP3.
>> Service packs are cumulative so you don't need to install both.
>> > Can I integrate SP3 into
>> > bart's PE CD with SQL 2000 so that when I reinstall, it'll extract and
>> > install SP3 ?
>> Sorry, but I know nothing about bart's PE CD. Maybe someone else can
>> jump
>> in about that.
>>
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "frizzzdog" <mlajoinie@.gmail.com> wrote in message
>> news:1159664323.042983.24610@.k70g2000cwa.googlegroups.com...
>> > Dan, under Microsoft SQL Server folder, isn't this where I'd see my
>> > named instances? Running straight SQL Server 2000, not MSDE, if that
>> > helps. When I run, the SP3 package save and extract (sql2ksp3.exe then
>> > sql2kasp.exe are run it afterwards), I still get the RTM return value -
>> > not anything with reflected SP3 in return. Can I integrate SP3 into
>> > bart's PE CD with SQL 2000 so that when I reinstall, it'll extract and
>> > install SP3 ?
>> >
>> > thanks, Marc
>> >
>> > Dan Guzman wrote:
>> >> Do you have multiple SQL 2000 instances installed? Each must be
>> >> upgraded
>> >> independently.
>> >>
>> >> --
>> >> Hope this helps.
>> >>
>> >> Dan Guzman
>> >> SQL Server MVP
>> >>
>> >> "frizzzdog" <mlajoinie@.gmail.com> wrote in message
>> >> news:1159637870.608584.51190@.m73g2000cwd.googlegroups.com...
>> >> > John,
>> >> >
>> >> > I extracted the service pack then ran it from a saved folder with
>> >> > same
>> >> > reszults from sql query. Read somewhere that the services must
>> >> > stopped
>> >> > when running the service pack but only saw it once. Any more
>> >> > thoughts -
>> >> > same results from the query...
>> >> >
>> >> > Marc
>> >> >
>> >> > John Bell wrote:
>> >> >> Hi
>> >> >>
>> >> >> Have you extracted the service pack and then run the upgrade or
>> >> >> just
>> >> >> extracted it?
>> >> >>
>> >> >> John
>> >> >>
>> >> >> "frizzzdog" wrote:
>> >> >>
>> >> >> > Thanks, but I have reapplied this sp4 with same results, also
>> >> >> > tried
>> >> >> > it
>> >> >> > on a sql 2000 dvlp ed. on xp with same results. I read something
>> >> >> > about
>> >> >> > having the services stopped prior to running the service pack so
>> >> >> > tried
>> >> >> > that too with same results after the select @.@.version command.
>> >> >> > Are
>> >> >> > there any cmd lines to force the sp upgrade?
>> >> >> >
>> >> >> > frizzzdog wrote:
>> >> >> > > Can anybody tell me when i complete the sp4 upgrade to my sql
>> >> >> > > server
>> >> >> > > 2000 why when I type "select @.@.version" under sql query
>> >> >> > > analyzer
>> >> >> > > it
>> >> >> > > doesn't releft latest upgrade to sevice pack 4?
>> >> >> > > ie. it still shows Microsoft SQL Server 2000 - 8.00.194 (Intel
>> >> >> > > X86)
>> >> >> > > Aug
>> >> >> > > 2000 00:57:48
>> >> >> > > Any reply to help would be much appreciated... email:
>> >> >> > > mlajoinie@.gmail.com
>> >> >> > > -thanks
>> >> >> >
>> >> >> >
>> >> >
>> >
>

Check version of SQL 2000 w/ select @@version

Check the version of Service pack

How do I check the version of service pack installed to my
sql server...
I tried Select @.@.version
I tried select serverproperty('productlevel')
I get sp3 on the later and now I installed sp3a
still the output of select serverproperty('productlevel')
gives sp3
Please help
Thanks
Alka
Alka,
SERVERPROPERTY is returning SP3 because all the changes in SP3a are setup
related and there are no changes in the database engine.Heres a snippet from
SP3a readme file:
How to Distinguish Between SQL Server 2000 SP3 and SQL Server 2000 SP3a
To determine whether you have SQL Server 2000 SP3 or SQL Server 2000 SP3a
installed, check the version number of the Net-Library file, Ssnetlib.dll.
If the version number of this file is 2000.80.760.0, you have SQL Server
2000 SP3. If the version number of this file is 2000.80.766.0, you have SQL
Server 2000 SP3a.
Assuming that an instance was installed by using the default settings, you
can find the Ssnetlib.dll file in one of these locations:
a.. Default instance: C:\Program Files\Microsoft SQL
Server\Binn\Ssnetlib.dll
b.. Named instance: C:\Program Files\Microsoft
SQLServer\MSSQL$<InstanceName>\Binn\Ssnetlib.dll
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Alka Srivaastava" <anonymous@.discussions.microsoft.com> wrote in message
news:1d1f101c42320$fec140a0$a301280a@.phx.gbl...
> How do I check the version of service pack installed to my
> sql server...
> I tried Select @.@.version
> I tried select serverproperty('productlevel')
> I get sp3 on the later and now I installed sp3a
> still the output of select serverproperty('productlevel')
> gives sp3
> Please help
> Thanks
> Alka
|||Alka,
The build of SQL did not change from SP3 to SP3A. Check that ssnetlib.dll is
now version 2000.80.766.0 then you have SP3A. If it is 2000.80.760.0 you
have SP3.
Chris Wood
Alberta Department of Energy
CANADA
"Alka Srivaastava" <anonymous@.discussions.microsoft.com> wrote in message
news:1d1f101c42320$fec140a0$a301280a@.phx.gbl...
> How do I check the version of service pack installed to my
> sql server...
> I tried Select @.@.version
> I tried select serverproperty('productlevel')
> I get sp3 on the later and now I installed sp3a
> still the output of select serverproperty('productlevel')
> gives sp3
> Please help
> Thanks
> Alka
|||Thanks Dinesh
But my file shows version 2000.80.818.0
Please help...
Thanks
Alka
>--Original Message--
>Alka,
>SERVERPROPERTY is returning SP3 because all the changes
in SP3a are setup
>related and there are no changes in the database
engine.Heres a snippet from
>SP3a readme file:
>How to Distinguish Between SQL Server 2000 SP3 and SQL
Server 2000 SP3a
>To determine whether you have SQL Server 2000 SP3 or SQL
Server 2000 SP3a
>installed, check the version number of the Net-Library
file, Ssnetlib.dll.
>If the version number of this file is 2000.80.760.0, you
have SQL Server
>2000 SP3. If the version number of this file is
2000.80.766.0, you have SQL
>Server 2000 SP3a.
>Assuming that an instance was installed by using the
default settings, you
>can find the Ssnetlib.dll file in one of these locations:
> a.. Default instance: C:\Program Files\Microsoft SQL
>Server\Binn\Ssnetlib.dll
> b.. Named instance: C:\Program Files\Microsoft
>SQLServer\MSSQL$<InstanceName>\Binn\Ssnetlib.dl l
>
>--
>Dinesh
>SQL Server MVP
>--
>--
>SQL Server FAQ at
>http://www.tkdinesh.com
>"Alka Srivaastava" <anonymous@.discussions.microsoft.com>
wrote in message[vbcol=seagreen]
>news:1d1f101c42320$fec140a0$a301280a@.phx.gbl...
my[vbcol=seagreen]
('productlevel')
>
>.
>
|||Alka,
May be some hotfix(http://support.microsoft.com/?kbid=821688). Can you check
the registry entry
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Hotfixes\ ?If its a
hotfix, an entry will be made at this key.BTW, what is the output of select
@.@.version?
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Alka Srivastava" <anonymous@.discussions.microsoft.com> wrote in message
news:1a5a401c42325$926b1570$a601280a@.phx.gbl...[vbcol=seagreen]
> Thanks Dinesh
> But my file shows version 2000.80.818.0
> Please help...
> Thanks
> Alka
> in SP3a are setup
> engine.Heres a snippet from
> Server 2000 SP3a
> Server 2000 SP3a
> file, Ssnetlib.dll.
> have SQL Server
> 2000.80.766.0, you have SQL
> default settings, you
> wrote in message
> my
> ('productlevel')

Check the version of Service pack

How do I check the version of service pack installed to my
sql server...
I tried Select @.@.version
I tried select serverproperty('productlevel')
I get sp3 on the later and now I installed sp3a
still the output of select serverproperty('productlevel')
gives sp3
Please help
Thanks
AlkaAlka,
SERVERPROPERTY is returning SP3 because all the changes in SP3a are setup
related and there are no changes in the database engine.Heres a snippet from
SP3a readme file:
How to Distinguish Between SQL Server 2000 SP3 and SQL Server 2000 SP3a
To determine whether you have SQL Server 2000 SP3 or SQL Server 2000 SP3a
installed, check the version number of the Net-Library file, Ssnetlib.dll.
If the version number of this file is 2000.80.760.0, you have SQL Server
2000 SP3. If the version number of this file is 2000.80.766.0, you have SQL
Server 2000 SP3a.
Assuming that an instance was installed by using the default settings, you
can find the Ssnetlib.dll file in one of these locations:
a.. Default instance: C:\Program Files\Microsoft SQL
Server\Binn\Ssnetlib.dll
b.. Named instance: C:\Program Files\Microsoft
SQLServer\MSSQL$<InstanceName>\Binn\Ssnetlib.dll
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Alka Srivaastava" <anonymous@.discussions.microsoft.com> wrote in message
news:1d1f101c42320$fec140a0$a301280a@.phx
.gbl...
> How do I check the version of service pack installed to my
> sql server...
> I tried Select @.@.version
> I tried select serverproperty('productlevel')
> I get sp3 on the later and now I installed sp3a
> still the output of select serverproperty('productlevel')
> gives sp3
> Please help
> Thanks
> Alka|||Alka,
The build of SQL did not change from SP3 to SP3A. Check that ssnetlib.dll is
now version 2000.80.766.0 then you have SP3A. If it is 2000.80.760.0 you
have SP3.
Chris Wood
Alberta Department of Energy
CANADA
"Alka Srivaastava" <anonymous@.discussions.microsoft.com> wrote in message
news:1d1f101c42320$fec140a0$a301280a@.phx
.gbl...
> How do I check the version of service pack installed to my
> sql server...
> I tried Select @.@.version
> I tried select serverproperty('productlevel')
> I get sp3 on the later and now I installed sp3a
> still the output of select serverproperty('productlevel')
> gives sp3
> Please help
> Thanks
> Alka|||Thanks Dinesh
But my file shows version 2000.80.818.0
Please help...
Thanks
Alka
>--Original Message--
>Alka,
>SERVERPROPERTY is returning SP3 because all the changes
in SP3a are setup
>related and there are no changes in the database
engine.Heres a snippet from
>SP3a readme file:
>How to Distinguish Between SQL Server 2000 SP3 and SQL
Server 2000 SP3a
>To determine whether you have SQL Server 2000 SP3 or SQL
Server 2000 SP3a
>installed, check the version number of the Net-Library
file, Ssnetlib.dll.
>If the version number of this file is 2000.80.760.0, you
have SQL Server
>2000 SP3. If the version number of this file is
2000.80.766.0, you have SQL
>Server 2000 SP3a.
>Assuming that an instance was installed by using the
default settings, you
>can find the Ssnetlib.dll file in one of these locations:
> a.. Default instance: C:\Program Files\Microsoft SQL
>Server\Binn\Ssnetlib.dll
> b.. Named instance: C:\Program Files\Microsoft
>SQLServer\MSSQL$<InstanceName>\Binn\Ssnetlib.dll
>
>--
>Dinesh
>SQL Server MVP
>--
>--
>SQL Server FAQ at
>http://www.tkdinesh.com
>"Alka Srivaastava" <anonymous@.discussions.microsoft.com>
wrote in message
> news:1d1f101c42320$fec140a0$a301280a@.phx
.gbl...
my[vbcol=seagreen]
('productlevel')[vbcol=seagreen]
>
>.
>|||Alka,
May be some hotfix(http://support.microsoft.com/?kbid=821688). Can you check
the registry entry
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\Hotfixes\ ?If its a
hotfix, an entry will be made at this key.BTW, what is the output of select
@.@.version?
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Alka Srivastava" <anonymous@.discussions.microsoft.com> wrote in message
news:1a5a401c42325$926b1570$a601280a@.phx
.gbl...[vbcol=seagreen]
> Thanks Dinesh
> But my file shows version 2000.80.818.0
> Please help...
> Thanks
> Alka
> in SP3a are setup
> engine.Heres a snippet from
> Server 2000 SP3a
> Server 2000 SP3a
> file, Ssnetlib.dll.
> have SQL Server
> 2000.80.766.0, you have SQL
> default settings, you
> wrote in message
> my
> ('productlevel')

Check the version of Service pack

How do I check the version of service pack installed to my
sql server...
I tried Select @.@.version
I tried select serverproperty('productlevel')
I get sp3 on the later and now I installed sp3a
still the output of select serverproperty('productlevel')
gives sp3
Please help
Thanks
AlkaAlka,
SERVERPROPERTY is returning SP3 because all the changes in SP3a are setup
related and there are no changes in the database engine.Heres a snippet from
SP3a readme file:
How to Distinguish Between SQL Server 2000 SP3 and SQL Server 2000 SP3a
To determine whether you have SQL Server 2000 SP3 or SQL Server 2000 SP3a
installed, check the version number of the Net-Library file, Ssnetlib.dll.
If the version number of this file is 2000.80.760.0, you have SQL Server
2000 SP3. If the version number of this file is 2000.80.766.0, you have SQL
Server 2000 SP3a.
Assuming that an instance was installed by using the default settings, you
can find the Ssnetlib.dll file in one of these locations:
a.. Default instance: C:\Program Files\Microsoft SQL
Server\Binn\Ssnetlib.dll
b.. Named instance: C:\Program Files\Microsoft
SQLServer\MSSQL$<InstanceName>\Binn\Ssnetlib.dll
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Alka Srivaastava" <anonymous@.discussions.microsoft.com> wrote in message
news:1d1f101c42320$fec140a0$a301280a@.phx.gbl...
> How do I check the version of service pack installed to my
> sql server...
> I tried Select @.@.version
> I tried select serverproperty('productlevel')
> I get sp3 on the later and now I installed sp3a
> still the output of select serverproperty('productlevel')
> gives sp3
> Please help
> Thanks
> Alka|||Alka,
The build of SQL did not change from SP3 to SP3A. Check that ssnetlib.dll is
now version 2000.80.766.0 then you have SP3A. If it is 2000.80.760.0 you
have SP3.
Chris Wood
Alberta Department of Energy
CANADA
"Alka Srivaastava" <anonymous@.discussions.microsoft.com> wrote in message
news:1d1f101c42320$fec140a0$a301280a@.phx.gbl...
> How do I check the version of service pack installed to my
> sql server...
> I tried Select @.@.version
> I tried select serverproperty('productlevel')
> I get sp3 on the later and now I installed sp3a
> still the output of select serverproperty('productlevel')
> gives sp3
> Please help
> Thanks
> Alka|||Thanks Dinesh
But my file shows version 2000.80.818.0
Please help...
Thanks
Alka
>--Original Message--
>Alka,
>SERVERPROPERTY is returning SP3 because all the changes
in SP3a are setup
>related and there are no changes in the database
engine.Heres a snippet from
>SP3a readme file:
>How to Distinguish Between SQL Server 2000 SP3 and SQL
Server 2000 SP3a
>To determine whether you have SQL Server 2000 SP3 or SQL
Server 2000 SP3a
>installed, check the version number of the Net-Library
file, Ssnetlib.dll.
>If the version number of this file is 2000.80.760.0, you
have SQL Server
>2000 SP3. If the version number of this file is
2000.80.766.0, you have SQL
>Server 2000 SP3a.
>Assuming that an instance was installed by using the
default settings, you
>can find the Ssnetlib.dll file in one of these locations:
> a.. Default instance: C:\Program Files\Microsoft SQL
>Server\Binn\Ssnetlib.dll
> b.. Named instance: C:\Program Files\Microsoft
>SQLServer\MSSQL$<InstanceName>\Binn\Ssnetlib.dll
>
>--
>Dinesh
>SQL Server MVP
>--
>--
>SQL Server FAQ at
>http://www.tkdinesh.com
>"Alka Srivaastava" <anonymous@.discussions.microsoft.com>
wrote in message
>news:1d1f101c42320$fec140a0$a301280a@.phx.gbl...
>> How do I check the version of service pack installed to
my
>> sql server...
>> I tried Select @.@.version
>> I tried select serverproperty('productlevel')
>> I get sp3 on the later and now I installed sp3a
>> still the output of select serverproperty
('productlevel')
>> gives sp3
>> Please help
>> Thanks
>> Alka
>
>.
>|||Alka,
May be some hotfix(http://support.microsoft.com/?kbid=821688). Can you check
the registry entry
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Hotfixes\ ?If its a
hotfix, an entry will be made at this key.BTW, what is the output of select
@.@.version?
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Alka Srivastava" <anonymous@.discussions.microsoft.com> wrote in message
news:1a5a401c42325$926b1570$a601280a@.phx.gbl...
> Thanks Dinesh
> But my file shows version 2000.80.818.0
> Please help...
> Thanks
> Alka
> >--Original Message--
> >Alka,
> >
> >SERVERPROPERTY is returning SP3 because all the changes
> in SP3a are setup
> >related and there are no changes in the database
> engine.Heres a snippet from
> >SP3a readme file:
> >How to Distinguish Between SQL Server 2000 SP3 and SQL
> Server 2000 SP3a
> >
> >To determine whether you have SQL Server 2000 SP3 or SQL
> Server 2000 SP3a
> >installed, check the version number of the Net-Library
> file, Ssnetlib.dll.
> >If the version number of this file is 2000.80.760.0, you
> have SQL Server
> >2000 SP3. If the version number of this file is
> 2000.80.766.0, you have SQL
> >Server 2000 SP3a.
> >
> >Assuming that an instance was installed by using the
> default settings, you
> >can find the Ssnetlib.dll file in one of these locations:
> > a.. Default instance: C:\Program Files\Microsoft SQL
> >Server\Binn\Ssnetlib.dll
> > b.. Named instance: C:\Program Files\Microsoft
> >SQLServer\MSSQL$<InstanceName>\Binn\Ssnetlib.dll
> >
> >
> >--
> >Dinesh
> >SQL Server MVP
> >--
> >--
> >SQL Server FAQ at
> >http://www.tkdinesh.com
> >
> >"Alka Srivaastava" <anonymous@.discussions.microsoft.com>
> wrote in message
> >news:1d1f101c42320$fec140a0$a301280a@.phx.gbl...
> >> How do I check the version of service pack installed to
> my
> >> sql server...
> >>
> >> I tried Select @.@.version
> >> I tried select serverproperty('productlevel')
> >>
> >> I get sp3 on the later and now I installed sp3a
> >> still the output of select serverproperty
> ('productlevel')
> >> gives sp3
> >>
> >> Please help
> >>
> >> Thanks
> >> Alka
> >
> >
> >.
> >

Tuesday, March 27, 2012

Cleanup Task / xp_delete_file

Cleanup Task / xp_delete_file

Sunday, March 25, 2012

Cleaning up goldmine Data

Cleaning up goldmine Data

Cleaning up goldmine Data

Sunday, March 11, 2012

Chinese garbled in MSSQL2000 - by ASP

Wednesday, March 7, 2012

Checksum Transformation

Sunday, February 19, 2012

checking if no record is returned

Sunday, February 12, 2012

check version of sql 2005

Check version of SQL 2000 w/ select @@version

Check version of SQL 2000 w/ select @@version

Check version of SQL 2000 w/ select @@version

Check the version of Service pack

Check the version of Service pack

Check the version of Service pack

check sql licence

Blog Archive

About Me