Cleanup / Foreign key

I have an address table I set up so that I can start our address campaign.
There is a field (open entry) called Business Type that I allowed the works
to enter to describe the business type. Now that the entry is complete ,
I'm in cleanup phase. Now, my question is: I know I need to make Business
Type a foreign key and select distinct to insert them into their own table,
but should I do that before I clean up the inconsistencies or after. There
are about 2000 different business types, some are minor like - Car Sales -
Used and Car Sales _ Used. I'm creating a system that allows users to
search based on business type.
Before or after, why?Before!
Why? Do not allow bad data into the database in the first place, it is a
bitch getting it out.
Jay
<programmingcodeATjards.com> wrote in message
news:uVedQl9%23HHA.320@.TK2MSFTNGP04.phx.gbl...
>I have an address table I set up so that I can start our address campaign.
>There is a field (open entry) called Business Type that I allowed the works
>to enter to describe the business type. Now that the entry is complete ,
>I'm in cleanup phase. Now, my question is: I know I need to make Business
>Type a foreign key and select distinct to insert them into their own table,
>but should I do that before I clean up the inconsistencies or after. There
>are about 2000 different business types, some are minor like - Car Sales -
>Used and Car Sales _ Used. I'm creating a system that allows users to
>search based on business type.
> Before or after, why?
>sqlsql

cleaing up text type fields

Hello.
I have a text type field in an SQL2000 table I need to clean up. After
converting from MySQL I am finding that I have leading Tabs and when I
display the text field in an asp textbox I end up see the record
double spaced.
Any suggestion on how I can clean the field up?
Also, as I test an application I just migrated from apache/php/mysql
to iis/asp.net/sql2000 and from hardware pentium 1 with 64mb mem to
pentium 4 with 512mb I am finding the the MS solution is like 3 times
slower?
Thanks for any help or info.> I have a text type field in an SQL2000 table I need to clean up. After
> converting from MySQL I am finding that I have leading Tabs and when I
> display the text field in an asp textbox I end up see the record
> double spaced.
> Any suggestion on how I can clean the field up?
Trim it on the client before displaying it?
> Also, as I test an application I just migrated from apache/php/mysql
> to iis/asp.net/sql2000 and from hardware pentium 1 with 64mb mem to
> pentium 4 with 512mb I am finding the the MS solution is like 3 times
> slower?
We don't even have a fraction of the information required to analyze your
environment and point out potential reasons for any performance differences.|||Assuming that each record has two leading tabs, you could do something like:
DECLARE @.ptr binary(16)
SELECT @.ptr=textptr(textColumn) FROM yourTable
UPDATETEXT yourTable.textColumn @.ptr 0 2 ''
That will delete the first two characters from each record. If you need to
do more complex evaluation, you can run a cursor over the table and use
CHARINDEX to determine where the replacement(s) should be made.
<jason@.cyberpine.com> wrote in message
news:ef0a04d7.0311070754.5567591d@.posting.google.com...
> Hello.
> I have a text type field in an SQL2000 table I need to clean up. After
> converting from MySQL I am finding that I have leading Tabs and when I
> display the text field in an asp textbox I end up see the record
> double spaced.
> Any suggestion on how I can clean the field up?
> Also, as I test an application I just migrated from apache/php/mysql
> to iis/asp.net/sql2000 and from hardware pentium 1 with 64mb mem to
> pentium 4 with 512mb I am finding the the MS solution is like 3 times
> slower?
> Thanks for any help or info.|||On second thought, you will need a CURSOR - Running that code as-is will
only strip the first two characters from the last record selected.
"Adam Machanic" <amachanic@.air-worldwide.nospamallowed.com> wrote in message
news:eB#svjUpDHA.2312@.TK2MSFTNGP12.phx.gbl...
> Assuming that each record has two leading tabs, you could do something
like:
> DECLARE @.ptr binary(16)
> SELECT @.ptr=textptr(textColumn) FROM yourTable
> UPDATETEXT yourTable.textColumn @.ptr 0 2 ''
> That will delete the first two characters from each record. If you need
to
> do more complex evaluation, you can run a cursor over the table and use
> CHARINDEX to determine where the replacement(s) should be made.
> <jason@.cyberpine.com> wrote in message
> news:ef0a04d7.0311070754.5567591d@.posting.google.com...
> > Hello.
> >
> > I have a text type field in an SQL2000 table I need to clean up. After
> > converting from MySQL I am finding that I have leading Tabs and when I
> > display the text field in an asp textbox I end up see the record
> > double spaced.
> >
> > Any suggestion on how I can clean the field up?
> >
> > Also, as I test an application I just migrated from apache/php/mysql
> > to iis/asp.net/sql2000 and from hardware pentium 1 with 64mb mem to
> > pentium 4 with 512mb I am finding the the MS solution is like 3 times
> > slower?
> >
> > Thanks for any help or info.
>|||You can see this example for using replace in this case:
http://www.aspfaq.com/2445
"Adam Machanic" <amachanic@.air-worldwide.nospamallowed.com> wrote in message
news:eZxpAnUpDHA.684@.TK2MSFTNGP09.phx.gbl...
> On second thought, you will need a CURSOR - Running that code as-is will
> only strip the first two characters from the last record selected.
> "Adam Machanic" <amachanic@.air-worldwide.nospamallowed.com> wrote in
message
> news:eB#svjUpDHA.2312@.TK2MSFTNGP12.phx.gbl...
> > Assuming that each record has two leading tabs, you could do something
> like:
> >
> > DECLARE @.ptr binary(16)
> > SELECT @.ptr=textptr(textColumn) FROM yourTable
> > UPDATETEXT yourTable.textColumn @.ptr 0 2 ''
> >
> > That will delete the first two characters from each record. If you need
> to
> > do more complex evaluation, you can run a cursor over the table and use
> > CHARINDEX to determine where the replacement(s) should be made.
> >
> > <jason@.cyberpine.com> wrote in message
> > news:ef0a04d7.0311070754.5567591d@.posting.google.com...
> > > Hello.
> > >
> > > I have a text type field in an SQL2000 table I need to clean up. After
> > > converting from MySQL I am finding that I have leading Tabs and when I
> > > display the text field in an asp textbox I end up see the record
> > > double spaced.
> > >
> > > Any suggestion on how I can clean the field up?
> > >
> > > Also, as I test an application I just migrated from apache/php/mysql
> > > to iis/asp.net/sql2000 and from hardware pentium 1 with 64mb mem to
> > > pentium 4 with 512mb I am finding the the MS solution is like 3 times
> > > slower?
> > >
> > > Thanks for any help or info.
> >
> >
>|||Ahhh, nice... I didn't realize this slightly annoying caveat:
"Initially I used CHARINDEX, but that failed if the pattern was deeper than
8,000 characters into the value. PATINDEX never dies."
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:uAGRfqUpDHA.2772@.TK2MSFTNGP12.phx.gbl...
> You can see this example for using replace in this case:
> http://www.aspfaq.com/2445
>
>
> "Adam Machanic" <amachanic@.air-worldwide.nospamallowed.com> wrote in
message
> news:eZxpAnUpDHA.684@.TK2MSFTNGP09.phx.gbl...
> > On second thought, you will need a CURSOR - Running that code as-is will
> > only strip the first two characters from the last record selected.
> >
> > "Adam Machanic" <amachanic@.air-worldwide.nospamallowed.com> wrote in
> message
> > news:eB#svjUpDHA.2312@.TK2MSFTNGP12.phx.gbl...
> > > Assuming that each record has two leading tabs, you could do something
> > like:
> > >
> > > DECLARE @.ptr binary(16)
> > > SELECT @.ptr=textptr(textColumn) FROM yourTable
> > > UPDATETEXT yourTable.textColumn @.ptr 0 2 ''
> > >
> > > That will delete the first two characters from each record. If you
need
> > to
> > > do more complex evaluation, you can run a cursor over the table and
use
> > > CHARINDEX to determine where the replacement(s) should be made.
> > >
> > > <jason@.cyberpine.com> wrote in message
> > > news:ef0a04d7.0311070754.5567591d@.posting.google.com...
> > > > Hello.
> > > >
> > > > I have a text type field in an SQL2000 table I need to clean up.
After
> > > > converting from MySQL I am finding that I have leading Tabs and when
I
> > > > display the text field in an asp textbox I end up see the record
> > > > double spaced.
> > > >
> > > > Any suggestion on how I can clean the field up?
> > > >
> > > > Also, as I test an application I just migrated from apache/php/mysql
> > > > to iis/asp.net/sql2000 and from hardware pentium 1 with 64mb mem to
> > > > pentium 4 with 512mb I am finding the the MS solution is like 3
times
> > > > slower?
> > > >
> > > > Thanks for any help or info.
> > >
> > >
> >
> >
>|||It took a few practical uses before I cleaned that up. The code is a little
simpler for this specific case, because you don't have to find the index,
and you don't have to loop through... you just replace the first two
characters if they're what you think they are.
"Adam Machanic" <amachanic@.air-worldwide.nospamallowed.com> wrote in message
news:ePbcpuUpDHA.2528@.TK2MSFTNGP12.phx.gbl...
> Ahhh, nice... I didn't realize this slightly annoying caveat:
> "Initially I used CHARINDEX, but that failed if the pattern was deeper
than
> 8,000 characters into the value. PATINDEX never dies."sqlsql

