Outlook + SQL 2000 SP4 on Windows 2003 2node Active/Passive Cluste

Hi
I have only "heard" that installing Outlook on Windows 2003 cluster running
SQL 2000 might create problems.
Has anyone actually experienced this ? Or am I just hearing rumours.
I would like to install Outlook provided there is no down side to it. What
are the alternatives to Outlook or MAPI all together.
Thanks in advance.Hi
I have not heard of any Outlook/Cluster issue as such but..
it may be the only way of getting Extended MAPI installed on the system
without breaking any licencing agreement or installing exchange server. You
would need to set up exactly the same profile on both side of the cluster.
If you are using a SMTP server (such as excahnge) then you could use XP_SMTP
instead http://www.sqldev.net/xp/xpsmtp.htm
John
"kunalap" wrote:
> Hi
> I have only "heard" that installing Outlook on Windows 2003 cluster running
> SQL 2000 might create problems.
> Has anyone actually experienced this ? Or am I just hearing rumours.
> I would like to install Outlook provided there is no down side to it. What
> are the alternatives to Outlook or MAPI all together.
> Thanks in advance.
>|||"kunalap" <kunalap@.discussions.microsoft.com> wrote in message
news:22DB6194-4E10-4D29-A0D6-4C15B5C5D21D@.microsoft.com...
> Hi
> I have only "heard" that installing Outlook on Windows 2003 cluster
running
> SQL 2000 might create problems.
> Has anyone actually experienced this ? Or am I just hearing rumours.
>
We have done this. The best advice as others have said is make sure the
profile is exactly the same on both servers.
If you're not connecting to an Exchange server,but say just using SMTP to
SEND message from SQL Server, I'd recommend installing a local SMTP instance
on each node and using that to rely the messages.
Have SQL Mail send to the local copy of the SMTP server. That eliminates a
lot of situations where the MAPI client will hang.
> I would like to install Outlook provided there is no down side to it. What
> are the alternatives to Outlook or MAPI all together.
> Thanks in advance.
>

Outlook + SQL 2000 SP4 on Windows 2003 2node Active/Passive Cluste

Hi
I have only "heard" that installing Outlook on Windows 2003 cluster running
SQL 2000 might create problems.
Has anyone actually experienced this ? Or am I just hearing rumours.
I would like to install Outlook provided there is no down side to it. What
are the alternatives to Outlook or MAPI all together.
Thanks in advance.Hi
I have not heard of any Outlook/Cluster issue as such but..
it may be the only way of getting Extended MAPI installed on the system
without breaking any licencing agreement or installing exchange server. You
would need to set up exactly the same profile on both side of the cluster.
If you are using a SMTP server (such as excahnge) then you could use XP_SMTP
instead http://www.sqldev.net/xp/xpsmtp.htm
John
"kunalap" wrote:

> Hi
> I have only "heard" that installing Outlook on Windows 2003 cluster runnin
g
> SQL 2000 might create problems.
> Has anyone actually experienced this ? Or am I just hearing rumours.
> I would like to install Outlook provided there is no down side to it. What
> are the alternatives to Outlook or MAPI all together.
> Thanks in advance.
>|||"kunalap" <kunalap@.discussions.microsoft.com> wrote in message
news:22DB6194-4E10-4D29-A0D6-4C15B5C5D21D@.microsoft.com...
> Hi
> I have only "heard" that installing Outlook on Windows 2003 cluster
running
> SQL 2000 might create problems.
> Has anyone actually experienced this ? Or am I just hearing rumours.
>
We have done this. The best advice as others have said is make sure the
profile is exactly the same on both servers.
If you're not connecting to an Exchange server,but say just using SMTP to
SEND message from SQL Server, I'd recommend installing a local SMTP instance
on each node and using that to rely the messages.
Have SQL Mail send to the local copy of the SMTP server. That eliminates a
lot of situations where the MAPI client will hang.

> I would like to install Outlook provided there is no down side to it. What
> are the alternatives to Outlook or MAPI all together.
> Thanks in advance.
>

Out of Memory Exception

I'm getting an out of memory exception when designing by report model and
selecting save. I'm using 64bit windows xp 4Gb Ram and two dual core xeons
so presumably this is a bug! Anyone have any ideas?Hello Phil,
I would like to know whether there is any related error in the Report Log
File.
Would you please try to check the Report log File and post the error here
for me to troubleshooting?
By default, the log file is located at \Microsoft SQL Server\<SQL Server
Instance>\Reporting Services\LogFiles.
Please let me know the resault. Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi Phil,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Supportsql

Other alternative JDBC driver that support window authentication