Clarification on Joins

Dear friends,

Can any one clearly explain about all type of joins or any tutorials for that. please help me b'se i failed it to explain in an interview clearly

samy

Quote:

Originally Posted by samycbe

Dear friends,

Can any one clearly explain about all type of joins or any tutorials for that. please help me b'se i failed it to explain in an interview clearly

samy

These are SQL server specification.

Inner joins (the typical join operation, which uses some comparison operator like = or <>). These include equi-joins and natural joins.
Inner joins use a comparison operator to match rows from two tables based on the values in common columns from each table. For example, retrieving all rows where the student identification number is the same in both the students and courses tables.

Outer joins. Outer joins can be a left, a right, or full outer join.
Outer joins are specified with one of the following sets of keywords when they are specified in the FROM clause:

LEFT JOIN or LEFT OUTER JOIN
The result set of a left outer join includes all the rows from the left table specified in the LEFT OUTER clause, not just the ones in which the joined columns match. When a row in the left table has no matching rows in the right table, the associated result set row contains null values for all select list columns coming from the right table.

RIGHT JOIN or RIGHT OUTER JOIN.
A right outer join is the reverse of a left outer join. All rows from the right table are returned. Null values are returned for the left table any time a right table row has no matching row in the left table.

FULL JOIN or FULL OUTER JOIN.
A full outer join returns all rows in both the left and right tables. Any time a row has no match in the other table, the select list columns from the other table contain null values. When there is a match between the tables, the entire result set row contains data values from the base tables.

Cross joins.
Cross joins return all rows from the left table, each row from the left table is combined with all rows from the right table. Cross joins are also called Cartesian products.|||Thanks and Its really helpful

choosing the right datatype

It was hard to tell if this was the correct forum, but here goes:
My browser-driven Intranet App has 3 fields where users can type in a very
long description. It has a size of 5000, and is a varchar. People will
typically type in alphanumeric characters in it. (For the web-savvy, the
users types into a Textarea).
A co-worker tells me I should change the datatype from varchar to text. I
had it at varchar specifically because I understood that varchar will only
take up what disc space that it needs to. I asked him for an explanation of
why to go to text. He replied:
"There is an 8k limitation on a row when you use standard datatypes. You
have 3 columns with 5000 characters which pretty much doubles the amount of
allowed storage in a row. I'm surprised you haven't run into any problems.
Text datatypes are stored separately and allow up to 2GB."
Is this correct? Under my described scenario, which would be best?I would stick with Varchar. Varchar can hold up to 8,000 characters.
You're not storing more than 8,000 characters, so I don't see the point of
switching to a Text field. Also, if you use a text field, unless you
specify that you're storing the data "in row", it will only store a pointer
to the separate page or pages to access your string. You also can't
directly reference a text column in a WHERE clause. Unless you're storing
unusually large amount of characters (defined as 8,001+ characters) per row
in this column there's no real point to going with text.
"middletree" <middletree@.htomail.com> wrote in message
news:eDwvTxXKFHA.2688@.TK2MSFTNGP15.phx.gbl...
> It was hard to tell if this was the correct forum, but here goes:
> My browser-driven Intranet App has 3 fields where users can type in a very
> long description. It has a size of 5000, and is a varchar. People will
> typically type in alphanumeric characters in it. (For the web-savvy, the
> users types into a Textarea).
> A co-worker tells me I should change the datatype from varchar to text. I
> had it at varchar specifically because I understood that varchar will only
> take up what disc space that it needs to. I asked him for an explanation
> of
> why to go to text. He replied:
> "There is an 8k limitation on a row when you use standard datatypes. You
> have 3 columns with 5000 characters which pretty much doubles the amount
> of
> allowed storage in a row. I'm surprised you haven't run into any
> problems.
> Text datatypes are stored separately and allow up to 2GB."
> Is this correct? Under my described scenario, which would be best?
>|||He is right, but the limit for a row is 8060 and not 8k.
Example:
use northwind
go
create table t (
colA varchar(8000),
colB varchar(8000),
colC varchar(8000)
)
go
insert into t values(replicate('a', 8000), replicate('b', 8000),
replicate('c', 8000))
go
drop table t
go
Result:
Server: Msg 511, Level 16, State 1, Line 2
Cannot create a row of size 24015 which is greater than the allowable
maximum of 8060.
The statement has been terminated.
AMB
"middletree" wrote:

> It was hard to tell if this was the correct forum, but here goes:
> My browser-driven Intranet App has 3 fields where users can type in a very
> long description. It has a size of 5000, and is a varchar. People will
> typically type in alphanumeric characters in it. (For the web-savvy, the
> users types into a Textarea).
> A co-worker tells me I should change the datatype from varchar to text. I
> had it at varchar specifically because I understood that varchar will only
> take up what disc space that it needs to. I asked him for an explanation o
f
> why to go to text. He replied:
> "There is an 8k limitation on a row when you use standard datatypes. You
> have 3 columns with 5000 characters which pretty much doubles the amount o
f
> allowed storage in a row. I'm surprised you haven't run into any problems
.
> Text datatypes are stored separately and allow up to 2GB."
> Is this correct? Under my described scenario, which would be best?
>
>|||It is, generally, correct. However, there are perfomance and usage penaltie
s
for using Text datatype, that make it worthwhile t oavoid them if possible..
.
What are the three fields used for? An Alternative which MAY be worth
investigating, is putting these three fields in another table...
Assuming your existing Table has a PK called PKID,
Create Table Comments
(PKID Integer Not Null
WhichField TinyInt Not Null,
Description VarChar(5000),
CONSTRAINT Comment_PK PRIMARY KEY (PKId, WhichField)
)
-- (The WHichField column identifies which one of the web page's Description
fields this is for... 1,2, or 3)
"middletree" wrote:

> It was hard to tell if this was the correct forum, but here goes:
> My browser-driven Intranet App has 3 fields where users can type in a very
> long description. It has a size of 5000, and is a varchar. People will
> typically type in alphanumeric characters in it. (For the web-savvy, the
> users types into a Textarea).
> A co-worker tells me I should change the datatype from varchar to text. I
> had it at varchar specifically because I understood that varchar will only
> take up what disc space that it needs to. I asked him for an explanation o
f
> why to go to text. He replied:
> "There is an 8k limitation on a row when you use standard datatypes. You
> have 3 columns with 5000 characters which pretty much doubles the amount o
f
> allowed storage in a row. I'm surprised you haven't run into any problems
.
> Text datatypes are stored separately and allow up to 2GB."
> Is this correct? Under my described scenario, which would be best?
>
>|||Hey, 'tree. If it matters, "text" columns can be a pain to deal with in DW,
depending on what you're trying to do of course. The default recordset
options don't always work, you've got to watch your field order, etc.
I know it's not strictly database relevant, but I know you use DW, so it
might be relevant for you.
"middletree" <middletree@.htomail.com> wrote in message
news:eDwvTxXKFHA.2688@.TK2MSFTNGP15.phx.gbl...
> It was hard to tell if this was the correct forum, but here goes:
> My browser-driven Intranet App has 3 fields where users can type in a very
> long description. It has a size of 5000, and is a varchar. People will
> typically type in alphanumeric characters in it. (For the web-savvy, the
> users types into a Textarea).
> A co-worker tells me I should change the datatype from varchar to text. I
> had it at varchar specifically because I understood that varchar will only
> take up what disc space that it needs to. I asked him for an explanation
of
> why to go to text. He replied:
> "There is an 8k limitation on a row when you use standard datatypes. You
> have 3 columns with 5000 characters which pretty much doubles the amount
of
> allowed storage in a row. I'm surprised you haven't run into any
problems.
> Text datatypes are stored separately and allow up to 2GB."
> Is this correct? Under my described scenario, which would be best?
>|||Actually, I own DW, but tend to hand-code about 95% of my stuff. I hang out
at the DW forum to ask and answer questions about code, not DW. And to
discuss various theological and political topics ;)
Hope you haven't left the DW forums for good.
"CMBergin" <NoHarvestForYou@.NoSpam.org> wrote in message
news:OX2lEUYKFHA.436@.TK2MSFTNGP09.phx.gbl...
> Hey, 'tree. If it matters, "text" columns can be a pain to deal with in
DW,
> depending on what you're trying to do of course. The default recordset
> options don't always work, you've got to watch your field order, etc.
> I know it's not strictly database relevant, but I know you use DW, so it
> might be relevant for you.
> "middletree" <middletree@.htomail.com> wrote in message
> news:eDwvTxXKFHA.2688@.TK2MSFTNGP15.phx.gbl...
very
I
only
> of
You
> of
> problems.
>|||For a while, yes. Probably not for good though.
I'd elaborate, but the "on-topic" rules here seem quite a bit stricter.
"middletree" <middletree@.htomail.com> wrote in message
news:%23cpX5hZKFHA.572@.tk2msftngp13.phx.gbl...
> Actually, I own DW, but tend to hand-code about 95% of my stuff. I hang
out
> at the DW forum to ask and answer questions about code, not DW. And to
> discuss various theological and political topics ;)
> Hope you haven't left the DW forums for good.
>
> "CMBergin" <NoHarvestForYou@.NoSpam.org> wrote in message
> news:OX2lEUYKFHA.436@.TK2MSFTNGP09.phx.gbl...
> DW,
> very
the
text.
> I
> only
explanation
> You
amount
>