Hi, are there any alternative JDBC driver that support windows authentication
for Microsoft SQL Server 2000 beside jTDS JDBC Driver and JSQLConnect Driver?
I have tested both of the drivers and I can't get the jTDS JDBC Driver
works. Is there any online guide on how to connect jTDS JDBC Driver with
windows authentication?
Thanks.
DataDirect Technologies has a JDBC driver which supports Windows
Authentication. It does require the use of JDK 1.4 and higher.
You can find out more about the driver at:
http://www.datadirect.com/products/j...view/index.ssp
You can download an evaluation driver at:
http://www.datadirect.com/downloads/...jdbc/index.ssp
Sue Purkis
DataDirect Technologies
"Xiangboy" <Xiangboy@.discussions.microsoft.com> wrote in message
news:94CF3DEB-D62F-440E-9112-B8D654E43AAC@.microsoft.com...
> Hi, are there any alternative JDBC driver that support windows
authentication
> for Microsoft SQL Server 2000 beside jTDS JDBC Driver and JSQLConnect
Driver?
> I have tested both of the drivers and I can't get the jTDS JDBC Driver
> works. Is there any online guide on how to connect jTDS JDBC Driver with
> windows authentication?
> Thanks.
>
|||If you need any help with jTDS please post your questions/problems on
one of the jTDS forums (at http://jtds.sourceforge.net ). They will be
answered sooner that way.
And make sure to explain what "does not work" means, including at least
an exception stacktrace.
Alin,
The jTDS Project.

OT: SQL Data on RAID5 Missing disk?

My SQL data is on a software Raid5 partition on my Windows Server 2003
Enterprise.
It appears one of my disks is not coming up and another disk is reported as
"Missing" so my SQL data is not being found!!
There is another disk that nows shows up as Unknown and uninitialized. Is
this my "missing" disk?
How do I recover from this without losing my data on the Raid?
Any help would be appreciated!!!
Attached is what it looks like in Disk Manager.
I tried to "Reactivate" the "Missing" disk but that didn't work and a bunch
of events in the System log
"The device detected a controller error on \device\harddisk1".
And there are alos informational events in the system log for harddisk3 such
as:
"dmio: Harddisk3 write error at block:145743940: status 0xc00000a2"
So it appears that one drive is just physcially dead I guess and another is
corrupted.
I'm starting to panick because our backups the the SQL are old...
Is there any safe way to recover from this situation?
"news.microsoft.com" <junk@.ijunk.com> wrote in message
news:eDwuW39DHHA.3520@.TK2MSFTNGP04.phx.gbl...
> My SQL data is on a software Raid5 partition on my Windows Server 2003
> Enterprise.
> It appears one of my disks is not coming up and another disk is reported
> as
> "Missing" so my SQL data is not being found!!
> There is another disk that nows shows up as Unknown and uninitialized. Is
> this my "missing" disk?
> How do I recover from this without losing my data on the Raid?
> Any help would be appreciated!!!
>
|||"news.microsoft.com" <junk@.ijunk.com> wrote in message
news:#oKeSA#DHHA.1196@.TK2MSFTNGP02.phx.gbl...
> Attached is what it looks like in Disk Manager.
> I tried to "Reactivate" the "Missing" disk but that didn't work and a
> bunch of events in the System log
> "The device detected a controller error on \device\harddisk1".
> And there are alos informational events in the system log for harddisk3
> such as:
> "dmio: Harddisk3 write error at block:145743940: status 0xc00000a2"
> So it appears that one drive is just physcially dead I guess and another
> is corrupted.
> I'm starting to panick because our backups the the SQL are old...
> Is there any safe way to recover from this situation?
>
You full database backups are old. Do you have an unbroken sequence of
transaction log backups dating from your last full backup?
David
|||I don't think so, but I'm not sure.
The Raid that failed is my D drive where my SQL database was located.
Are you saying there might be transaction logs on the C drive somewhere?
The last backup was months ago.
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:ujOYcT%23DHHA.4680@.TK2MSFTNGP04.phx.gbl...
>
> "news.microsoft.com" <junk@.ijunk.com> wrote in message
> news:#oKeSA#DHHA.1196@.TK2MSFTNGP02.phx.gbl...
> You full database backups are old. Do you have an unbroken sequence of
> transaction log backups dating from your last full backup?
> David
|||>>> On 11/24/2006 at 9:50 AM, in message
<#AWC5i#DHHA.4464@.TK2MSFTNGP06.phx.gbl>,
news.microsoft.com<junk@.ijunk.com> wrote:
> I don't think so, but I'm not sure.
> The Raid that failed is my D drive where my SQL database was
> located.
> Are you saying there might be transaction logs on the C drive
> somewhere?
> The last backup was months ago.
If the data truly is important, don't risk screwing things up more by
trying things yourself unless you are *extremely* confident in your own
skills.
This is the time to pay someone who knows what they are doing.
Otherwise you risk turning a possibly recoverable scenario into a
non-recoverable scenario.
MS PSS might be a good place to start, as might your hardware vendor.
Make sure you explain that you don't have backups, so you want to be
very careful not to do anything that is likely to cause more problems.
|||Check Tibor's article:
Minimizing data loss when accidents happens
http://www.karaszi.com/SQLServer/info_restore_log_several_times.asp
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"news.microsoft.com" <junk@.ijunk.com> wrote in message
news:%23AWC5i%23DHHA.4464@.TK2MSFTNGP06.phx.gbl...
>I don't think so, but I'm not sure.
> The Raid that failed is my D drive where my SQL database was located.
> Are you saying there might be transaction logs on the C drive somewhere?
> The last backup was months ago.
>
> "David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
> message news:ujOYcT%23DHHA.4680@.TK2MSFTNGP04.phx.gbl...
>
|||news.microsoft.com wrote:
> I don't think so, but I'm not sure.
> The Raid that failed is my D drive where my SQL database was located.
> Are you saying there might be transaction logs on the C drive somewhere?
> The last backup was months ago.
>
Painful as it may be, I suggest you first get someone on site who knows
what they are doing. Obviously a lot of damage has already been done
and now your data is at risk.
Except for a read-only database, RAID5 is not a great choice for a
database server because of the performance and availability
constraints.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
|||Well, I physically went to the server and found one disk on boot sounded
like two stones grinding on each other at 10k RPM...
The other failed disk just says "Media Error" on the Adeptec BIOS boot
discovery.
If I could find some temporary way of getting this drive to work for like 10
minutes then I could copy out the database.
Any ideas?
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1164397255.045467.37770@.f16g2000cwb.googlegro ups.com...
> news.microsoft.com wrote:
> Painful as it may be, I suggest you first get someone on site who knows
> what they are doing. Obviously a lot of damage has already been done
> and now your data is at risk.
> Except for a read-only database, RAID5 is not a great choice for a
> database server because of the performance and availability
> constraints.
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>

OT: SQL Data on RAID5 Missing disk?

My SQL data is on a software Raid5 partition on my Windows Server 2003
Enterprise.
It appears one of my disks is not coming up and another disk is reported as
"Missing" so my SQL data is not being found!!
There is another disk that nows shows up as Unknown and uninitialized. Is
this my "missing" disk?
How do I recover from this without losing my data on the Raid'
Any help would be appreciated!!!"news.microsoft.com" <junk@.ijunk.com> wrote in message
news:#oKeSA#DHHA.1196@.TK2MSFTNGP02.phx.gbl...
> Attached is what it looks like in Disk Manager.
> I tried to "Reactivate" the "Missing" disk but that didn't work and a
> bunch of events in the System log
> "The device detected a controller error on \device\harddisk1".
> And there are alos informational events in the system log for harddisk3
> such as:
> "dmio: Harddisk3 write error at block:145743940: status 0xc00000a2"
> So it appears that one drive is just physcially dead I guess and another
> is corrupted.
> I'm starting to panick because our backups the the SQL are old...
> Is there any safe way to recover from this situation'
>
You full database backups are old. Do you have an unbroken sequence of
transaction log backups dating from your last full backup?
David|||I don't think so, but I'm not sure.
The Raid that failed is my D drive where my SQL database was located.
Are you saying there might be transaction logs on the C drive somewhere?
The last backup was months ago.
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:ujOYcT%23DHHA.4680@.TK2MSFTNGP04.phx.gbl...
>
> "news.microsoft.com" <junk@.ijunk.com> wrote in message
> news:#oKeSA#DHHA.1196@.TK2MSFTNGP02.phx.gbl...
>> Attached is what it looks like in Disk Manager.
>> I tried to "Reactivate" the "Missing" disk but that didn't work and a
>> bunch of events in the System log
>> "The device detected a controller error on \device\harddisk1".
>> And there are alos informational events in the system log for harddisk3
>> such as:
>> "dmio: Harddisk3 write error at block:145743940: status 0xc00000a2"
>> So it appears that one drive is just physcially dead I guess and another
>> is corrupted.
>> I'm starting to panick because our backups the the SQL are old...
>> Is there any safe way to recover from this situation'
> You full database backups are old. Do you have an unbroken sequence of
> transaction log backups dating from your last full backup?
> David|||> Are you saying there might be transaction logs on the C drive somewhere?
It depends on where you decided to store the transaction log file(s) for the database. With a (IMO)
sound backup strategy:
Backup database regularly, say every day.
Backup the transaction log regularly, say every hour.
You would now do the "final" log backup, assuming the transaction log file(s), the ldf file, for the
database is available. BACKUP LOG using the NO_TRUNCATE option.
Then restore the most recent database backup and all subsequent log backups. If you managed to do
the "final" log backup, you have zero data loss.
Assuming that your most recent backup is indeed one month ago:
My guess is that you don't do regular log backups. I also guess that the database in question is in
simple recovery mode (otherwise you will have large ldf file(s) for the database).
Based on above: If you cannot get the disk back, you will only get to the one month old backup.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"news.microsoft.com" <junk@.ijunk.com> wrote in message
news:%23AWC5i%23DHHA.4464@.TK2MSFTNGP06.phx.gbl...
>I don't think so, but I'm not sure.
> The Raid that failed is my D drive where my SQL database was located.
> Are you saying there might be transaction logs on the C drive somewhere?
> The last backup was months ago.
>
> "David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in message
> news:ujOYcT%23DHHA.4680@.TK2MSFTNGP04.phx.gbl...
>>
>> "news.microsoft.com" <junk@.ijunk.com> wrote in message
>> news:#oKeSA#DHHA.1196@.TK2MSFTNGP02.phx.gbl...
>> Attached is what it looks like in Disk Manager.
>> I tried to "Reactivate" the "Missing" disk but that didn't work and a bunch of events in the
>> System log
>> "The device detected a controller error on \device\harddisk1".
>> And there are alos informational events in the system log for harddisk3 such as:
>> "dmio: Harddisk3 write error at block:145743940: status 0xc00000a2"
>> So it appears that one drive is just physcially dead I guess and another is corrupted.
>> I'm starting to panick because our backups the the SQL are old...
>> Is there any safe way to recover from this situation'
>>
>> You full database backups are old. Do you have an unbroken sequence of transaction log backups
>> dating from your last full backup?
>> David
>|||>> On 11/24/2006 at 9:50 AM, in message
<#AWC5i#DHHA.4464@.TK2MSFTNGP06.phx.gbl>,
news.microsoft.com<junk@.ijunk.com> wrote:
> I don't think so, but I'm not sure.
> The Raid that failed is my D drive where my SQL database was
> located.
> Are you saying there might be transaction logs on the C drive
> somewhere?
> The last backup was months ago.
If the data truly is important, don't risk screwing things up more by
trying things yourself unless you are *extremely* confident in your own
skills.
This is the time to pay someone who knows what they are doing.
Otherwise you risk turning a possibly recoverable scenario into a
non-recoverable scenario.
MS PSS might be a good place to start, as might your hardware vendor.
Make sure you explain that you don't have backups, so you want to be
very careful not to do anything that is likely to cause more problems.|||Check Tibor's article:
Minimizing data loss when accidents happens
http://www.karaszi.com/SQLServer/info_restore_log_several_times.asp
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"news.microsoft.com" <junk@.ijunk.com> wrote in message
news:%23AWC5i%23DHHA.4464@.TK2MSFTNGP06.phx.gbl...
>I don't think so, but I'm not sure.
> The Raid that failed is my D drive where my SQL database was located.
> Are you saying there might be transaction logs on the C drive somewhere?
> The last backup was months ago.
>
> "David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
> message news:ujOYcT%23DHHA.4680@.TK2MSFTNGP04.phx.gbl...
>>
>> "news.microsoft.com" <junk@.ijunk.com> wrote in message
>> news:#oKeSA#DHHA.1196@.TK2MSFTNGP02.phx.gbl...
>> Attached is what it looks like in Disk Manager.
>> I tried to "Reactivate" the "Missing" disk but that didn't work and a
>> bunch of events in the System log
>> "The device detected a controller error on \device\harddisk1".
>> And there are alos informational events in the system log for harddisk3
>> such as:
>> "dmio: Harddisk3 write error at block:145743940: status 0xc00000a2"
>> So it appears that one drive is just physcially dead I guess and another
>> is corrupted.
>> I'm starting to panick because our backups the the SQL are old...
>> Is there any safe way to recover from this situation'
>>
>> You full database backups are old. Do you have an unbroken sequence of
>> transaction log backups dating from your last full backup?
>> David
>|||news.microsoft.com wrote:
> I don't think so, but I'm not sure.
> The Raid that failed is my D drive where my SQL database was located.
> Are you saying there might be transaction logs on the C drive somewhere?
> The last backup was months ago.
>
Painful as it may be, I suggest you first get someone on site who knows
what they are doing. Obviously a lot of damage has already been done
and now your data is at risk.
Except for a read-only database, RAID5 is not a great choice for a
database server because of the performance and availability
constraints.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Well, I physically went to the server and found one disk on boot sounded
like two stones grinding on each other at 10k RPM...
The other failed disk just says "Media Error" on the Adeptec BIOS boot
discovery.
If I could find some temporary way of getting this drive to work for like 10
minutes then I could copy out the database.
Any ideas?
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1164397255.045467.37770@.f16g2000cwb.googlegroups.com...
> news.microsoft.com wrote:
>> I don't think so, but I'm not sure.
>> The Raid that failed is my D drive where my SQL database was located.
>> Are you saying there might be transaction logs on the C drive somewhere?
>> The last backup was months ago.
>>
> Painful as it may be, I suggest you first get someone on site who knows
> what they are doing. Obviously a lot of damage has already been done
> and now your data is at risk.
> Except for a read-only database, RAID5 is not a great choice for a
> database server because of the performance and availability
> constraints.
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>

osql to connect to a Database

I am running MSDE 2000 Rel A on a Windows XP machine and am able to
connect to it by doing the following:
osql -U sa
or
osql -E
But how do I connect to a Particular Database or see all the tables
etc? I am a but familiar with sql (which could be the problem) and an
trying to do the following that I can with it:
sql user_name/database_name@.password
so that I can connect directly to the DB I'm interested and then I can
do:
select tablenames;
desc table_name;
select * from table_name;
etc
Any ideas? Like I mentioned, maybe I'm trying to do things that is not
supposed to be possible with osql (which would really suck).
- manzoorosql -S (local) -E -d pubs
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2004 All rights reserved.
"Manzoorul Hassan" <manzoorul.hassan@.gmail.com> wrote in message
news:1105052724.438484.94120@.z14g2000cwz.googlegroups.com...
>I am running MSDE 2000 Rel A on a Windows XP machine and am able to
> connect to it by doing the following:
> osql -U sa
> or
> osql -E
> But how do I connect to a Particular Database or see all the tables
> etc? I am a but familiar with sql (which could be the problem) and an
> trying to do the following that I can with it:
> sql user_name/database_name@.password
> so that I can connect directly to the DB I'm interested and then I can
> do:
> select tablenames;
> desc table_name;
> select * from table_name;
> etc
> Any ideas? Like I mentioned, maybe I'm trying to do things that is not
> supposed to be possible with osql (which would really suck).
> - manzoor
>|||Hi Hassan,
From your posting it looks like 'sa' password is blank (that is incase you
are not giving any password when OSQL utility prompts).
Best practice is to change the 'sa' pwd to something else, as it gives
access to anybody in your network, with sql client.
If you are not using blank pwd, please ignore this message.
--
Thanks
Yogish|||thanx a million!!!!
- manzoor

osql to connect to a Database

I am running MSDE 2000 Rel A on a Windows XP machine and am able to
connect to it by doing the following:
osql -U sa
or
osql -E
But how do I connect to a Particular Database or see all the tables
etc? I am a but familiar with sql (which could be the problem) and an
trying to do the following that I can with it:
sql user_name/database_name@.password
so that I can connect directly to the DB I'm interested and then I can
do:
select tablenames;
desc table_name;
select * from table_name;
etc
Any ideas? Like I mentioned, maybe I'm trying to do things that is not
supposed to be possible with osql (which would really suck).
- manzoor
osql -S (local) -E -d pubs
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2004 All rights reserved.
"Manzoorul Hassan" <manzoorul.hassan@.gmail.com> wrote in message
news:1105052724.438484.94120@.z14g2000cwz.googlegro ups.com...
>I am running MSDE 2000 Rel A on a Windows XP machine and am able to
> connect to it by doing the following:
> osql -U sa
> or
> osql -E
> But how do I connect to a Particular Database or see all the tables
> etc? I am a but familiar with sql (which could be the problem) and an
> trying to do the following that I can with it:
> sql user_name/database_name@.password
> so that I can connect directly to the DB I'm interested and then I can
> do:
> select tablenames;
> desc table_name;
> select * from table_name;
> etc
> Any ideas? Like I mentioned, maybe I'm trying to do things that is not
> supposed to be possible with osql (which would really suck).
> - manzoor
>
|||Hi Hassan,
From your posting it looks like 'sa' password is blank (that is incase you
are not giving any password when OSQL utility prompts).
Best practice is to change the 'sa' pwd to something else, as it gives
access to anybody in your network, with sql client.
If you are not using blank pwd, please ignore this message.
Thanks
Yogish
|||thanx a million!!!!
- manzoor

osql to connect to a Database

I am running MSDE 2000 Rel A on a Windows XP machine and am able to
connect to it by doing the following:
osql -U sa
or
osql -E
But how do I connect to a Particular Database or see all the tables
etc? I am a but familiar with sql (which could be the problem) and an
trying to do the following that I can with it:
sql user_name/database_name@.password
so that I can connect directly to the DB I'm interested and then I can
do:
select tablenames;
desc table_name;
select * from table_name;
etc
Any ideas? Like I mentioned, maybe I'm trying to do things that is not
supposed to be possible with osql (which would really suck).
- manzoorosql -S (local) -E -d pubs
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2004 All rights reserved.
"Manzoorul Hassan" <manzoorul.hassan@.gmail.com> wrote in message
news:1105052724.438484.94120@.z14g2000cwz.googlegroups.com...
>I am running MSDE 2000 Rel A on a Windows XP machine and am able to
> connect to it by doing the following:
> osql -U sa
> or
> osql -E
> But how do I connect to a Particular Database or see all the tables
> etc? I am a but familiar with sql (which could be the problem) and an
> trying to do the following that I can with it:
> sql user_name/database_name@.password
> so that I can connect directly to the DB I'm interested and then I can
> do:
> select tablenames;
> desc table_name;
> select * from table_name;
> etc
> Any ideas? Like I mentioned, maybe I'm trying to do things that is not
> supposed to be possible with osql (which would really suck).
> - manzoor
>|||Hi Hassan,
From your posting it looks like 'sa' password is blank (that is incase you
are not giving any password when OSQL utility prompts).
Best practice is to change the 'sa' pwd to something else, as it gives
access to anybody in your network, with sql client.
If you are not using blank pwd, please ignore this message.
Thanks
Yogish|||thanx a million!!!!
- manzoor

OSQL performance slow vs ISQLW

I have a script to run against a SQL Server 2000 database Windows 2003 OS).
The script creates temp tables and then uses the manipulated data to update
the database.
The probelem is when I run the script in Query Analyzer it takes less then
10 minutes to execute. When run the same script using OSQL it takes over an
hour.
Has anyone seen anything like this? Any suggestions would be great.
Possibly different SET setting can affect things. Also, you could try SET NOCOUNT ON and see if it
makes any difference.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Wex" <Wex@.discussions.microsoft.com> wrote in message
news:1B68CD56-168D-419F-A01D-8FF310F2EC96@.microsoft.com...
>I have a script to run against a SQL Server 2000 database Windows 2003 OS).
> The script creates temp tables and then uses the manipulated data to update
> the database.
> The probelem is when I run the script in Query Analyzer it takes less then
> 10 minutes to execute. When run the same script using OSQL it takes over an
> hour.
> Has anyone seen anything like this? Any suggestions would be great.