Choosing replication type

Hello!
I'm trying to put together replication for a small application that
works like this: The central database contains data that is to be
copied to several laptops. The laptops are going to be used on
inspections of real-estate all over this city. When the user is
finished with his work, he wants his data transferred/updated to the
main database. This updating only concerns a few columns in a few
tables. NOT the whole database.
I figured Snaphot Replication was a good idea, but this only work one
way - to the laptop, with the database structure and all the data.
When data is going back to the central database, snapshot replication
will only try to add rows, as it doesn't know which rows to update.
Merge Replication will update all of the data both ways, and that is
not "allowed" in this context.
Any good suggestions?
Thanx!
Dagfinn Rosnes
Use Merge replication - only replicate the tables and columns that the
laptops will be changing.
"Dagfinn Rosnes" wrote:

> Hello!
> I'm trying to put together replication for a small application that
> works like this: The central database contains data that is to be
> copied to several laptops. The laptops are going to be used on
> inspections of real-estate all over this city. When the user is
> finished with his work, he wants his data transferred/updated to the
> main database. This updating only concerns a few columns in a few
> tables. NOT the whole database.
> I figured Snaphot Replication was a good idea, but this only work one
> way - to the laptop, with the database structure and all the data.
> When data is going back to the central database, snapshot replication
> will only try to add rows, as it doesn't know which rows to update.
> Merge Replication will update all of the data both ways, and that is
> not "allowed" in this context.
> Any good suggestions?
> Thanx!
> Dagfinn Rosnes
>
|||Clarify my previous post:
Use a "one-way" merge replication
http://www.microsoft.com/sql/techinf...t/mergerep.asp
"Dagfinn Rosnes" wrote:

> Hello!
> I'm trying to put together replication for a small application that
> works like this: The central database contains data that is to be
> copied to several laptops. The laptops are going to be used on
> inspections of real-estate all over this city. When the user is
> finished with his work, he wants his data transferred/updated to the
> main database. This updating only concerns a few columns in a few
> tables. NOT the whole database.
> I figured Snaphot Replication was a good idea, but this only work one
> way - to the laptop, with the database structure and all the data.
> When data is going back to the central database, snapshot replication
> will only try to add rows, as it doesn't know which rows to update.
> Merge Replication will update all of the data both ways, and that is
> not "allowed" in this context.
> Any good suggestions?
> Thanx!
> Dagfinn Rosnes
>

Choosing Data Type

Hi ... I have question on datatype on SQL Server 2005 EE

What is a good data type for email, password, Phone Number and ISBN number?

Thanks!I'd use varchar for all of those.|||Thanks for the reply. How about phone number? isn't that suppose to beNumeric? Or Numeric just for something that is calculateable?|||

iloveny:

Thanks for the reply. How about phone number? isn't that suppose to beNumeric? Or Numeric just for something that is calculateable?

You've hit the nail on the head. Only use numeric data types for something that is calculateable. Phone numbers, ZIP codes, etc. should definitely be one of the string data types (I suggest varchar).

Chinese chars through stored procedures...

Hi,
I have a problem with my Stored Procedures...
Recently we decided to change the type of our column in our databse from
varchar to nvarchar because of new customers (chinese).
Everything works fine EXCEPT the stored procedures... When i try to pass
chinese characters for a simple SP that those a basic insert in my table, it
inserts ? instead of chinese characters...
Did i miss something obvious?
Thanks a lot!
Etienne
p.s.: you can email me at etienne_stgeorges@.hotmail.com or reply on this
newsgroup.Etienne,
Did you also change the types of the variables in the stored procedures? If
not, then you will have conversions happening.
You might also find this article useful if the international and Chinese
world are new to you:
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnsql2k/html/intlfeaturesinsqlserver2000.asp
Russell Fields
http://www.sqlpass.org/
2004 PASS Community Summit - Orlando
- The largest user-event dedicated to SQL Server!
"Etienne M. St-Georges" <nospam.etienne@.emstg.com> wrote in message
news:hQqvb.16446$iT4.2055861@.news20.bellglobal.com...
> Hi,
> I have a problem with my Stored Procedures...
> Recently we decided to change the type of our column in our databse from
> varchar to nvarchar because of new customers (chinese).
> Everything works fine EXCEPT the stored procedures... When i try to pass
> chinese characters for a simple SP that those a basic insert in my table,
it
> inserts ? instead of chinese characters...
> Did i miss something obvious?
> Thanks a lot!
> Etienne
> p.s.: you can email me at etienne_stgeorges@.hotmail.com or reply on this
> newsgroup.
>|||Hi Russell,
Yep, changed the types of variables too...
I'm really confused, nowhere on the web i could find somebody with the same
problem as me...
What is strange is that with my access application, i can write, update and
select (of course!) any field that has chinese characters. But when i try
my SP with Query Analyzer, it inserts ? for every chinese character...
I'll keep looking, thank you anyway!
Etienne
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:OFh7i2EsDHA.1600@.TK2MSFTNGP10.phx.gbl...
> Etienne,
> Did you also change the types of the variables in the stored procedures?
If
> not, then you will have conversions happening.
> You might also find this article useful if the international and Chinese
> world are new to you:
> http://msdn.microsoft.com/library/default.asp?
> url=/library/en-us/dnsql2k/html/intlfeaturesinsqlserver2000.asp
>
> Russell Fields
> http://www.sqlpass.org/
> 2004 PASS Community Summit - Orlando
> - The largest user-event dedicated to SQL Server!
> "Etienne M. St-Georges" <nospam.etienne@.emstg.com> wrote in message
> news:hQqvb.16446$iT4.2055861@.news20.bellglobal.com...
> >
> > Hi,
> > I have a problem with my Stored Procedures...
> > Recently we decided to change the type of our column in our databse from
> > varchar to nvarchar because of new customers (chinese).
> > Everything works fine EXCEPT the stored procedures... When i try to
pass
> > chinese characters for a simple SP that those a basic insert in my
table,
> it
> > inserts ? instead of chinese characters...
> > Did i miss something obvious?
> > Thanks a lot!
> > Etienne
> >
> > p.s.: you can email me at etienne_stgeorges@.hotmail.com or reply on this
> > newsgroup.
> >
> >
>|||Damn! Finally found it!
I had to put the letter N (capital) in front of each of my Unicode value...
example:
exec sp_SimpleInsert N'(chinesetext1)',N'(chineseText2)',N'(chineseText3)'
Thanks a lot!
"Etienne M. St-Georges" <nospam.etienne@.emstg.com> wrote in message
news:1Xrvb.16528$iT4.2069449@.news20.bellglobal.com...
> Hi Russell,
> Yep, changed the types of variables too...
> I'm really confused, nowhere on the web i could find somebody with the
same
> problem as me...
> What is strange is that with my access application, i can write, update
and
> select (of course!) any field that has chinese characters. But when i try
> my SP with Query Analyzer, it inserts ? for every chinese character...
> I'll keep looking, thank you anyway!
> Etienne
> "Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
> news:OFh7i2EsDHA.1600@.TK2MSFTNGP10.phx.gbl...
> > Etienne,
> >
> > Did you also change the types of the variables in the stored procedures?
> If
> > not, then you will have conversions happening.
> >
> > You might also find this article useful if the international and Chinese
> > world are new to you:
> > http://msdn.microsoft.com/library/default.asp?
> > url=/library/en-us/dnsql2k/html/intlfeaturesinsqlserver2000.asp
> >
> >
> > Russell Fields
> > http://www.sqlpass.org/
> > 2004 PASS Community Summit - Orlando
> > - The largest user-event dedicated to SQL Server!
> >
> > "Etienne M. St-Georges" <nospam.etienne@.emstg.com> wrote in message
> > news:hQqvb.16446$iT4.2055861@.news20.bellglobal.com...
> > >
> > > Hi,
> > > I have a problem with my Stored Procedures...
> > > Recently we decided to change the type of our column in our databse
from
> > > varchar to nvarchar because of new customers (chinese).
> > > Everything works fine EXCEPT the stored procedures... When i try to
> pass
> > > chinese characters for a simple SP that those a basic insert in my
> table,
> > it
> > > inserts ? instead of chinese characters...
> > > Did i miss something obvious?
> > > Thanks a lot!
> > > Etienne
> > >
> > > p.s.: you can email me at etienne_stgeorges@.hotmail.com or reply on
this
> > > newsgroup.
> > >
> > >
> >
> >
>|||Congratulations
Russell Fields
"Etienne M. St-Georges" <nospam.etienne@.emstg.com> wrote in message
news:B5svb.16541$iT4.2072482@.news20.bellglobal.com...
> Damn! Finally found it!
> I had to put the letter N (capital) in front of each of my Unicode
value...
> example:
> exec sp_SimpleInsert N'(chinesetext1)',N'(chineseText2)',N'(chineseText3)'
> Thanks a lot!
> "Etienne M. St-Georges" <nospam.etienne@.emstg.com> wrote in message
> news:1Xrvb.16528$iT4.2069449@.news20.bellglobal.com...
> > Hi Russell,
> > Yep, changed the types of variables too...
> > I'm really confused, nowhere on the web i could find somebody with the
> same
> > problem as me...
> > What is strange is that with my access application, i can write, update
> and
> > select (of course!) any field that has chinese characters. But when i
try
> > my SP with Query Analyzer, it inserts ? for every chinese character...
> > I'll keep looking, thank you anyway!
> > Etienne
> >
> > "Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
> > news:OFh7i2EsDHA.1600@.TK2MSFTNGP10.phx.gbl...
> > > Etienne,
> > >
> > > Did you also change the types of the variables in the stored
procedures?
> > If
> > > not, then you will have conversions happening.
> > >
> > > You might also find this article useful if the international and
Chinese
> > > world are new to you:
> > > http://msdn.microsoft.com/library/default.asp?
> > > url=/library/en-us/dnsql2k/html/intlfeaturesinsqlserver2000.asp
> > >
> > >
> > > Russell Fields
> > > http://www.sqlpass.org/
> > > 2004 PASS Community Summit - Orlando
> > > - The largest user-event dedicated to SQL Server!
> > >
> > > "Etienne M. St-Georges" <nospam.etienne@.emstg.com> wrote in message
> > > news:hQqvb.16446$iT4.2055861@.news20.bellglobal.com...
> > > >
> > > > Hi,
> > > > I have a problem with my Stored Procedures...
> > > > Recently we decided to change the type of our column in our databse
> from
> > > > varchar to nvarchar because of new customers (chinese).
> > > > Everything works fine EXCEPT the stored procedures... When i try to
> > pass
> > > > chinese characters for a simple SP that those a basic insert in my
> > table,
> > > it
> > > > inserts ? instead of chinese characters...
> > > > Did i miss something obvious?
> > > > Thanks a lot!
> > > > Etienne
> > > >
> > > > p.s.: you can email me at etienne_stgeorges@.hotmail.com or reply on
> this
> > > > newsgroup.
> > > >
> > > >
> > >
> > >
> >
> >
>|||On Fri, 21 Nov 2003 11:12:01 -0500, "Etienne M. St-Georges"
<nospam.etienne@.emstg.com> wrote:
>Hi,
>I have a problem with my Stored Procedures...
>Recently we decided to change the type of our column in our databse from
>varchar to nvarchar because of new customers (chinese).
>Everything works fine EXCEPT the stored procedures... When i try to pass
>chinese characters for a simple SP that those a basic insert in my table, it
>inserts ? instead of chinese characters...
>Did i miss something obvious?
>Thanks a lot!
G'day Etienne,
You don't mention how you are calling your stored procedures, but if you
are using ADO, note that you should use the Command object and
Parameters, and each nchar or nvarchar parameter should be created of
type adWChar or adWVarchar as appropriate.
cheers,
Ross.
--
Ross McKay, WebAware Pty Ltd
"Words can only hurt if you try to read them. Don't play their game" - Zoolander