OSQL performance slow vs ISQLW

I have a script to run against a SQL Server 2000 database Windows 2003 OS).
The script creates temp tables and then uses the manipulated data to update
the database.
The probelem is when I run the script in Query Analyzer it takes less then
10 minutes to execute. When run the same script using OSQL it takes over an
hour.
Has anyone seen anything like this? Any suggestions would be great.Possibly different SET setting can affect things. Also, you could try SET NO
COUNT ON and see if it
makes any difference.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Wex" <Wex@.discussions.microsoft.com> wrote in message
news:1B68CD56-168D-419F-A01D-8FF310F2EC96@.microsoft.com...
>I have a script to run against a SQL Server 2000 database Windows 2003 OS).
> The script creates temp tables and then uses the manipulated data to updat
e
> the database.
> The probelem is when I run the script in Query Analyzer it takes less then
> 10 minutes to execute. When run the same script using OSQL it takes over
an
> hour.
> Has anyone seen anything like this? Any suggestions would be great.

OSQL performance slow vs ISQLW

I have a script to run against a SQL Server 2000 database Windows 2003 OS).
The script creates temp tables and then uses the manipulated data to update
the database.
The probelem is when I run the script in Query Analyzer it takes less then
10 minutes to execute. When run the same script using OSQL it takes over an
hour.
Has anyone seen anything like this? Any suggestions would be great.Possibly different SET setting can affect things. Also, you could try SET NOCOUNT ON and see if it
makes any difference.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Wex" <Wex@.discussions.microsoft.com> wrote in message
news:1B68CD56-168D-419F-A01D-8FF310F2EC96@.microsoft.com...
>I have a script to run against a SQL Server 2000 database Windows 2003 OS).
> The script creates temp tables and then uses the manipulated data to update
> the database.
> The probelem is when I run the script in Query Analyzer it takes less then
> 10 minutes to execute. When run the same script using OSQL it takes over an
> hour.
> Has anyone seen anything like this? Any suggestions would be great.