Chinese chars through stored procedures...

Hi,
I have a problem with my Stored Procedures...
Recently we decided to change the type of our column in our databse from
varchar to nvarchar because of new customers (chinese).
Everything works fine EXCEPT the stored procedures... When i try to pass
chinese characters for a simple SP that those a basic insert in my table, it
inserts ? instead of chinese characters...
Did i miss something obvious?
Thanks a lot!
Etienne

p.s.: you can email me at etienne_stgeorges@.hotmail.com or reply on this
newsgroup.Check the source code of your stored procedure to make sure the parameter is
declared as nvarchar and not varchar.

HTH,
Dave

"Etienne M. St-Georges" <nospam.etienne@.emstg.com> wrote in message
news:MOqvb.16440$iT4.2055717@.news20.bellglobal.com ...
> Hi,
> I have a problem with my Stored Procedures...
> Recently we decided to change the type of our column in our databse from
> varchar to nvarchar because of new customers (chinese).
> Everything works fine EXCEPT the stored procedures... When i try to pass
> chinese characters for a simple SP that those a basic insert in my table,
it
> inserts ? instead of chinese characters...
> Did i miss something obvious?
> Thanks a lot!
> Etienne
> p.s.: you can email me at etienne_stgeorges@.hotmail.com or reply on this
> newsgroup.

childitem issues with xmlnamespaces and for xml path

I am having problems with the namespaces when using XML type data
inside a for XMLpath..
here is the first example
----
--
WITH XMLNAMESPACES(DEFAULT 'http://www.ratdog.com/example' )
select
'karl' as "name",
(select
'1' as "mine/one",
'2' as "mine/two"
for xml path('child'), type
)
for xml path('outer'), type
----
<outer xmlns="http://www.ratdog.com/example">
<name>karl</name>
<child xmlns="http://www.ratdog.com/example">
<mine>
<one>1</one>
<two>2</two>
</mine>
</child>
</outer>
----
you'll notice that it added the namespace to the "inner child" :),
which i'd rather it not do but at least its correct and it works.
however in the following example i put the "inner child" sql inside a
function as show :
----
create function dbo.testfunc()
returns XML
as
begin
return
(
select
'1' as "mine/one",
'2' as "mine/two"
for xml path('child'), type
)
end
WITH XMLNAMESPACES(DEFAULT 'http://www.ratdog.com/example' )
select
'karl' as "name",
dbo.testfunc()
for xml path('outer'), type
---
<outer xmlns="http://www.ratdog.com/example">
<name>karl</name>
<child xmlns="">
<mine>
<one>1</one>
<two>2</two>
</mine>
</child>
</outer>
---
and it puts the namespace as "", which i definately don't want.. i
don't want that clause in there at all
how can i get rid of it? or achieve a suitable workaround.
KarlNote that the function creates a document that has no namespace associated
with it. Since you include it in one that has the prefix, we have to
undeclare the default prefix.
So if you want to have the function have the same default namespace, you
need to use the WITH clause in the function.
And no, we currently do not remove the declarations on the inner level if
they are redundant...
Best regards
Michael
<klumsy@.xtra.co.nz> wrote in message
news:1144364933.977174.287100@.u72g2000cwu.googlegroups.com...
> I am having problems with the namespaces when using XML type data
> inside a for XMLpath..
> here is the first example
> ----
--
> WITH XMLNAMESPACES(DEFAULT 'http://www.ratdog.com/example' )
> select
> 'karl' as "name",
> (select
> '1' as "mine/one",
> '2' as "mine/two"
> for xml path('child'), type
> )
> for xml path('outer'), type
> ----
> <outer xmlns="http://www.ratdog.com/example">
> <name>karl</name>
> <child xmlns="http://www.ratdog.com/example">
> <mine>
> <one>1</one>
> <two>2</two>
> </mine>
> </child>
> </outer>
> ----
> you'll notice that it added the namespace to the "inner child" :),
> which i'd rather it not do but at least its correct and it works.
> however in the following example i put the "inner child" sql inside a
> function as show :
> ----
> create function dbo.testfunc()
> returns XML
> as
> begin
> return
> (
> select
> '1' as "mine/one",
> '2' as "mine/two"
> for xml path('child'), type
> )
> end
> WITH XMLNAMESPACES(DEFAULT 'http://www.ratdog.com/example' )
> select
> 'karl' as "name",
> dbo.testfunc()
> for xml path('outer'), type
> ---
> <outer xmlns="http://www.ratdog.com/example">
> <name>karl</name>
> <child xmlns="">
> <mine>
> <one>1</one>
> <two>2</two>
> </mine>
> </child>
> </outer>
> ---
> and it puts the namespace as "", which i definately don't want.. i
> don't want that clause in there at all
> how can i get rid of it? or achieve a suitable workaround.
> Karl
>