OSQL -L

Hi All,
Can anyone please tell me if we issue "OSQL -L " at command prompt, does it
lists all the SQL Servers in the network or just windows servers within the
network?
Thanks,
VMIt shows you all broadcasted SQL Server instances over the net, whereas the
instances are hided for discovery.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"VM" <VM@.discussions.microsoft.com> schrieb im Newsbeitrag
news:695DABDF-AE47-430A-9AF8-1E495BBF6C7D@.microsoft.com...
> Hi All,
> Can anyone please tell me if we issue "OSQL -L " at command prompt, does
> it
> lists all the SQL Servers in the network or just windows servers within
> the
> network?
> Thanks,
> VM|||> Can anyone please tell me if we issue "OSQL -L " at command prompt, does it
> lists all the SQL Servers in the network or just windows servers within the
> network?
SQL Servers. But be carefull, because if you create an alias using Client
Network Utility, this command will list it even if the alias is not
associated with a physical server.
AMB
"VM" wrote:
> Hi All,
> Can anyone please tell me if we issue "OSQL -L " at command prompt, does it
> lists all the SQL Servers in the network or just windows servers within the
> network?
> Thanks,
> VM

OSQL -L

Hi All,
Can anyone please tell me if we issue "OSQL -L " at command prompt, does it
lists all the SQL Servers in the network or just windows servers within the
network?
Thanks,
VM
It shows you all broadcasted SQL Server instances over the net, whereas the
instances are hided for discovery.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"VM" <VM@.discussions.microsoft.com> schrieb im Newsbeitrag
news:695DABDF-AE47-430A-9AF8-1E495BBF6C7D@.microsoft.com...
> Hi All,
> Can anyone please tell me if we issue "OSQL -L " at command prompt, does
> it
> lists all the SQL Servers in the network or just windows servers within
> the
> network?
> Thanks,
> VM
|||> Can anyone please tell me if we issue "OSQL -L " at command prompt, does it
> lists all the SQL Servers in the network or just windows servers within the
> network?
SQL Servers. But be carefull, because if you create an alias using Client
Network Utility, this command will list it even if the alias is not
associated with a physical server.
AMB
"VM" wrote:

> Hi All,
> Can anyone please tell me if we issue "OSQL -L " at command prompt, does it
> lists all the SQL Servers in the network or just windows servers within the
> network?
> Thanks,
> VM

OSQL -L

Hi All,
Can anyone please tell me if we issue "OSQL -L " at command prompt, does it
lists all the SQL Servers in the network or just windows servers within the
network?
Thanks,
VMIt shows you all broadcasted SQL Server instances over the net, whereas the
instances are hided for discovery.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"VM" <VM@.discussions.microsoft.com> schrieb im Newsbeitrag
news:695DABDF-AE47-430A-9AF8-1E495BBF6C7D@.microsoft.com...
> Hi All,
> Can anyone please tell me if we issue "OSQL -L " at command prompt, does
> it
> lists all the SQL Servers in the network or just windows servers within
> the
> network?
> Thanks,
> VM|||> Can anyone please tell me if we issue "OSQL -L " at command prompt, does it">
> lists all the SQL Servers in the network or just windows servers within th
e
> network?
SQL Servers. But be carefull, because if you create an alias using Client
Network Utility, this command will list it even if the alias is not
associated with a physical server.
AMB
"VM" wrote:

> Hi All,
> Can anyone please tell me if we issue "OSQL -L " at command prompt, does i
t
> lists all the SQL Servers in the network or just windows servers within th
e
> network?
> Thanks,
> VM