Checking the type of a variable in SQL

Is there a way to check the type of a variable in SQL? I want to know
if a variable is a float or a string.

Thanks,
RamziHi

I assume you mean that you want to check the contents of a string to see if
it is a numeric value. There is a ISNUMERIC function (see books online) but
to avoid problems with comma being recognised as a decimal point then you
may want to use patindex instead and check for any character then is not 0-9
or decimal point. Such as http://tinyurl.com/45ejw

John

"Ramzi Abboud" <ramziabb@.gmail.com> wrote in message
news:a5617e65.0410261046.6f18c9f3@.posting.google.c om...
> Is there a way to check the type of a variable in SQL? I want to know
> if a variable is a float or a string.
> Thanks,
> Ramzi

checking the type of a column

Hello,
I want to make an ALTER COLUMN to change a column's type (say VARCHAR to
TEXT), and I need to check first if the given column has not been changed
yet (the command will be in a script that will likely be runned more than
once and I don't want SQL Server to raise an error if the column to be
altered has already been altered).
So, I 've go table "Models" and I want to change the type of column
"Description" to TEXT (which is xtype 35). The following test ensures this
will only be done once:
if not exists (select * from dbo.syscolumns where id =
object_id(N'[dbo].[Models]')
and xtype = 35 and name = 'Description')
My question: is there a more elegant way of doing this ' (in terms of ease
of maintenance, performance, etc.) ? Thanks!!> My question: is there a more elegant way of doing this ' (in terms of ease
> of maintenance, performance, etc.) ? Thanks!!
Yes it is. Use information schema views instead accessing system tables
directly.
Example:
use northwind
go
create table t (colA varchar(50))
go
if exists(select * from information_schema.columns where table_schema =
'dbo' and table_name = 't' and column_name = 'colA' and data_type = 'varchar
')
alter table t alter column colA text
go
select
*
from
information_schema.columns
where
table_schema = 'dbo'
and table_name = 't'
and column_name = 'colA'
go
drop table t
go
AMB
"Jeff Robichaud" wrote:

> Hello,
> I want to make an ALTER COLUMN to change a column's type (say VARCHAR to
> TEXT), and I need to check first if the given column has not been changed
> yet (the command will be in a script that will likely be runned more than
> once and I don't want SQL Server to raise an error if the column to be
> altered has already been altered).
> So, I 've go table "Models" and I want to change the type of column
> "Description" to TEXT (which is xtype 35). The following test ensures this
> will only be done once:
> if not exists (select * from dbo.syscolumns where id =
> object_id(N'[dbo].[Models]')
> and xtype = 35 and name = 'Description')
> My question: is there a more elegant way of doing this ' (in terms of eas
e
> of maintenance, performance, etc.) ? Thanks!!
>
>|||OK, this sounds cleaner. But I wonder why MS does not use this approach in
Query Analyzer you generate some script ? They use sysobjects directly...
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:2EC973B1-31A8-42F2-AC03-51AEC0EC4799@.microsoft.com...
> Yes it is. Use information schema views instead accessing system tables
> directly.
> Example:
> use northwind
> go
> create table t (colA varchar(50))
> go
>
> if exists(select * from information_schema.columns where table_schema =
> 'dbo' and table_name = 't' and column_name = 'colA' and data_type =
> 'varchar')
> alter table t alter column colA text
> go
> select
> *
> from
> information_schema.columns
> where
> table_schema = 'dbo'
> and table_name = 't'
> and column_name = 'colA'
> go
> drop table t
> go
>
> AMB
> "Jeff Robichaud" wrote:
>|||Jeff,
You will find an explanation if you see "Information Schema Views
" in BOL.
AMB
"Jeff Robichaud" wrote:

> OK, this sounds cleaner. But I wonder why MS does not use this approach in
> Query Analyzer you generate some script ? They use sysobjects directly...
> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in messag
e
> news:2EC973B1-31A8-42F2-AC03-51AEC0EC4799@.microsoft.com...
>
>

Checking Format of a string in Report Parameter

Is there a way to find out if the user entered the date in correct format for the report parameter? For example, I am using string data type and requring the user to enter date in yyyy/mm/dd format. Can I capture and prompt the user accordingly if the date string is not provided in the above format?

Why dont you create the parameter in a Datetime format and let the user enter it in a date time format. After that you use the functions to convert itto a string in your desired format.

|||

You might be able to take advantage of the isDate() function; however, at the moment I don't see how to apply it.

Checking data type

How can I check data type of a column?
Thanks.
SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME='yourtable' AND COLUMN_NAME='yourcolumn'
http://www.aspfaq.com/
(Reverse address to reply.)
"Vik" <viktorum@.==hotmail.com==> wrote in message
news:OHx7750nEHA.3876@.TK2MSFTNGP15.phx.gbl...
> How can I check data type of a column?
> Thanks.
>
|||Sp_help? Select against INFORMATION_SCHEMA.COLUMNS?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Vik" <viktorum@.==hotmail.com==> wrote in message news:OHx7750nEHA.3876@.TK2MSFTNGP15.phx.gbl...
> How can I check data type of a column?
> Thanks.
>

Checking data type