OSQL is Unable to see SQL Server and MSDE 2000 on the same machine

I have installed SQL Server and MSDE 2000 on my laptop under Windows XP. But I am not able to access the MSDE 2000 instance via OSQL. When I issue the command "osql -L" it lists only the SQL server (named as VSDOTNET). The MSDE 2000 instance is named as M
SSQLSERVER. The enterprise manager does not see MSSQLSERVER either. When I use the command "osql -Slocalhost\mssqlserver -Usa" and enter the password, I get the error message "[DBNETLIB]Invalid Connection.." The SQLMODE is set to mixed mode. I can access
MSSQLSERVER through a third party software (DB2KManager) but not through OSQL. Any suggestion would be greatly appreciated.
hi
"Surya Yadav" <Surya.Yadav@.ttu.edu> ha scritto nel messaggio
news:ED1D3FFF-4398-4407-8676-A79A31018BC0@.microsoft.com...
> I have installed SQL Server and MSDE 2000 on my laptop under Windows XP.
But I am not able to
>access the MSDE 2000 instance via OSQL. When I issue the command "osql -L"
it lists only the SQL >server (named as VSDOTNET). The MSDE 2000 instance is
named as MSSQLSERVER. The >enterprise manager does not see MSSQLSERVER
either. When I use the command "osql ->Slocalhost\mssqlserver -Usa" and
enter the password, I get the error message "[DBNETLIB]Invalid
>Connection.." The SQLMODE is set to mixed mode. I can access MSSQLSERVER
through a third >party software (DB2KManager) but not through OSQL. Any
suggestion would be greatly appreciated.
when installing a named instance, it's full name is
ComputerName\InstanceName or (local)\InstanceName or LocalHost\InstanceName,
those , your instance will be known as
YourCoumpeterName\VSDOTNET
(Local)\VSDOTNET
Localhost\VSDOTNET
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi,
Can you please explain it again? What am I doing wrong when I type "osql -Slocalhost\mssqlserver -Usa" ? The service is running as MSSQLSERVER when I browse under the Services icon from the Administrative tools. At the installation time I did not specify
an instance name. Setup.exe created the default instance as MSSQLSERVER. Thanks.
|||hi,
"Surya Yadav" <surya.yadav@.ttu.edu> ha scritto nel messaggio
news:0ED30CB4-1E7C-4CDC-9BAF-FA3F0742C9F0@.microsoft.com...
> Hi,
> Can you please explain it again? What am I doing wrong when I type
"osql -Slocalhost\mssqlserver -
> Usa" ? The service is running as MSSQLSERVER when I browse under the
Services icon from the
> Administrative tools. At the installation time I did not specify an
instance name. Setup.exe created the
> default instance as MSSQLSERVER. Thanks.
you said your named instance was named VSDOTNET... in this case, the full
instance name is
ComputerName\InstanceName = YourComputerName\VSDOTNET
if the installed instance is the default instance, then it's name is just
(Local)
and/or
YourComputerName
c:\>osql -S(local) -Usa
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi I have the same problem:
Installed MSDE with default instance and could then connect to it from
QSQL.
Then I uninstalled it and installed with a named instance. Now I cant
connect:
With "osql -U sa -S servername\instancename" command... -
"[DBMSLPCN]SQL Server does not exist or access denied.
[DBMSLPCN]ConnectionOpen (Connect())."
But the SQL server Manager icon next to the clock indicate that it is
running...
Is the port 1050 correct - from the log file below..
Any help / ideas will be much appreciated. More detail follow below:
I use "MSDE2000A" with the service pack 3a
My install options was:
[Options]
INSTANCENAME="instancename"
TARGETDIR="E:\SQLServer_instancename"
SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=0
In the error log file I found these:
====================================
2004-05-08 14:41:14.06 server Copyright (C) 1988-2002 Microsoft
Corporation.
2004-05-08 14:41:14.06 server All rights reserved.
2004-05-08 14:41:14.06 server Server Process ID is 2700.
2004-05-08 14:41:14.06 server Logging SQL Server messages in file
'E:\SQLServer_instancenameMSSQL$instancename\LOG\E RRORLOG'.
2004-05-08 14:41:14.06 server SQL Server is starting at priority
class 'normal'(2 CPUs detected).
2004-05-08 14:41:14.21 server SQL Server configured for thread mode
processing.
2004-05-08 14:41:14.21 server Using dynamic lock allocation. [500]
Lock Blocks, [1000] Lock Owner Blocks.
2004-05-08 14:41:14.26 spid4 Starting up database 'master'.
2004-05-08 14:41:14.32 server Using 'SSNETLIB.DLL' version
'8.0.766'.
2004-05-08 14:41:14.32 spid5 Starting up database 'model'.
2004-05-08 14:41:14.32 spid4 Server name is
'servername\instancename'.
2004-05-08 14:41:14.32 spid4 Skipping startup of clean database id
4
2004-05-08 14:41:14.34 server SQL server listening on 192.168.1.99:
1050.
2004-05-08 14:41:14.34 server SQL server listening on 127.0.0.1:
1050.
2004-05-08 14:41:14.37 spid5 Clearing tempdb database.
2004-05-08 14:41:14.40 spid5 Starting up database 'tempdb'.
2004-05-08 14:41:14.42 spid4 Recovery complete.
2004-05-08 14:41:14.42 spid4 SQL global counter collection task is
created.
2004-05-08 14:41:16.60 server SQL server listening on TCP, Shared
Memory, Named Pipes.
2004-05-08 14:41:16.60 server SQL Server is ready for client
connections