How can I check data type of a column?
Thanks.SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME='yourtable' AND COLUMN_NAME='yourcolumn'
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Vik" <viktorum@.==hotmail.com==> wrote in message
news:OHx7750nEHA.3876@.TK2MSFTNGP15.phx.gbl...
> How can I check data type of a column?
> Thanks.
>|||Sp_help? Select against INFORMATION_SCHEMA.COLUMNS?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Vik" <viktorum@.==hotmail.com==> wrote in message news:OHx7750nEHA.3876@.TK2MSFTNGP15.phx.gbl...
> How can I check data type of a column?
> Thanks.
>

Checking a Column Data Type

Here is the issue,

I was given the task of creating a datamart by combining the information from several different database servers. While doing this I ran into an interesting issue that I can't seem to figure out.

I have two tables, one table has a code value in it pointing to the corresponding lookup table. The lookup table for whatever reason (I didn't build the application or the database, yay legacy support! ) has two lookup columns, one is the standard incrementing numbers and the other is a series of letters. The problem lies in the fact that the code in the first table is a char(1) and can either be a letter or a number. The look up has type int and char so I run into a simple conversion problem. Here is my datamart select statement that fails because it can not convert a char to an int. My question is what would be an easy way to test which value type the char(1) is and use the appropriate left outer join.. I tried several different approaches but just can't seem to figure it out.

SELECT *

FROM PERMIT

LEFT OUTER JOIN PERMIT_STATUS_LU

ON

(

(PERMIT.endorse_status_cd = PERMIT_STATUS_LU.PSLU_PERMIT_STATUS_NM) OR

(PERMIT.endorse_status_cd = PERMIT_STATUS_LU.pslu_cd)

)

the above of course fails due to type conversion. status_cd is the char(1), status_nm is the char and pslu_cd is the int. I have no clue why they set it up this way, but I get to figure out how to deal with it.

Confused,

-Andrew

Try to use ISNUMERIC:

declare @.c char(1)

set @.c='5'

select isnumeric(@.c)

Result: 1

declare @.c2 char(1)

set @.c2='a'

select isnumeric(@.c2)

Result: 0

|||

yeah I thought about that but then the question is, how do you use IF ELSE Logic inside a JOIN statement

Can you even do something like this? ( I just tried it and got parse errors) So I guess the question is now how do you put conditional logic inside a JOIN ON ?

LEFT OUTER JOIN PERMIT_STATUS_LU

ON

(

IF ( isnumeric(PERMIT.endorse_status_cd) = 1)

BEGIN

(PERMIT.endorse_status_cd = PERMIT_STATUS_LU.PSLU_PERMIT_STATUS_NM)

END

ELSE
BEGIN

(PERMIT.endorse_status_cd = PERMIT_STATUS_LU.pslu_cd)

END

)

|||

Use CASE instead.

Also, isnumeric, under some situations, can be unreliable. Refer to this article for details.

isnumeric -What is wrong?
http://www.aspfaq.com/show.asp?id=2390

|||

Good idea using the CASE. I am still getting errors though, I am still unsure if its even possible to put a CASE statement inside the JOIN on clause. For example I tried

....

FROM PERMIT

CASE isnumeric(PERMIT.endorse_status_cd)

WHEN 0 THEN LEFT OUTER JOIN PERMIT_STATUS_LU ON PERMIT.endorse_status_cd = PERMIT_STATUS_LU.PSLU_PERMIT_STATUS_NM

WHEN 1 THEN LEFT OUTER JOIN PERMIT_STATUS_LU ON PERMIT.endorse_status_cd = PERMIT_STATUS_LU.pslu_cd

END

That didnt work so I tried

....

FROM PERMIT

LEFT OUTER JOIN PERMIT_STATUS_LU ON

(

CASE isnumeric(PERMIT.endorse_status_cd)

WHEN 0 THEN PERMIT.endorse_status_cd = PERMIT_STATUS_LU.PSLU_PERMIT_STATUS_NM

WHEN 1 THEN PERMIT_STATUS_LU ON PERMIT.endorse_status_cd = PERMIT_STATUS_LU.pslu_cd

END

)

that failed as well

Does anyone have a definative answer to the above question?

|||

I created 2 separate queries: One that contains only the rows that have a numeric value for endorse_status_cd and another for the non numeric values. I used a union to merge them into one singe result set. Here is the query:

Code Snippet

SELECT *

FROM PERMIT

LEFT OUTER JOIN PERMIT_STATUS_LU

ON PERMIT.endorse_status_cd = PERMIT_STATUS_LU.PSLU_PERMIT_STATUS_NM

WHERE IsNumeric(PERMIT.endorse_status_cd) = 0

UNION

SELECT *

FROM PERMIT

LEFT OUTER JOIN PERMIT_STATUS_LU

ON PERMIT.endorse_status_cd = PERMIT_STATUS_LU.pslu_cd

WHERE IsNumeric(PERMIT.endorse_status_cd) = 1

Based on the article that Arnie included in his reply, it might be better to create your own function (check the article) instead of IsNumeric.

I hope this answers your question.

Best regards,

Sami Samir

Checked data type

Is their a data type that can be a 'check' (On or Off)? I seen this data type somewhere but forgor how to use it and what it looks like. Can anyone help. :)Is their a data type that can be a 'check' (On or Off)?

Use "Bit" datatype... When it's status is True = ON & False = OFF.

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
-thanks
That 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.googlegr oups.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:
>
|||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:[vbcol=seagreen]
> Hi
> Have you extracted the service pack and then run the upgrade or just
> extracted it?
> John
> "frizzzdog" 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.googlegro ups.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:
>
|||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:[vbcol=seagreen]
> 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.googlegro ups.com...
|||> 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.googlegro ups.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:
>
|||Dan Guzman wrote:[vbcol=seagreen]
> 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.
>
> 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.
>
> 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.googlegro ups.com...

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
>> >> >> >
>> >> >> >
>> >> >
>> >
>