OSQL Batch File Problem

I have a scheduled task that runs a batch file in windows 2003 server which
is running SQL Server 2000 Enterprise.
The batch file contains the line:
OSQL -i myscript.sql -Umyuser -Pmypassword -Slocalhost -o mytrans.log
the 'myscript.sql' file updates a table with another table of the exact
number of rows.
When the scheduled task runs, the 'mytrans.log' file shows 0 rows were
affected.
If I run this myself from the command line, 22,000 rows are affected which
is correct.
I am guessing there is some sort of permission/authentication issue here. I
am sending the right username/password for SQL and for windows to run the
task.
Any idea what I could do to fix this?
Thanks,
J. BaezGo to schedule tasks -- Tasks tab--See the user in RUN AS: . The user
displayed there should be having write access to the folder you are writing
the log file.
After that just right click and run the task and see.
Thanks
hari
SQL Server MVP
"J. Baez" wrote:
> I have a scheduled task that runs a batch file in windows 2003 server which
> is running SQL Server 2000 Enterprise.
> The batch file contains the line:
> OSQL -i myscript.sql -Umyuser -Pmypassword -Slocalhost -o mytrans.log
> the 'myscript.sql' file updates a table with another table of the exact
> number of rows.
> When the scheduled task runs, the 'mytrans.log' file shows 0 rows were
> affected.
> If I run this myself from the command line, 22,000 rows are affected which
> is correct.
> I am guessing there is some sort of permission/authentication issue here. I
> am sending the right username/password for SQL and for windows to run the
> task.
> Any idea what I could do to fix this?
> Thanks,
> J. Baez|||That user already has full control of that directory. So it still not
working. Any other ideas?
"Hari Prasad" wrote:
> Go to schedule tasks -- Tasks tab--See the user in RUN AS: . The user
> displayed there should be having write access to the folder you are writing
> the log file.
> After that just right click and run the task and see.
> Thanks
> hari
> SQL Server MVP
> "J. Baez" wrote:
> > I have a scheduled task that runs a batch file in windows 2003 server which
> > is running SQL Server 2000 Enterprise.
> >
> > The batch file contains the line:
> >
> > OSQL -i myscript.sql -Umyuser -Pmypassword -Slocalhost -o mytrans.log
> >
> > the 'myscript.sql' file updates a table with another table of the exact
> > number of rows.
> >
> > When the scheduled task runs, the 'mytrans.log' file shows 0 rows were
> > affected.
> >
> > If I run this myself from the command line, 22,000 rows are affected which
> > is correct.
> >
> > I am guessing there is some sort of permission/authentication issue here. I
> > am sending the right username/password for SQL and for windows to run the
> > task.
> >
> > Any idea what I could do to fix this?
> >
> > Thanks,
> >
> > J. Baez

OSQL Batch File Problem

I have a scheduled task that runs a batch file in windows 2003 server which
is running SQL Server 2000 Enterprise.
The batch file contains the line:
OSQL -i myscript.sql -Umyuser -Pmypassword -Slocalhost -o mytrans.log
the 'myscript.sql' file updates a table with another table of the exact
number of rows.
When the scheduled task runs, the 'mytrans.log' file shows 0 rows were
affected.
If I run this myself from the command line, 22,000 rows are affected which
is correct.
I am guessing there is some sort of permission/authentication issue here. I
am sending the right username/password for SQL and for windows to run the
task.
Any idea what I could do to fix this?
Thanks,
J. BaezTry fully using fully qualified path for the input file -
C:\SomeFolder\mysqlscript.sql
or whatever the path is.
-Sue
.
On Tue, 22 Aug 2006 05:26:01 -0700, J. Baez
<JBaez@.discussions.microsoft.com> wrote:

>I have a scheduled task that runs a batch file in windows 2003 server which
>is running SQL Server 2000 Enterprise.
>The batch file contains the line:
>OSQL -i myscript.sql -Umyuser -Pmypassword -Slocalhost -o mytrans.log
>the 'myscript.sql' file updates a table with another table of the exact
>number of rows.
>When the scheduled task runs, the 'mytrans.log' file shows 0 rows were
>affected.
>If I run this myself from the command line, 22,000 rows are affected which
>is correct.
>I am guessing there is some sort of permission/authentication issue here.
I
>am sending the right username/password for SQL and for windows to run the
>task.
>Any idea what I could do to fix this?
>Thanks,
>J. Baez|||It is really, really helpful if you post ONLY one copy of your request.
Posting in multiple locations WITHOUT crossposting loses you the benefit of
our 'bouncing' ideas off of each other.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"J. Baez" <JBaez@.discussions.microsoft.com> wrote in message
news:90E8F840-025C-4FFE-8926-55FC25F94567@.microsoft.com...
>I have a scheduled task that runs a batch file in windows 2003 server which
> is running SQL Server 2000 Enterprise.
> The batch file contains the line:
> OSQL -i myscript.sql -Umyuser -Pmypassword -Slocalhost -o mytrans.log
> the 'myscript.sql' file updates a table with another table of the exact
> number of rows.
> When the scheduled task runs, the 'mytrans.log' file shows 0 rows were
> affected.
> If I run this myself from the command line, 22,000 rows are affected which
> is correct.
> I am guessing there is some sort of permission/authentication issue here.
> I
> am sending the right username/password for SQL and for windows to run the
> task.
> Any idea what I could do to fix this?
> Thanks,
> J. Baez
>|||Yeah...I noticed that after I replied. I think there are all
different answers, directions trying to help out with this
one on at least a few different groups. And no one knows who
is suggesting what.
It also makes it hard for others to find the answer when
they search things in the future. One post has the answer,
others don't, you only find the one without the solution,
etc.
-Sue
On Tue, 22 Aug 2006 13:19:49 -0700, "Arnie Rowland"
<arnie@.1568.com> wrote:

>It is really, really helpful if you post ONLY one copy of your request.
>Posting in multiple locations WITHOUT crossposting loses you the benefit of
>our 'bouncing' ideas off of each other.

OSQL Batch File Problem

I have a scheduled task that runs a batch file in windows 2003 server which
is running SQL Server 2000 Enterprise.
The batch file contains the line:
OSQL -i myscript.sql -Umyuser -Pmypassword -Slocalhost -o mytrans.log
the 'myscript.sql' file updates a table with another table of the exact
number of rows.
When the scheduled task runs, the 'mytrans.log' file shows 0 rows were
affected.
If I run this myself from the command line, 22,000 rows are affected which
is correct.
I am guessing there is some sort of permission/authentication issue here. I
am sending the right username/password for SQL and for windows to run the
task.
Any idea what I could do to fix this?
Thanks,
J. BaezGo to schedule tasks -- Tasks tab--See the user in RUN AS: . The user
displayed there should be having write access to the folder you are writing
the log file.
After that just right click and run the task and see.
Thanks
hari
SQL Server MVP
"J. Baez" wrote:

> I have a scheduled task that runs a batch file in windows 2003 server whic
h
> is running SQL Server 2000 Enterprise.
> The batch file contains the line:
> OSQL -i myscript.sql -Umyuser -Pmypassword -Slocalhost -o mytrans.log
> the 'myscript.sql' file updates a table with another table of the exact
> number of rows.
> When the scheduled task runs, the 'mytrans.log' file shows 0 rows were
> affected.
> If I run this myself from the command line, 22,000 rows are affected which
> is correct.
> I am guessing there is some sort of permission/authentication issue here.
I
> am sending the right username/password for SQL and for windows to run the
> task.
> Any idea what I could do to fix this?
> Thanks,
> J. Baez|||That user already has full control of that directory. So it still not
working. Any other ideas?
"Hari Prasad" wrote:
[vbcol=seagreen]
> Go to schedule tasks -- Tasks tab--See the user in RUN AS: . The user
> displayed there should be having write access to the folder you are writin
g
> the log file.
> After that just right click and run the task and see.
> Thanks
> hari
> SQL Server MVP
> "J. Baez" wrote:
>

OS Upgrade on SQL 2005 Server

I'm running SQL 2005 on a Windows 2000 server. I would like to upgrade the OS to Windows 2003 server. Is there a whitepaper with all the required steps listed?

Thanks,

Dave

I'm not aware of any specific one, but I'm fairly certain that upgrade whitepapers exist for Windows 2000 to 2003. I would simply start by doing a search of Microsoft's website.|||

http://www.microsoft.com/windowsserver2003/upgrading/w2k/default.mspx

http://technet2.microsoft.com/WindowsServer/en/library/42d81246-a993-4d46-9a92-39011dc7f2ab1033.mspx

Googled got the above nearest links.