Sql ANSI Padding: version

显示标签为“version”的博文。显示所有博文

2012年3月27日星期二

Anyone recently installed SQL Server 2000 Eval version

Hello,

I am having trouble installing Evaluation copy of SQL Server on my
notebook, which has XP, P4 processor,1G Ram, and 14 G harddisk space.

After I run the Setup.exe, I get the files files extracted in the
SQLEVAL directory.

As per the instruction, I need to run Autorun.exe file. For some
reason, when I try to run this file, a new windows pops up, which is
blank black screen with cursor flying around in the window. The title
of the window is
C:\windows\system32\wowexec.exe

This is how far I have reached while trying to install the database. I
would really appreciate if someone could provide some suggestions.

VS"TinTin" <lalalulu24@.yahoo.com> wrote in message
news:2d5425d1.0404021102.1ac7269f@.posting.google.c om...
> Hello,
> I am having trouble installing Evaluation copy of SQL Server on my
> notebook, which has XP, P4 processor,1G Ram, and 14 G harddisk space.
> After I run the Setup.exe, I get the files files extracted in the
> SQLEVAL directory.
> As per the instruction, I need to run Autorun.exe file. For some
> reason, when I try to run this file, a new windows pops up, which is
> blank black screen with cursor flying around in the window. The title
> of the window is
> C:\windows\system32\wowexec.exe
> This is how far I have reached while trying to install the database. I
> would really appreciate if someone could provide some suggestions.
> VS

I have no idea what the problem is, but perhaps you could try running the
setup program directly - I think it's called setupsql.exe, in the \setup
folder (from memory).

Simon|||> I
> would really appreciate if someone could provide some suggestions.

http://otn.oracle.com/software/prod...e10g/index.html :-)

Anyone know of a good T-Sql Reference Code book?

Hi does anyone know of a good book that has all the t-sql keywords and functions in?? Or a webiste that has a printable version with explanations. I knows its on msdn but its very hard to print it all off.

I need something by my side so I can refer too and use in helping me build statements and sp,s etc.

Thanksfirst up, books online has the entire thing, though you can't print the lot at once.

secondly, MS Press has a complete reference called the SQL Server 2000 Reference Library. I'm not sure if it's available separately, but book 5 of the 6-book set is the complete T-SQL language reference. It's a tad expensive for the whole thing, and a web developer probably doesn't need the OLAP and warehousing books, but well worthwhile if you intend working heavily with SQL 2000. and it looks impressive on your bookshelf too.|||I would also think that the SQL Books Online are a very good resource (though oerhaps you might need to know the keyword to find information). Search for "Reserved Keywords" in Books Online (limit it to in Subject only) and you will get a good list of reserved words you can then search for details.|||Checkout something I made some time ago,
(the second page can B useful sometimes)

SQL.doc

2012年3月19日星期一

Any way to create 5KB size of Database?

Hi
when we create new database that will take base structure and size of the
model database. it will be approx 1.43 MB as per version. now i want to
create database that size is 5kb any way to create database like that size,
why the reason is for CD technolgy we have less space.. can u suggest me?
Thanks
Sriram.Srikanth
SQL-Server Database Administrator,
Hi
The newly created DB gets it's sizing from Model DB. Model DB can not be
made smaller. With all the structures needed in the MDF and LDF files,
1.43mb is the smallest you can get.
Why ship the DB? Create the DB though T-SQL code on the client machine.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"SRIRAM" <SRIRAM_SRIKANTH@.HOTMAIL.COM> wrote in message
news:4F0ECF58-54FD-40E6-A0BF-96F6EAF97ED0@.microsoft.com...
> Hi
> when we create new database that will take base structure and size of the
> model database. it will be approx 1.43 MB as per version. now i want to
> create database that size is 5kb any way to create database like that
size,
> why the reason is for CD technolgy we have less space.. can u suggest me?
> Thanks
> --
> Sriram.Srikanth
> SQL-Server Database Administrator,
>
|||What you could do is distribute the MDF file only, in a zipped version...
Then unzip it, and use sp_attach_single_file_db to load it up..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"SRIRAM" <SRIRAM_SRIKANTH@.HOTMAIL.COM> wrote in message
news:4F0ECF58-54FD-40E6-A0BF-96F6EAF97ED0@.microsoft.com...
> Hi
> when we create new database that will take base structure and size of the
> model database. it will be approx 1.43 MB as per version. now i want to
> create database that size is 5kb any way to create database like that
> size,
> why the reason is for CD technolgy we have less space.. can u suggest me?
> Thanks
> --
> Sriram.Srikanth
> SQL-Server Database Administrator,
>
|||You could also simply distribute the create database/object script. This
would insulate you from physical changes to the mdf file, which is a risk
with the other way I mentioned.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"SRIRAM" <SRIRAM_SRIKANTH@.HOTMAIL.COM> wrote in message
news:4F0ECF58-54FD-40E6-A0BF-96F6EAF97ED0@.microsoft.com...
> Hi
> when we create new database that will take base structure and size of the
> model database. it will be approx 1.43 MB as per version. now i want to
> create database that size is 5kb any way to create database like that
> size,
> why the reason is for CD technolgy we have less space.. can u suggest me?
> Thanks
> --
> Sriram.Srikanth
> SQL-Server Database Administrator,
>

Any way to create 5KB size of Database?

Hi
when we create new database that will take base structure and size of the
model database. it will be approx 1.43 MB as per version. now i want to
create database that size is 5kb any way to create database like that size,
why the reason is for CD technolgy we have less space.. can u suggest me?
Thanks
--
Sriram.Srikanth
SQL-Server Database Administrator,Hi
The newly created DB gets it's sizing from Model DB. Model DB can not be
made smaller. With all the structures needed in the MDF and LDF files,
1.43mb is the smallest you can get.
Why ship the DB? Create the DB though T-SQL code on the client machine.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"SRIRAM" <SRIRAM_SRIKANTH@.HOTMAIL.COM> wrote in message
news:4F0ECF58-54FD-40E6-A0BF-96F6EAF97ED0@.microsoft.com...
> Hi
> when we create new database that will take base structure and size of the
> model database. it will be approx 1.43 MB as per version. now i want to
> create database that size is 5kb any way to create database like that
size,
> why the reason is for CD technolgy we have less space.. can u suggest me?
> Thanks
> --
> Sriram.Srikanth
> SQL-Server Database Administrator,
>|||What you could do is distribute the MDF file only, in a zipped version...
Then unzip it, and use sp_attach_single_file_db to load it up..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"SRIRAM" <SRIRAM_SRIKANTH@.HOTMAIL.COM> wrote in message
news:4F0ECF58-54FD-40E6-A0BF-96F6EAF97ED0@.microsoft.com...
> Hi
> when we create new database that will take base structure and size of the
> model database. it will be approx 1.43 MB as per version. now i want to
> create database that size is 5kb any way to create database like that
> size,
> why the reason is for CD technolgy we have less space.. can u suggest me?
> Thanks
> --
> Sriram.Srikanth
> SQL-Server Database Administrator,
>|||You could also simply distribute the create database/object script. This
would insulate you from physical changes to the mdf file, which is a risk
with the other way I mentioned.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"SRIRAM" <SRIRAM_SRIKANTH@.HOTMAIL.COM> wrote in message
news:4F0ECF58-54FD-40E6-A0BF-96F6EAF97ED0@.microsoft.com...
> Hi
> when we create new database that will take base structure and size of the
> model database. it will be approx 1.43 MB as per version. now i want to
> create database that size is 5kb any way to create database like that
> size,
> why the reason is for CD technolgy we have less space.. can u suggest me?
> Thanks
> --
> Sriram.Srikanth
> SQL-Server Database Administrator,
>

Any way to create 5KB size of Database?

Hi
when we create new database that will take base structure and size of the
model database. it will be approx 1.43 MB as per version. now i want to
create database that size is 5kb any way to create database like that size,
why the reason is for CD technolgy we have less space.. can u suggest me?
Thanks
--
Sriram.Srikanth
SQL-Server Database Administrator,Hi
The newly created DB gets it's sizing from Model DB. Model DB can not be
made smaller. With all the structures needed in the MDF and LDF files,
1.43mb is the smallest you can get.
Why ship the DB? Create the DB though T-SQL code on the client machine.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"SRIRAM" <SRIRAM_SRIKANTH@.HOTMAIL.COM> wrote in message
news:4F0ECF58-54FD-40E6-A0BF-96F6EAF97ED0@.microsoft.com...
> Hi
> when we create new database that will take base structure and size of the
> model database. it will be approx 1.43 MB as per version. now i want to
> create database that size is 5kb any way to create database like that
size,
> why the reason is for CD technolgy we have less space.. can u suggest me?
> Thanks
> --
> Sriram.Srikanth
> SQL-Server Database Administrator,
>|||What you could do is distribute the MDF file only, in a zipped version...
Then unzip it, and use sp_attach_single_file_db to load it up..
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"SRIRAM" <SRIRAM_SRIKANTH@.HOTMAIL.COM> wrote in message
news:4F0ECF58-54FD-40E6-A0BF-96F6EAF97ED0@.microsoft.com...
> Hi
> when we create new database that will take base structure and size of the
> model database. it will be approx 1.43 MB as per version. now i want to
> create database that size is 5kb any way to create database like that
> size,
> why the reason is for CD technolgy we have less space.. can u suggest me?
> Thanks
> --
> Sriram.Srikanth
> SQL-Server Database Administrator,
>|||You could also simply distribute the create database/object script. This
would insulate you from physical changes to the mdf file, which is a risk
with the other way I mentioned.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"SRIRAM" <SRIRAM_SRIKANTH@.HOTMAIL.COM> wrote in message
news:4F0ECF58-54FD-40E6-A0BF-96F6EAF97ED0@.microsoft.com...
> Hi
> when we create new database that will take base structure and size of the
> model database. it will be approx 1.43 MB as per version. now i want to
> create database that size is 5kb any way to create database like that
> size,
> why the reason is for CD technolgy we have less space.. can u suggest me?
> Thanks
> --
> Sriram.Srikanth
> SQL-Server Database Administrator,
>

2012年3月11日星期日

Any unique datetime's in SQL2005?

Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"jxstern" <jxstern@.nowhere.xyz> wrote in message
news:quqpo15ejq4biu6cgsg2nkiedr92dinok1@.
4ax.com...
> Once upon a time, some version of SQLServer was supposed to do
> timestamps as datetimes, so you could have a guaranteed unique token
> that decoded to a real date/time. I believe this was supposed to be
> the ANSI standard for SQL as well.
> Has this yet been delivered in SQL2005?
> (I think not, but am not certain, and would like to have it for
> something I'm doing right now! I should have SQL2005 loaded here in a
> few days, but thanks in advance for any answer to this. btw, I don't
> see the SQL2005 documentation yet online at MSDN.microsoft.com)
> J.
>

Any unique datetime's in SQL2005?

Once upon a time, some version of SQLServer was supposed to do
timestamps as datetimes, so you could have a guaranteed unique token
that decoded to a real date/time. I believe this was supposed to be
the ANSI standard for SQL as well.
Has this yet been delivered in SQL2005?
(I think not, but am not certain, and would like to have it for
something I'm doing right now! I should have SQL2005 loaded here in a
few days, but thanks in advance for any answer to this. btw, I don't
see the SQL2005 documentation yet online at MSDN.microsoft.com)
J.No. :(
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"jxstern" <jxstern@.nowhere.xyz> wrote in message
news:quqpo15ejq4biu6cgsg2nkiedr92dinok1@.4ax.com...
> Once upon a time, some version of SQLServer was supposed to do
> timestamps as datetimes, so you could have a guaranteed unique token
> that decoded to a real date/time. I believe this was supposed to be
> the ANSI standard for SQL as well.
> Has this yet been delivered in SQL2005?
> (I think not, but am not certain, and would like to have it for
> something I'm doing right now! I should have SQL2005 loaded here in a
> few days, but thanks in advance for any answer to this. btw, I don't
> see the SQL2005 documentation yet online at MSDN.microsoft.com)
> J.
>

Any unique datetime's in SQL2005?

Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
"jxstern" <jxstern@.nowhere.xyz> wrote in message
news:quqpo15ejq4biu6cgsg2nkiedr92dinok1@.4ax.com...
> Once upon a time, some version of SQLServer was supposed to do
> timestamps as datetimes, so you could have a guaranteed unique token
> that decoded to a real date/time. I believe this was supposed to be
> the ANSI standard for SQL as well.
> Has this yet been delivered in SQL2005?
> (I think not, but am not certain, and would like to have it for
> something I'm doing right now! I should have SQL2005 loaded here in a
> few days, but thanks in advance for any answer to this. btw, I don't
> see the SQL2005 documentation yet online at MSDN.microsoft.com)
> J.
>

Any standalone version of SQL2005 Express?

Many Microsoft applications use a local installation of the Native Client
which you'll find is similar to SQL Express. For example, the Small
Business Contact Manager, the ISA firewall on Small Business Server,
Sharepoint. As far as free goes, it is free to use the SQL Express on your
own machine, but there are limits on connections to the database, limits on
the amount of RAM and number of processors accessible so it is not a fully
functions SERVER but as a server, it runs on your local machine in a way
similar to a server. You can create databases, attach databases, detach
databases, query databases and use much of the functionality that is
available on a full version (Standard or Enterprise) but there will be
limitaions. Don't quote me on this but I believe that the free version of
SQL Express comes with a GUI as well so you won't need to run queries through
DOS. As to why it won't install on your system, there may be other software
there that needs to be uninstalled first, or it is also possible that the
setup of your server is such that it is being denied permission to system
resources.
My suggestion would be to uninstall what you have (Add Remove programs),
redownload (http://msdn2.microsoft.com/en-us/express/aa718378.aspx), and then
reinstall. When you install, accept the defaults on the installation - it
would help if you read the documentation from the link as well.
Regards,
Jamie
"aNewbie" wrote:

> Hello All,
> Just want to know is there any stand alone version of the SQL 2005 Express?
> As I would need to run a database on a laptop, but the policy is set to not
> allowing any installations... Anyway I can unzip/unpack it and run it off
> just like that? Thank you!
>
> THanks & Best Regards,
> aNewbie

|||I guess your laptop belogs to your company or something similar so it's not
allowed installing additional stuff on it?
If so, you can not install any version of SQL Server 2005 on your laptop
because there is no such a version to unzip or something as far as I know.
The installer of SQL Server has to run and install the necessary apps in its
packs included .Net Framework if it's not installed yet.
Ekrem ?nsoy
"aNewbie" <aNewbie@.discussions.microsoft.com> wrote in message
news:B58013A7-E3FA-49CE-BC8F-86010355EED4@.microsoft.com...
> Hello All,
> Just want to know is there any stand alone version of the SQL 2005
> Express?
> As I would need to run a database on a laptop, but the policy is set to
> not
> allowing any installations... Anyway I can unzip/unpack it and run it off
> just like that? Thank you!
>
> THanks & Best Regards,
> aNewbie

|||Thanks thejamie and Ekrem ?nsoy,
And yes, is the company policy that got into way, sorry I didn't state that
clearly earlier...
I know the Setup Wizard will help me to config the nesseary settings and
..Net framework. So that I will not need to do it manual, and I can benefit
the nice GUI too. But sometime when just want to do things quickly on a
laptop, and don't want to go through all the paper work and requests to the
IT dep, a "stand alone" version would be very welcome (and of course, with
the GUI too).
It would be very nice if there is a "stand alone" version... especially when
people just want to do some quick work without installing it. Anyway,...
Thanks again from both of you. Atleast I know there is no standalone SQL
Express... And I would need to move on and find another brand that it has
one...
Thanks & Best Regards,
aNewbie
"Ekrem ?nsoy" wrote:

> I guess your laptop belogs to your company or something similar so it's not
> allowed installing additional stuff on it?
> If so, you can not install any version of SQL Server 2005 on your laptop
> because there is no such a version to unzip or something as far as I know.
> The installer of SQL Server has to run and install the necessary apps in its
> packs included .Net Framework if it's not installed yet.
> --
> Ekrem ?nsoy
>
> "aNewbie" <aNewbie@.discussions.microsoft.com> wrote in message
> news:B58013A7-E3FA-49CE-BC8F-86010355EED4@.microsoft.com...
>

Any standalone version of SQL2005 Express?

Many Microsoft applications use a local installation of the Native Client
which you'll find is similar to SQL Express. For example, the Small
Business Contact Manager, the ISA firewall on Small Business Server,
Sharepoint. As far as free goes, it is free to use the SQL Express on your
own machine, but there are limits on connections to the database, limits on
the amount of RAM and number of processors accessible so it is not a fully
functions SERVER but as a server, it runs on your local machine in a way
similar to a server. You can create databases, attach databases, detach
databases, query databases and use much of the functionality that is
available on a full version (Standard or Enterprise) but there will be
limitaions. Don't quote me on this but I believe that the free version of
SQL Express comes with a GUI as well so you won't need to run queries throug
h
DOS. As to why it won't install on your system, there may be other softwar
e
there that needs to be uninstalled first, or it is also possible that the
setup of your server is such that it is being denied permission to system
resources.
My suggestion would be to uninstall what you have (Add Remove programs),
redownload (http://msdn2.microsoft.com/en-us/express/aa718378.aspx), and the
n
reinstall. When you install, accept the defaults on the installation - it
would help if you read the documentation from the link as well.
--
Regards,
Jamie
"aNewbie" wrote:

> Hello All,
> Just want to know is there any stand alone version of the SQL 2005 Express
?
> As I would need to run a database on a laptop, but the policy is set to no
t
> allowing any installations... Anyway I can unzip/unpack it and run it off
> just like that? Thank you!
>
> THanks & Best Regards,
> aNewbie

|||Thanks thejamie and Ekrem ?nsoy,
And yes, is the company policy that got into way, sorry I didn't state that
clearly earlier...
I know the Setup Wizard will help me to config the nesseary settings and
.Net framework. So that I will not need to do it manual, and I can benefit
the nice GUI too. But sometime when just want to do things quickly on a
laptop, and don't want to go through all the paper work and requests to the
IT dep, a "stand alone" version would be very welcome (and of course, with
the GUI too).
It would be very nice if there is a "stand alone" version... especially when
people just want to do some quick work without installing it. Anyway,...
Thanks again from both of you. Atleast I know there is no standalone SQL
Express... And I would need to move on and find another brand that it has
one...
Thanks & Best Regards,
aNewbie
"Ekrem ?nsoy" wrote:

> I guess your laptop belogs to your company or something similar so it's no
t
> allowed installing additional stuff on it?
> If so, you can not install any version of SQL Server 2005 on your laptop
> because there is no such a version to unzip or something as far as I know.
> The installer of SQL Server has to run and install the necessary apps in i
ts
> packs included .Net Framework if it's not installed yet.
> --
> Ekrem ?nsoy
>
> "aNewbie" <aNewbie@.discussions.microsoft.com> wrote in message
> news:B58013A7-E3FA-49CE-BC8F-86010355EED4@.microsoft.com...
>

Any standalone version of SQL2005 Express?

Hello All,
Just want to know is there any stand alone version of the SQL 2005 Express?
As I would need to run a database on a laptop, but the policy is set to not
allowing any installations... Anyway I can unzip/unpack it and run it off
just like that? Thank you!
THanks & Best Regards,
aNewbie :)Many Microsoft applications use a local installation of the Native Client
which you'll find is similar to SQL Express. For example, the Small
Business Contact Manager, the ISA firewall on Small Business Server,
Sharepoint. As far as free goes, it is free to use the SQL Express on your
own machine, but there are limits on connections to the database, limits on
the amount of RAM and number of processors accessible so it is not a fully
functions SERVER but as a server, it runs on your local machine in a way
similar to a server. You can create databases, attach databases, detach
databases, query databases and use much of the functionality that is
available on a full version (Standard or Enterprise) but there will be
limitaions. Don't quote me on this but I believe that the free version of
SQL Express comes with a GUI as well so you won't need to run queries through
DOS. As to why it won't install on your system, there may be other software
there that needs to be uninstalled first, or it is also possible that the
setup of your server is such that it is being denied permission to system
resources.
My suggestion would be to uninstall what you have (Add Remove programs),
redownload (http://msdn2.microsoft.com/en-us/express/aa718378.aspx), and then
reinstall. When you install, accept the defaults on the installation - it
would help if you read the documentation from the link as well.
--
Regards,
Jamie
"aNewbie" wrote:
> Hello All,
> Just want to know is there any stand alone version of the SQL 2005 Express?
> As I would need to run a database on a laptop, but the policy is set to not
> allowing any installations... Anyway I can unzip/unpack it and run it off
> just like that? Thank you!
>
> THanks & Best Regards,
> aNewbie :)|||I guess your laptop belogs to your company or something similar so it's not
allowed installing additional stuff on it?
If so, you can not install any version of SQL Server 2005 on your laptop
because there is no such a version to unzip or something as far as I know.
The installer of SQL Server has to run and install the necessary apps in its
packs included .Net Framework if it's not installed yet.
--
Ekrem Ã?nsoy
"aNewbie" <aNewbie@.discussions.microsoft.com> wrote in message
news:B58013A7-E3FA-49CE-BC8F-86010355EED4@.microsoft.com...
> Hello All,
> Just want to know is there any stand alone version of the SQL 2005
> Express?
> As I would need to run a database on a laptop, but the policy is set to
> not
> allowing any installations... Anyway I can unzip/unpack it and run it off
> just like that? Thank you!
>
> THanks & Best Regards,
> aNewbie :)|||Thanks thejamie and Ekrem Ã?nsoy,
And yes, is the company policy that got into way, sorry I didn't state that
clearly earlier...
I know the Setup Wizard will help me to config the nesseary settings and
.Net framework. So that I will not need to do it manual, and I can benefit
the nice GUI too. But sometime when just want to do things quickly on a
laptop, and don't want to go through all the paper work and requests to the
IT dep, a "stand alone" version would be very welcome (and of course, with
the GUI too).
It would be very nice if there is a "stand alone" version... especially when
people just want to do some quick work without installing it. Anyway,...
Thanks again from both of you. Atleast I know there is no standalone SQL
Express... And I would need to move on and find another brand that it has
one...
Thanks & Best Regards,
aNewbie
"Ekrem Ã?nsoy" wrote:
> I guess your laptop belogs to your company or something similar so it's not
> allowed installing additional stuff on it?
> If so, you can not install any version of SQL Server 2005 on your laptop
> because there is no such a version to unzip or something as far as I know.
> The installer of SQL Server has to run and install the necessary apps in its
> packs included .Net Framework if it's not installed yet.
> --
> Ekrem Ã?nsoy
>
> "aNewbie" <aNewbie@.discussions.microsoft.com> wrote in message
> news:B58013A7-E3FA-49CE-BC8F-86010355EED4@.microsoft.com...
> > Hello All,
> >
> > Just want to know is there any stand alone version of the SQL 2005
> > Express?
> > As I would need to run a database on a laptop, but the policy is set to
> > not
> > allowing any installations... Anyway I can unzip/unpack it and run it off
> > just like that? Thank you!
> >
> >
> > THanks & Best Regards,
> > aNewbie :)
>

2012年3月8日星期四

Any SQL Server 2000 and XP SP2 issues?

There is a recent news article that indicates that Microsoft has "warned"
its customers about SQL Server 2000 (version not identified) not being
compatible with the XP SP 2.
I went to the MS website and searched everything I could find on the RTM
version of SP2. I found no such warning ... I found "issues" that could
come up if the Firewall is enabled and how to modify the settings so that
you could get to the SQL Server 2000 if there were problems.
I have installed MSDE on an XP Pro machine with all SPs and fixes up to but
not including SP2 and wanted to make sure that I didn't do anything to screw
up our current development processes ... we're in the middle of a large dev
project and didn't want to bring everything to a grinding halt.
Yes, we will install SP2 and test to make sure that our .NET apps will work
under SP2 but I want to do it in a "controlled manner" ... not an
inadvertent shutdown in the middle.
Anyone know of any issues, other than the Firewall, that makes SQL Server
2000 incompatible with XP SP2?
Thanks...
RonHi Ron,
Thanks for using MSDN Managed Newsgroup!
Here are some links showing why it is warned using SQL Server / MSDE with
XP SP2
"some programs may seem not to work. By default, Windows Firewall is
enabled and blocks unsolicited connections to your computer"
Some programs seem to stop working after you install Windows XP Service
Pack 2
http://support.microsoft.com/default.aspx?kbid=842242
--
"After you install Microsoft Windows XP Service Pack 2 on a computer that
is configured as a distributor, if you try to synchronize data from a
subscriber that is configured on a remote computer, you may notice that the
changes that are made in the subscriber database are not updated to the
publisher database."
BUG: The changes in a remote subscriber are not updated to the publisher
for a queued updating replication that uses Message Queuing on a
computer that is running Windows XP Service Pack 2
http://support.microsoft.com/default.aspx?kbid=839278
--
"You may not be able to connect to an instance of SQL Server, and you may
receive one of the following error messages.
[Named Pipes]SQL Server does not exist or access denied.
Unable to connect to server <SQL Server instance name>"
You may not be able to connect to an instance of SQL Server that is
configured to use the Named Pipes server network library on a computer
that is running Windows XP Service Pack 2
http://support.microsoft.com/?id=839269
--
"When you run a distributed transaction against an instance of SQL Server,
you may receive an error message that is similar to the following:
Server: Msg 7391, Level 16, State 1, Line 1"
You may receive a 7391 error message in SQL Server 2000 when you run a
distributed transaction against a linked server after you install Microsoft
Windows XP Service Pack 2
http://support.microsoft.com/?id=839279
--
" the SQL debugging feature in Microsoft Visual Studio .NET 2003 (Visual
Studio .NET) does not work. When you try to debug a SQL Server stored
procedure by using the Step Into Stored Procedure option in the Server
Explorer pane, you may receive the following error message:
Cannot debug stored procedures because the SQL Server database is not setup
correctly or user does not have permission to execute master.sp_sdidebug.
Run SQL Server setup or contact database administrator."
BUG: SQL debugging does not work in Visual Studio .NET after you install
Windows XP Service Pack 2
http://support.microsoft.com/?id=839280
--
"When you install Microsoft SQL Server 2000 or Microsoft SQL Server Desktop
Engine (also known as MSDE 2000) on a computer that is running Microsoft
Windows XP Service Pack 2 (SP2), a message is logged in the application
event log. The message states that the instance of SQL Server or the
instance of MSDE is vulnerable to virus attacks."
A message stating that an instance of SQL Server is vulnerable to virus
attacks is logged in the application event log when you install SQL Server
2000 or MSDE 2000 on a computer that is running Windows XP Service Pack 2
http://support.microsoft.com/?id=841375
--
"When you run a distributed transaction against an instance of SQL Server,
you may receive an error message that is similar to the following:
Server: Msg 7391, Level 16, State 1, Line 1 "
You may receive a 7391 error message in SQLOLEDB when you run a distributed
transaction against a linked server after you install Microsoft Windows XP
Service Pack 2
http://support.microsoft.com/?id=873160
--
Here is another very useful link for you about how to troubleshooting
Windows Firewall settings in Windows XP SP2
Troubleshooting Windows Firewall settings in Windows XP Service Pack 2
http://support.microsoft.com/default.aspx?kbid=875357
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Ron,
Additionally, I would like to provide five HOW-TO articiles for
configuration SQL Server with XP SP2.
How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server
http://support.microsoft.com/?id=841249
How to enable SQL Server connectivity on Windows XP Service Pack 2
http://support.microsoft.com/?id=841251
How to manually enable TCP/IP on Windows XP Service Pack 2 for SQL Server
2000
http://support.microsoft.com/?id=841252
How to enable SQL Server 2000 Reporting Services on Windows XP Service Pack
2
http://support.microsoft.com/?id=841253
How to enable the ISAPI component on SQLXML on Windows XP Service Pack 2
http://support.microsoft.com/default.aspx?kbid=842005
How to enable SQL Server 2000 Analysis Services and OLAP Services on
computers that are running Windows XP SP2
http://support.microsoft.com/?id=841256
How to use a script to programmatically open ports for SQL Server to use on
systems that are running Windows XP Service Pack 2
http://support.microsoft.com/default.aspx?kbid=839980
Thank you for your patience and cooperation again. If you have any
questions or concerns, don't hesitate to let me know. We are here to be of
assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Thank you very much for both replies. Your replies were both thorough and
very helpful.
I will back the machines up and begin installing SP2 on Saturday.
Hopefully, I will be able to report successful and uneventful installations
on Monday.
Again, many thanks...
Ron
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in messa
ge
news:g5WOYOOgEHA.3356@.cpmsftngxa06.phx.gbl...
> Hi Ron,
> Additionally, I would like to provide five HOW-TO articiles for
> configuration SQL Server with XP SP2.
> How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server
> http://support.microsoft.com/?id=841249
> How to enable SQL Server connectivity on Windows XP Service Pack 2
> http://support.microsoft.com/?id=841251
> How to manually enable TCP/IP on Windows XP Service Pack 2 for SQL Server
> 2000
> http://support.microsoft.com/?id=841252
> How to enable SQL Server 2000 Reporting Services on Windows XP Service
Pack
> 2
> http://support.microsoft.com/?id=841253
> How to enable the ISAPI component on SQLXML on Windows XP Service Pack 2
> http://support.microsoft.com/default.aspx?kbid=842005
> How to enable SQL Server 2000 Analysis Services and OLAP Services on
> computers that are running Windows XP SP2
> http://support.microsoft.com/?id=841256
> How to use a script to programmatically open ports for SQL Server to use
on
> systems that are running Windows XP Service Pack 2
> http://support.microsoft.com/default.aspx?kbid=839980
> Thank you for your patience and cooperation again. If you have any
> questions or concerns, don't hesitate to let me know. We are here to be of
> assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Developer Community Support
> ---
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||If you use Visual Studio.Net to debug SQL Stored Proceedures you'll
want to wait. More details are at
http://support.microsoft.com/?kbid=839280. If anyone knows of a way
around this problem, please let me know.
Ken Kimball [kkimball@.gmail.com]
"Ron Fluegge" <rmflugge@.swbell.net> wrote in message news:<#i24S0HgEHA.904@.TK2MSFTNGP09.phx.
gbl>...
> There is a recent news article that indicates that Microsoft has "warned"
> its customers about SQL Server 2000 (version not identified) not being
> compatible with the XP SP 2.
> I went to the MS website and searched everything I could find on the RTM
> version of SP2. I found no such warning ... I found "issues" that could
> come up if the Firewall is enabled and how to modify the settings so that
> you could get to the SQL Server 2000 if there were problems.
> I have installed MSDE on an XP Pro machine with all SPs and fixes up to bu
t
> not including SP2 and wanted to make sure that I didn't do anything to scr
ew
> up our current development processes ... we're in the middle of a large de
v
> project and didn't want to bring everything to a grinding halt.
> Yes, we will install SP2 and test to make sure that our .NET apps will wor
k
> under SP2 but I want to do it in a "controlled manner" ... not an
> inadvertent shutdown in the middle.
> Anyone know of any issues, other than the Firewall, that makes SQL Server
> 2000 incompatible with XP SP2?
> Thanks...
> Ron|||Ken,
Yes, I was aware of that problem. I do use VS 2003 to develop apps but do
not use SQL Stored Procedures (for a number of reasons specific to our
apps).
I was very surprised to find the number of "issues" related to SQL Server
2000 given that is the current release of MS's SQL Server -- especially
since there is nothing to indicate that patches or fixes are forthcoming.
On the same XP Pro machine, I'm also running Oracle 9i and I'm hoping that
it doesn't come to a crashing halt as well. (These are used for
"development" and not for production databases)
Ron
"Ken Kimball" <kkimball@.gmail.com> wrote in message
news:466a0cb4.0408130512.4468a03a@.posting.google.com...
> If you use Visual Studio.Net to debug SQL Stored Proceedures you'll
> want to wait. More details are at
> http://support.microsoft.com/?kbid=839280. If anyone knows of a way
> around this problem, please let me know.
> Ken Kimball [kkimball@.gmail.com]
> "Ron Fluegge" <rmflugge@.swbell.net> wrote in message
news:<#i24S0HgEHA.904@.TK2MSFTNGP09.phx.gbl>...[vbcol=seagreen]
"warned"[vbcol=seagreen]
that[vbcol=seagreen]
but[vbcol=seagreen]
screw[vbcol=seagreen]
dev[vbcol=seagreen]
work[vbcol=seagreen]
Server[vbcol=seagreen]|||You might also check out:
Finally, you should absolutely watch and learn from the webcast titled MSDN
Webcast: SQL Server and Windows XP SP2 - Level 300 available at
S" target="_blank">http://msevents.microsoft.com/CUI/E...e=en-U
S
I found it to be very helpful.
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Ron Fluegge" <rmflugge@.swbell.net> wrote in message
news:e9BEMnPgEHA.1972@.TK2MSFTNGP09.phx.gbl...
> Thank you very much for both replies. Your replies were both thorough and
> very helpful.
> I will back the machines up and begin installing SP2 on Saturday.
> Hopefully, I will be able to report successful and uneventful
installations
> on Monday.
> Again, many thanks...
> Ron
> ""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in mes
sage
> news:g5WOYOOgEHA.3356@.cpmsftngxa06.phx.gbl...
Server[vbcol=seagreen]
> Pack
> on
of[vbcol=seagreen]
rights.[vbcol=seagreen]
>|||Brian,
Will do ... THANKS VERY MUCH!!!
Ron
"Brian Moran" <brian@.solidqualitylearning.com> wrote in message
news:OOHq06UgEHA.1764@.TK2MSFTNGP10.phx.gbl...
> You might also check out:
> Finally, you should absolutely watch and learn from the webcast titled
'MSDN
> Webcast: SQL Server and Windows XP SP2 - Level 300 ' available at
>
http://msevents.microsoft.com/CUI/E...0&Culture=en-USagreen">
>
> I found it to be very helpful.
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "Ron Fluegge" <rmflugge@.swbell.net> wrote in message
> news:e9BEMnPgEHA.1972@.TK2MSFTNGP09.phx.gbl...
and[vbcol=seagreen]
> installations
message[vbcol=seagreen]
Server[vbcol=seagreen]
> Server
2[vbcol=seagreen]
use[vbcol=seagreen]
be[vbcol=seagreen]
> of
> rights.
>|||Hi Ron,
If you encounter any questions or concerns when upgrading to Windows XP
Service Pack 2, please feel free to reply here or make a new thread. We
would love to make a follow up until that issue is completely resolved.
Good Luck!
Thank you for your patience and cooperation.
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||I just finished the upgrade to SP2 ... on this machine I have both SQL
Server 2000 and Oracle 9i as well as VS 2003 -- it's my development machine.
It all went well without a hitch!!!
Everything is up and running without any problems so far software or
hardware-wise. I have a dual AMD MoBo with RAID controllers and it is
having no problems.
So needless to say, I am a happy camper ...
Ron
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in messa
ge
news:v7ocVFcgEHA.480@.cpmsftngxa06.phx.gbl...
> Hi Ron,
> If you encounter any questions or concerns when upgrading to Windows XP
> Service Pack 2, please feel free to reply here or make a new thread. We
> would love to make a follow up until that issue is completely resolved.
> Good Luck!
> Thank you for your patience and cooperation.
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Developer Community Support
> ---
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>

Any SQL Server 2000 and XP SP2 issues?

There is a recent news article that indicates that Microsoft has "warned"
its customers about SQL Server 2000 (version not identified) not being
compatible with the XP SP 2.
I went to the MS website and searched everything I could find on the RTM
version of SP2. I found no such warning ... I found "issues" that could
come up if the Firewall is enabled and how to modify the settings so that
you could get to the SQL Server 2000 if there were problems.
I have installed MSDE on an XP Pro machine with all SPs and fixes up to but
not including SP2 and wanted to make sure that I didn't do anything to screw
up our current development processes ... we're in the middle of a large dev
project and didn't want to bring everything to a grinding halt.
Yes, we will install SP2 and test to make sure that our .NET apps will work
under SP2 but I want to do it in a "controlled manner" ... not an
inadvertent shutdown in the middle.
Anyone know of any issues, other than the Firewall, that makes SQL Server
2000 incompatible with XP SP2?
Thanks...
RonHi Ron,
Thanks for using MSDN Managed Newsgroup!
Here are some links showing why it is warned using SQL Server / MSDE with
XP SP2
"some programs may seem not to work. By default, Windows Firewall is
enabled and blocks unsolicited connections to your computer"
Some programs seem to stop working after you install Windows XP Service
Pack 2
http://support.microsoft.com/default.aspx?kbid=842242
--
"After you install Microsoft Windows XP Service Pack 2 on a computer that
is configured as a distributor, if you try to synchronize data from a
subscriber that is configured on a remote computer, you may notice that the
changes that are made in the subscriber database are not updated to the
publisher database."
BUG: The changes in a remote subscriber are not updated to the publisher
for a queued updating replication that uses Message Queuing on a
computer that is running Windows XP Service Pack 2
http://support.microsoft.com/default.aspx?kbid=839278
--
"You may not be able to connect to an instance of SQL Server, and you may
receive one of the following error messages.
[Named Pipes]SQL Server does not exist or access denied.
Unable to connect to server <SQL Server instance name>"
You may not be able to connect to an instance of SQL Server that is
configured to use the Named Pipes server network library on a computer
that is running Windows XP Service Pack 2
http://support.microsoft.com/?id=839269
--
"When you run a distributed transaction against an instance of SQL Server,
you may receive an error message that is similar to the following:
Server: Msg 7391, Level 16, State 1, Line 1"
You may receive a 7391 error message in SQL Server 2000 when you run a
distributed transaction against a linked server after you install Microsoft
Windows XP Service Pack 2
http://support.microsoft.com/?id=839279
--
" the SQL debugging feature in Microsoft Visual Studio .NET 2003 (Visual
Studio .NET) does not work. When you try to debug a SQL Server stored
procedure by using the Step Into Stored Procedure option in the Server
Explorer pane, you may receive the following error message:
Cannot debug stored procedures because the SQL Server database is not setup
correctly or user does not have permission to execute master.sp_sdidebug.
Run SQL Server setup or contact database administrator."
BUG: SQL debugging does not work in Visual Studio .NET after you install
Windows XP Service Pack 2
http://support.microsoft.com/?id=839280
--
"When you install Microsoft SQL Server 2000 or Microsoft SQL Server Desktop
Engine (also known as MSDE 2000) on a computer that is running Microsoft
Windows XP Service Pack 2 (SP2), a message is logged in the application
event log. The message states that the instance of SQL Server or the
instance of MSDE is vulnerable to virus attacks."
A message stating that an instance of SQL Server is vulnerable to virus
attacks is logged in the application event log when you install SQL Server
2000 or MSDE 2000 on a computer that is running Windows XP Service Pack 2
http://support.microsoft.com/?id=841375
--
"When you run a distributed transaction against an instance of SQL Server,
you may receive an error message that is similar to the following:
Server: Msg 7391, Level 16, State 1, Line 1 "
You may receive a 7391 error message in SQLOLEDB when you run a distributed
transaction against a linked server after you install Microsoft Windows XP
Service Pack 2
http://support.microsoft.com/?id=873160
--
Here is another very useful link for you about how to troubleshooting
Windows Firewall settings in Windows XP SP2
Troubleshooting Windows Firewall settings in Windows XP Service Pack 2
http://support.microsoft.com/default.aspx?kbid=875357
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Ron,
Additionally, I would like to provide five HOW-TO articiles for
configuration SQL Server with XP SP2.
How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server
http://support.microsoft.com/?id=841249
How to enable SQL Server connectivity on Windows XP Service Pack 2
http://support.microsoft.com/?id=841251
How to manually enable TCP/IP on Windows XP Service Pack 2 for SQL Server
2000
http://support.microsoft.com/?id=841252
How to enable SQL Server 2000 Reporting Services on Windows XP Service Pack
2
http://support.microsoft.com/?id=841253
How to enable the ISAPI component on SQLXML on Windows XP Service Pack 2
http://support.microsoft.com/default.aspx?kbid=842005
How to enable SQL Server 2000 Analysis Services and OLAP Services on
computers that are running Windows XP SP2
http://support.microsoft.com/?id=841256
How to use a script to programmatically open ports for SQL Server to use on
systems that are running Windows XP Service Pack 2
http://support.microsoft.com/default.aspx?kbid=839980
Thank you for your patience and cooperation again. If you have any
questions or concerns, don't hesitate to let me know. We are here to be of
assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Thank you very much for both replies. Your replies were both thorough and
very helpful.
I will back the machines up and begin installing SP2 on Saturday.
Hopefully, I will be able to report successful and uneventful installations
on Monday.
Again, many thanks...
Ron
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:g5WOYOOgEHA.3356@.cpmsftngxa06.phx.gbl...
> Hi Ron,
> Additionally, I would like to provide five HOW-TO articiles for
> configuration SQL Server with XP SP2.
> How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server
> http://support.microsoft.com/?id=841249
> How to enable SQL Server connectivity on Windows XP Service Pack 2
> http://support.microsoft.com/?id=841251
> How to manually enable TCP/IP on Windows XP Service Pack 2 for SQL Server
> 2000
> http://support.microsoft.com/?id=841252
> How to enable SQL Server 2000 Reporting Services on Windows XP Service
Pack
> 2
> http://support.microsoft.com/?id=841253
> How to enable the ISAPI component on SQLXML on Windows XP Service Pack 2
> http://support.microsoft.com/default.aspx?kbid=842005
> How to enable SQL Server 2000 Analysis Services and OLAP Services on
> computers that are running Windows XP SP2
> http://support.microsoft.com/?id=841256
> How to use a script to programmatically open ports for SQL Server to use
on
> systems that are running Windows XP Service Pack 2
> http://support.microsoft.com/default.aspx?kbid=839980
> Thank you for your patience and cooperation again. If you have any
> questions or concerns, don't hesitate to let me know. We are here to be of
> assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Developer Community Support
> ---
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||If you use Visual Studio.Net to debug SQL Stored Proceedures you'll
want to wait. More details are at
http://support.microsoft.com/?kbid=839280. If anyone knows of a way
around this problem, please let me know.
Ken Kimball [kkimball@.gmail.com]
"Ron Fluegge" <rmflugge@.swbell.net> wrote in message news:<#i24S0HgEHA.904@.TK2MSFTNGP09.phx.gbl>...
> There is a recent news article that indicates that Microsoft has "warned"
> its customers about SQL Server 2000 (version not identified) not being
> compatible with the XP SP 2.
> I went to the MS website and searched everything I could find on the RTM
> version of SP2. I found no such warning ... I found "issues" that could
> come up if the Firewall is enabled and how to modify the settings so that
> you could get to the SQL Server 2000 if there were problems.
> I have installed MSDE on an XP Pro machine with all SPs and fixes up to but
> not including SP2 and wanted to make sure that I didn't do anything to screw
> up our current development processes ... we're in the middle of a large dev
> project and didn't want to bring everything to a grinding halt.
> Yes, we will install SP2 and test to make sure that our .NET apps will work
> under SP2 but I want to do it in a "controlled manner" ... not an
> inadvertent shutdown in the middle.
> Anyone know of any issues, other than the Firewall, that makes SQL Server
> 2000 incompatible with XP SP2?
> Thanks...
> Ron|||Ken,
Yes, I was aware of that problem. I do use VS 2003 to develop apps but do
not use SQL Stored Procedures (for a number of reasons specific to our
apps).
I was very surprised to find the number of "issues" related to SQL Server
2000 given that is the current release of MS's SQL Server -- especially
since there is nothing to indicate that patches or fixes are forthcoming.
On the same XP Pro machine, I'm also running Oracle 9i and I'm hoping that
it doesn't come to a crashing halt as well. (These are used for
"development" and not for production databases)
Ron
"Ken Kimball" <kkimball@.gmail.com> wrote in message
news:466a0cb4.0408130512.4468a03a@.posting.google.com...
> If you use Visual Studio.Net to debug SQL Stored Proceedures you'll
> want to wait. More details are at
> http://support.microsoft.com/?kbid=839280. If anyone knows of a way
> around this problem, please let me know.
> Ken Kimball [kkimball@.gmail.com]
> "Ron Fluegge" <rmflugge@.swbell.net> wrote in message
news:<#i24S0HgEHA.904@.TK2MSFTNGP09.phx.gbl>...
> > There is a recent news article that indicates that Microsoft has
"warned"
> > its customers about SQL Server 2000 (version not identified) not being
> > compatible with the XP SP 2.
> >
> > I went to the MS website and searched everything I could find on the RTM
> > version of SP2. I found no such warning ... I found "issues" that could
> > come up if the Firewall is enabled and how to modify the settings so
that
> > you could get to the SQL Server 2000 if there were problems.
> >
> > I have installed MSDE on an XP Pro machine with all SPs and fixes up to
but
> > not including SP2 and wanted to make sure that I didn't do anything to
screw
> > up our current development processes ... we're in the middle of a large
dev
> > project and didn't want to bring everything to a grinding halt.
> >
> > Yes, we will install SP2 and test to make sure that our .NET apps will
work
> > under SP2 but I want to do it in a "controlled manner" ... not an
> > inadvertent shutdown in the middle.
> >
> > Anyone know of any issues, other than the Firewall, that makes SQL
Server
> > 2000 incompatible with XP SP2?
> >
> > Thanks...
> >
> > Ron|||You might also check out:
Finally, you should absolutely watch and learn from the webcast titled ?MSDN
Webcast: SQL Server and Windows XP SP2 - Level 300 ? available at
http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032253410&Culture=en-US
I found it to be very helpful.
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Ron Fluegge" <rmflugge@.swbell.net> wrote in message
news:e9BEMnPgEHA.1972@.TK2MSFTNGP09.phx.gbl...
> Thank you very much for both replies. Your replies were both thorough and
> very helpful.
> I will back the machines up and begin installing SP2 on Saturday.
> Hopefully, I will be able to report successful and uneventful
installations
> on Monday.
> Again, many thanks...
> Ron
> ""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
> news:g5WOYOOgEHA.3356@.cpmsftngxa06.phx.gbl...
> > Hi Ron,
> >
> > Additionally, I would like to provide five HOW-TO articiles for
> > configuration SQL Server with XP SP2.
> >
> > How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server
> > http://support.microsoft.com/?id=841249
> >
> > How to enable SQL Server connectivity on Windows XP Service Pack 2
> > http://support.microsoft.com/?id=841251
> >
> > How to manually enable TCP/IP on Windows XP Service Pack 2 for SQL
Server
> > 2000
> > http://support.microsoft.com/?id=841252
> >
> > How to enable SQL Server 2000 Reporting Services on Windows XP Service
> Pack
> > 2
> > http://support.microsoft.com/?id=841253
> >
> > How to enable the ISAPI component on SQLXML on Windows XP Service Pack 2
> > http://support.microsoft.com/default.aspx?kbid=842005
> >
> > How to enable SQL Server 2000 Analysis Services and OLAP Services on
> > computers that are running Windows XP SP2
> > http://support.microsoft.com/?id=841256
> >
> > How to use a script to programmatically open ports for SQL Server to use
> on
> > systems that are running Windows XP Service Pack 2
> > http://support.microsoft.com/default.aspx?kbid=839980
> >
> > Thank you for your patience and cooperation again. If you have any
> > questions or concerns, don't hesitate to let me know. We are here to be
of
> > assistance!
> >
> >
> > Sincerely yours,
> >
> > Mingqing Cheng
> > Microsoft Developer Community Support
> > ---
> > Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> > This posting is provided "as is" with no warranties and confers no
rights.
> > Please reply to newsgroups only, many thanks!
> >
>|||Brian,
Will do ... THANKS VERY MUCH!!!
Ron
"Brian Moran" <brian@.solidqualitylearning.com> wrote in message
news:OOHq06UgEHA.1764@.TK2MSFTNGP10.phx.gbl...
> You might also check out:
> Finally, you should absolutely watch and learn from the webcast titled
'MSDN
> Webcast: SQL Server and Windows XP SP2 - Level 300 ' available at
>
http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032253410&Culture=en-US
>
> I found it to be very helpful.
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "Ron Fluegge" <rmflugge@.swbell.net> wrote in message
> news:e9BEMnPgEHA.1972@.TK2MSFTNGP09.phx.gbl...
> > Thank you very much for both replies. Your replies were both thorough
and
> > very helpful.
> >
> > I will back the machines up and begin installing SP2 on Saturday.
> > Hopefully, I will be able to report successful and uneventful
> installations
> > on Monday.
> >
> > Again, many thanks...
> >
> > Ron
> >
> > ""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in
message
> > news:g5WOYOOgEHA.3356@.cpmsftngxa06.phx.gbl...
> > > Hi Ron,
> > >
> > > Additionally, I would like to provide five HOW-TO articiles for
> > > configuration SQL Server with XP SP2.
> > >
> > > How to configure Windows XP Service Pack 2 (SP2) for use with SQL
Server
> > > http://support.microsoft.com/?id=841249
> > >
> > > How to enable SQL Server connectivity on Windows XP Service Pack 2
> > > http://support.microsoft.com/?id=841251
> > >
> > > How to manually enable TCP/IP on Windows XP Service Pack 2 for SQL
> Server
> > > 2000
> > > http://support.microsoft.com/?id=841252
> > >
> > > How to enable SQL Server 2000 Reporting Services on Windows XP Service
> > Pack
> > > 2
> > > http://support.microsoft.com/?id=841253
> > >
> > > How to enable the ISAPI component on SQLXML on Windows XP Service Pack
2
> > > http://support.microsoft.com/default.aspx?kbid=842005
> > >
> > > How to enable SQL Server 2000 Analysis Services and OLAP Services on
> > > computers that are running Windows XP SP2
> > > http://support.microsoft.com/?id=841256
> > >
> > > How to use a script to programmatically open ports for SQL Server to
use
> > on
> > > systems that are running Windows XP Service Pack 2
> > > http://support.microsoft.com/default.aspx?kbid=839980
> > >
> > > Thank you for your patience and cooperation again. If you have any
> > > questions or concerns, don't hesitate to let me know. We are here to
be
> of
> > > assistance!
> > >
> > >
> > > Sincerely yours,
> > >
> > > Mingqing Cheng
> > > Microsoft Developer Community Support
> > > ---
> > > Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> > > This posting is provided "as is" with no warranties and confers no
> rights.
> > > Please reply to newsgroups only, many thanks!
> > >
> >
> >
>|||Hi Ron,
If you encounter any questions or concerns when upgrading to Windows XP
Service Pack 2, please feel free to reply here or make a new thread. We
would love to make a follow up until that issue is completely resolved.
Good Luck!
Thank you for your patience and cooperation.
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||I just finished the upgrade to SP2 ... on this machine I have both SQL
Server 2000 and Oracle 9i as well as VS 2003 -- it's my development machine.
It all went well without a hitch!!!
Everything is up and running without any problems so far software or
hardware-wise. I have a dual AMD MoBo with RAID controllers and it is
having no problems.
So needless to say, I am a happy camper ...
Ron
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:v7ocVFcgEHA.480@.cpmsftngxa06.phx.gbl...
> Hi Ron,
> If you encounter any questions or concerns when upgrading to Windows XP
> Service Pack 2, please feel free to reply here or make a new thread. We
> would love to make a follow up until that issue is completely resolved.
> Good Luck!
> Thank you for your patience and cooperation.
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Developer Community Support
> ---
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>

Any SQL Server 2000 and XP SP2 issues?

There is a recent news article that indicates that Microsoft has "warned"
its customers about SQL Server 2000 (version not identified) not being
compatible with the XP SP 2.
I went to the MS website and searched everything I could find on the RTM
version of SP2. I found no such warning ... I found "issues" that could
come up if the Firewall is enabled and how to modify the settings so that
you could get to the SQL Server 2000 if there were problems.
I have installed MSDE on an XP Pro machine with all SPs and fixes up to but
not including SP2 and wanted to make sure that I didn't do anything to screw
up our current development processes ... we're in the middle of a large dev
project and didn't want to bring everything to a grinding halt.
Yes, we will install SP2 and test to make sure that our .NET apps will work
under SP2 but I want to do it in a "controlled manner" ... not an
inadvertent shutdown in the middle.
Anyone know of any issues, other than the Firewall, that makes SQL Server
2000 incompatible with XP SP2?
Thanks...
Ron
Hi Ron,
Thanks for using MSDN Managed Newsgroup!
Here are some links showing why it is warned using SQL Server / MSDE with
XP SP2
"some programs may seem not to work. By default, Windows Firewall is
enabled and blocks unsolicited connections to your computer"
Some programs seem to stop working after you install Windows XP Service
Pack 2
http://support.microsoft.com/default.aspx?kbid=842242
"After you install Microsoft Windows XP Service Pack 2 on a computer that
is configured as a distributor, if you try to synchronize data from a
subscriber that is configured on a remote computer, you may notice that the
changes that are made in the subscriber database are not updated to the
publisher database."
BUG: The changes in a remote subscriber are not updated to the publisher
for a queued updating replication that uses Message Queuing on a
computer that is running Windows XP Service Pack 2
http://support.microsoft.com/default.aspx?kbid=839278
"You may not be able to connect to an instance of SQL Server, and you may
receive one of the following error messages.
[Named Pipes]SQL Server does not exist or access denied.
Unable to connect to server <SQL Server instance name>"
You may not be able to connect to an instance of SQL Server that is
configured to use the Named Pipes server network library on a computer
that is running Windows XP Service Pack 2
http://support.microsoft.com/?id=839269
"When you run a distributed transaction against an instance of SQL Server,
you may receive an error message that is similar to the following:
Server: Msg 7391, Level 16, State 1, Line 1"
You may receive a 7391 error message in SQL Server 2000 when you run a
distributed transaction against a linked server after you install Microsoft
Windows XP Service Pack 2
http://support.microsoft.com/?id=839279
" the SQL debugging feature in Microsoft Visual Studio .NET 2003 (Visual
Studio .NET) does not work. When you try to debug a SQL Server stored
procedure by using the Step Into Stored Procedure option in the Server
Explorer pane, you may receive the following error message:
Cannot debug stored procedures because the SQL Server database is not setup
correctly or user does not have permission to execute master.sp_sdidebug.
Run SQL Server setup or contact database administrator."
BUG: SQL debugging does not work in Visual Studio .NET after you install
Windows XP Service Pack 2
http://support.microsoft.com/?id=839280
"When you install Microsoft SQL Server 2000 or Microsoft SQL Server Desktop
Engine (also known as MSDE 2000) on a computer that is running Microsoft
Windows XP Service Pack 2 (SP2), a message is logged in the application
event log. The message states that the instance of SQL Server or the
instance of MSDE is vulnerable to virus attacks."
A message stating that an instance of SQL Server is vulnerable to virus
attacks is logged in the application event log when you install SQL Server
2000 or MSDE 2000 on a computer that is running Windows XP Service Pack 2
http://support.microsoft.com/?id=841375
"When you run a distributed transaction against an instance of SQL Server,
you may receive an error message that is similar to the following:
Server: Msg 7391, Level 16, State 1, Line 1 "
You may receive a 7391 error message in SQLOLEDB when you run a distributed
transaction against a linked server after you install Microsoft Windows XP
Service Pack 2
http://support.microsoft.com/?id=873160
Here is another very useful link for you about how to troubleshooting
Windows Firewall settings in Windows XP SP2
Troubleshooting Windows Firewall settings in Windows XP Service Pack 2
http://support.microsoft.com/default.aspx?kbid=875357
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Hi Ron,
Additionally, I would like to provide five HOW-TO articiles for
configuration SQL Server with XP SP2.
How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server
http://support.microsoft.com/?id=841249
How to enable SQL Server connectivity on Windows XP Service Pack 2
http://support.microsoft.com/?id=841251
How to manually enable TCP/IP on Windows XP Service Pack 2 for SQL Server
2000
http://support.microsoft.com/?id=841252
How to enable SQL Server 2000 Reporting Services on Windows XP Service Pack
2
http://support.microsoft.com/?id=841253
How to enable the ISAPI component on SQLXML on Windows XP Service Pack 2
http://support.microsoft.com/default.aspx?kbid=842005
How to enable SQL Server 2000 Analysis Services and OLAP Services on
computers that are running Windows XP SP2
http://support.microsoft.com/?id=841256
How to use a script to programmatically open ports for SQL Server to use on
systems that are running Windows XP Service Pack 2
http://support.microsoft.com/default.aspx?kbid=839980
Thank you for your patience and cooperation again. If you have any
questions or concerns, don't hesitate to let me know. We are here to be of
assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Thank you very much for both replies. Your replies were both thorough and
very helpful.
I will back the machines up and begin installing SP2 on Saturday.
Hopefully, I will be able to report successful and uneventful installations
on Monday.
Again, many thanks...
Ron
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:g5WOYOOgEHA.3356@.cpmsftngxa06.phx.gbl...
> Hi Ron,
> Additionally, I would like to provide five HOW-TO articiles for
> configuration SQL Server with XP SP2.
> How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server
> http://support.microsoft.com/?id=841249
> How to enable SQL Server connectivity on Windows XP Service Pack 2
> http://support.microsoft.com/?id=841251
> How to manually enable TCP/IP on Windows XP Service Pack 2 for SQL Server
> 2000
> http://support.microsoft.com/?id=841252
> How to enable SQL Server 2000 Reporting Services on Windows XP Service
Pack
> 2
> http://support.microsoft.com/?id=841253
> How to enable the ISAPI component on SQLXML on Windows XP Service Pack 2
> http://support.microsoft.com/default.aspx?kbid=842005
> How to enable SQL Server 2000 Analysis Services and OLAP Services on
> computers that are running Windows XP SP2
> http://support.microsoft.com/?id=841256
> How to use a script to programmatically open ports for SQL Server to use
on
> systems that are running Windows XP Service Pack 2
> http://support.microsoft.com/default.aspx?kbid=839980
> Thank you for your patience and cooperation again. If you have any
> questions or concerns, don't hesitate to let me know. We are here to be of
> assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Developer Community Support
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
|||If you use Visual Studio.Net to debug SQL Stored Proceedures you'll
want to wait. More details are at
http://support.microsoft.com/?kbid=839280. If anyone knows of a way
around this problem, please let me know.
Ken Kimball [kkimball@.gmail.com]
"Ron Fluegge" <rmflugge@.swbell.net> wrote in message news:<#i24S0HgEHA.904@.TK2MSFTNGP09.phx.gbl>...
> There is a recent news article that indicates that Microsoft has "warned"
> its customers about SQL Server 2000 (version not identified) not being
> compatible with the XP SP 2.
> I went to the MS website and searched everything I could find on the RTM
> version of SP2. I found no such warning ... I found "issues" that could
> come up if the Firewall is enabled and how to modify the settings so that
> you could get to the SQL Server 2000 if there were problems.
> I have installed MSDE on an XP Pro machine with all SPs and fixes up to but
> not including SP2 and wanted to make sure that I didn't do anything to screw
> up our current development processes ... we're in the middle of a large dev
> project and didn't want to bring everything to a grinding halt.
> Yes, we will install SP2 and test to make sure that our .NET apps will work
> under SP2 but I want to do it in a "controlled manner" ... not an
> inadvertent shutdown in the middle.
> Anyone know of any issues, other than the Firewall, that makes SQL Server
> 2000 incompatible with XP SP2?
> Thanks...
> Ron
|||Ken,
Yes, I was aware of that problem. I do use VS 2003 to develop apps but do
not use SQL Stored Procedures (for a number of reasons specific to our
apps).
I was very surprised to find the number of "issues" related to SQL Server
2000 given that is the current release of MS's SQL Server -- especially
since there is nothing to indicate that patches or fixes are forthcoming.
On the same XP Pro machine, I'm also running Oracle 9i and I'm hoping that
it doesn't come to a crashing halt as well. (These are used for
"development" and not for production databases)
Ron
"Ken Kimball" <kkimball@.gmail.com> wrote in message
news:466a0cb4.0408130512.4468a03a@.posting.google.c om...
> If you use Visual Studio.Net to debug SQL Stored Proceedures you'll
> want to wait. More details are at
> http://support.microsoft.com/?kbid=839280. If anyone knows of a way
> around this problem, please let me know.
> Ken Kimball [kkimball@.gmail.com]
> "Ron Fluegge" <rmflugge@.swbell.net> wrote in message
news:<#i24S0HgEHA.904@.TK2MSFTNGP09.phx.gbl>...[vbcol=seagreen]
"warned"[vbcol=seagreen]
that[vbcol=seagreen]
but[vbcol=seagreen]
screw[vbcol=seagreen]
dev[vbcol=seagreen]
work[vbcol=seagreen]
Server[vbcol=seagreen]
|||You might also check out:
Finally, you should absolutely watch and learn from the webcast titled MSDN
Webcast: SQL Server and Windows XP SP2 - Level 300 available at
http://msevents.microsoft.com/CUI/Ev...&Culture=en-US
I found it to be very helpful.
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Ron Fluegge" <rmflugge@.swbell.net> wrote in message
news:e9BEMnPgEHA.1972@.TK2MSFTNGP09.phx.gbl...
> Thank you very much for both replies. Your replies were both thorough and
> very helpful.
> I will back the machines up and begin installing SP2 on Saturday.
> Hopefully, I will be able to report successful and uneventful
installations[vbcol=seagreen]
> on Monday.
> Again, many thanks...
> Ron
> ""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
> news:g5WOYOOgEHA.3356@.cpmsftngxa06.phx.gbl...
Server[vbcol=seagreen]
> Pack
> on
of[vbcol=seagreen]
rights.
>
|||Brian,
Will do ... THANKS VERY MUCH!!!
Ron
"Brian Moran" <brian@.solidqualitylearning.com> wrote in message
news:OOHq06UgEHA.1764@.TK2MSFTNGP10.phx.gbl...
> You might also check out:
> Finally, you should absolutely watch and learn from the webcast titled
'MSDN
> Webcast: SQL Server and Windows XP SP2 - Level 300 ' available at
>
http://msevents.microsoft.com/CUI/Ev...&Culture=en-US[vbcol=seagreen]
>
> I found it to be very helpful.
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "Ron Fluegge" <rmflugge@.swbell.net> wrote in message
> news:e9BEMnPgEHA.1972@.TK2MSFTNGP09.phx.gbl...
and[vbcol=seagreen]
> installations
message[vbcol=seagreen]
Server[vbcol=seagreen]
> Server
2[vbcol=seagreen]
use[vbcol=seagreen]
be
> of
> rights.
>
|||Hi Ron,
If you encounter any questions or concerns when upgrading to Windows XP
Service Pack 2, please feel free to reply here or make a new thread. We
would love to make a follow up until that issue is completely resolved.
Good Luck!
Thank you for your patience and cooperation.
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||I just finished the upgrade to SP2 ... on this machine I have both SQL
Server 2000 and Oracle 9i as well as VS 2003 -- it's my development machine.
It all went well without a hitch!!!
Everything is up and running without any problems so far software or
hardware-wise. I have a dual AMD MoBo with RAID controllers and it is
having no problems.
So needless to say, I am a happy camper ...
Ron
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:v7ocVFcgEHA.480@.cpmsftngxa06.phx.gbl...
> Hi Ron,
> If you encounter any questions or concerns when upgrading to Windows XP
> Service Pack 2, please feel free to reply here or make a new thread. We
> would love to make a follow up until that issue is completely resolved.
> Good Luck!
> Thank you for your patience and cooperation.
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Developer Community Support
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>

2012年3月6日星期二

Any one who knows this error about SQL 65 upgrade? its urgent, thanks.

Hi All,

I am doing the upgrade from SQL6.5 to SQL2K, the server version is:
SQL 6.5 English SP5 on WinNT Enterprise 4.0 English SP6,
new server is SQL 2K standard English SP1 on WinNT Enterprise 4.0 English SP6.

When I use SQL upgrade wizard to perform a two server upgrade, all steps seems ok, when move to the step of "Export & Import Via Name Pipe" I got a error. Pls see the below error. Pls let me know the reason and how to resolve it.

log file: Export and Import via Named Pipe - 007test.err

############# Log file content ############
Export.exe on the remote machine was hung...

Export Exit Code: 259 - export.exe -CodePage 1252 -DeviceType Pipe -AllTables yes -MasterPath D:\MSSQL\DATA\MASTER.DAT -DatabaseName test -DevicePath \\.\pipe\~cnvpipe0

Import Exit Code: -1 - ~cnvpipe0

Msg 4854, Level 21, State 1, Server NTAPPLIX02, Procedure , Line 1

[Microsoft][ODBC SQL Server Driver][SQL Server]****

Time:12-03-2003 17:05:04.433

Error return from function CreateFile

in file CnvPipe.cpp

Line=142

rc=1326

Msg=Logon failure: unknown user name or bad password.

****
######################################Create/use a domain account for both sql server's service startup account. Make sure to add this domain account to the local admin group. Lastly, login using this domain account to run the upgrade.|||Originally posted by rnealejr
Create/use a domain account for both sql server's service startup account. Make sure to add this domain account to the local admin group. Lastly, login using this domain account to run the upgrade.

Hi,

Thanks, because the SQL65 server does not join any domain just a stand alone server, and i can not join this SQL server to any existing domain, but the SQL2K server is in a NT domain. Any solution for this situation ? One more problem, is the name pipe only connection method when perform a two server SQL upgrade?

Many thanks,

Zhanlan

2012年2月23日星期四

any installation no-no's?

We are installing MS Win Server 2003 and my old version (7?) of MSDE is not
supported. So I will download MSDE 2000 and install it. I do not have a lot
of experience installing MSDE. I installed it a few times years ago and, with
a few exceptions, it has run just fine since then.
I vaguely remember that I used all the installation defaults with MSDE. That
led to a problem whenever the administrator, or whoever the user was when it
was installed, changed thier password, the connection to the database no
longer worked.
Can anyone suggest a source of information that might be useful to me to
read before I install MSDE 2000?
Thanks for your help, John Brown
John Brown
hi John,
John Brown wrote:
> We are installing MS Win Server 2003 and my old version (7?) of MSDE
> is not supported. So I will download MSDE 2000 and install it. I do
> not have a lot of experience installing MSDE. I installed it a few
> times years ago and, with a few exceptions, it has run just fine
> since then.
> I vaguely remember that I used all the installation defaults with
> MSDE. That led to a problem whenever the administrator, or whoever
> the user was when it was installed, changed thier password, the
> connection to the database no longer worked.
> Can anyone suggest a source of information that might be useful to me
> to read before I install MSDE 2000?
> Thanks for your help, John Brown
modifying the "sa" password was a problem for MSDE 1.0 relating to Windows
account running the SQL Server Agent, but this does not apply to MSDE
2000... and there are not other problems I'm aware of.. but, of course, you
should have a look at the readme file bundled with the installation
package...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Any idea when the next version of SQL is out ?

I know the executives at MS have promised for a 2 year release moving
forward and if thats true, we should be having one in the coming year. But I
dont see any sight of the same happening. Can someone confirm ? I believe
the code name is Katmai.The code name is Katmai, that is correct. But no dates have been announced.
"Hassan" <Hassan@.hotmail.com> wrote in message
news:eclyo5RKHHA.1424@.TK2MSFTNGP04.phx.gbl...
>I know the executives at MS have promised for a 2 year release moving
>forward and if thats true, we should be having one in the coming year. But
>I dont see any sight of the same happening. Can someone confirm ? I believe
>the code name is Katmai.
>
>|||I never read about a promise per se. I read that it was a goal to have between 2-3 years between
releases.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hassan" <Hassan@.hotmail.com> wrote in message news:eclyo5RKHHA.1424@.TK2MSFTNGP04.phx.gbl...
>I know the executives at MS have promised for a 2 year release moving forward and if thats true, we
>should be having one in the coming year. But I dont see any sight of the same happening. Can
>someone confirm ? I believe the code name is Katmai.
>
>|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:O0wxuHTKHHA.4712@.TK2MSFTNGP04.phx.gbl...
>.
>I never read about a promise per se. I read that it was a goal to have
>between 2-3 years between releases.
It is absurd to put that kind of pressure on this company...I give you
Vista -:)
I am particularly looking forward to your discussions with users concerning
the fascinating interactions (that I forsee in my crystal ball) between the
User Account Control and sql server -:)
Best wishes for the new year,|||> It is absurd to put that kind of pressure on this company...I give you
> Vista -:)
My biggest problem with Vista has little to do with Microsoft: none of the
video card manufacturers have been able to provide an adequate driver that
supports all the features and doesn't blue screen!
My second complaint is a licensing issue, not a quality issue. I bought
Windows Live OneCare for an XP desktop. When I upgraded to Vista, my one
year license became a 3-month license that had now expired, because the
software refuses to run on Vista. They have some beta program for 1.5 but
since the system is already unstable (mostly due to video drivers as
mentioned above) I am not willing to try it.
I know, this is not the forum for these complaints, but you brought it up!
:-)|||Many companies purchase software assurance, specifically to take advantage
of regular upgrades.
Regards,
Greg Linwood
SQL Server MVP
http://blogs.sqlserver.org.au/blogs/greg_linwood
"Steve Dassin" <steve@.nospamrac4sql.net> wrote in message
news:OMt6PiTKHHA.3552@.TK2MSFTNGP03.phx.gbl...
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:O0wxuHTKHHA.4712@.TK2MSFTNGP04.phx.gbl...
>>.
>>I never read about a promise per se. I read that it was a goal to have
>>between 2-3 years between releases.
> It is absurd to put that kind of pressure on this company...I give you
> Vista -:)
> I am particularly looking forward to your discussions with users
> concerning the fascinating interactions (that I forsee in my crystal ball)
> between the User Account Control and sql server -:)
> Best wishes for the new year,
>|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%23lroFmTKHHA.5000@.TK2MSFTNGP03.phx.gbl...
>.
> I know, this is not the forum for these complaints, but you brought it up!
> :-)
Yes I did...somebody had to do it :)
IE7 is released as an unfinished product driving users to FF. OneCare is a
joke. They have no business releasing Vista now for many reasons. The mind
boggles at the price to be paid for using this OS with the security model
being a prime example. They are driving people to question their leadership
or lack thereof.
Best wishes for the new year,

2012年2月18日星期六

Any help with an update/join/count?

Hey everyone,
I'm trying to come up with an update statement for this
dataset... it's a simplified version of the data
that I'm working with, so it might not make
a lot of sense as to why it's structured as it is...
Given these tables:
create table t1 (theKey1 int,
theKey2 int,
needToPutTheDataHere varchar(1),
tooFewError int default 0,
tooManyError int default 0)
insert into t1 values(1,1,'',0,0)
insert into t1 values(2,2,'',0,0)
insert into t1 values(3,3,'',0,0)
create table t2 (theKey1 int,
theKey2 int,
theData varchar(1))
insert into t2 values(1,1,'A')
insert into t2 values(1,1,'B')
insert into t2 values(2,2,'C')
I need to update so that I get this:
t1:
thekey1 thekey2 needToPutTheDataHere too
FewError tooManyError
1 1 NULL 0 1
2 2 C 0 0
3 3 NULL 1 0
- link t1 and t2 on thekey1 and thekey2
- put t2.theData in t1.needToPutTheDataHere if there is exactly one
matching row in t2
- set t1.tooFewError or t1.tooManyError to 1 if there is less
than one or more than 1 matching row in t2.
I could also eliminate the tooFew/tooMany columns and just use a
count (0,1,...x) if that would increase performance for large datasets.
Any help on how to write this update would be much appreciated!I think that you might want to use a VIEW that will always be right
instead of updating constantly.
While I am glad to get any DDL, you have no keys and a VARCHAR(1)
column -- think about that for two seconds. Also, we do not have links
in SQL -- that is assembly language; we have references and joins.
Let's use a tally instead of assembly language style flags:
CREATE TABLE Foobar
(thekey1 INTEGER NOT NULL,
thekey2 INTEGER NOT NULL,
needtoputthedatahere CHAR(1) DEFAULT '' NOT NULL,
tally INTEGER DEFAULT 0 NOT NULL,
INSERT INTO Foobar VALUES (1, 1, '', 0, 0);
INSERT INTO Foobar VALUES (2, 2, '', 0, 0);
INSERT INTO Foobar VALUES (3, 3, '', 0, 0);
CREATE TABLE NewFoobar
(thekey1 INTEGER NOT NULL,
thekey2 INTEGER NOT NULL,
thedata CHAR(1) NOT NULL,
PRIMARY KEY (thekey1, thekey2, thedata)); -- needs a key
INSERT INTO NewFoobar VALUES (1, 1, 'a');
INSERT INTO NewFoobar VALUES (1, 1, 'b');
INSERT INTO NewFoobar VALUES (2, 2, 'c');
Try this:
UPDATE Foobar
SET needtoputthedatahere
= (SELECT F1.thedata
FROM NewFoobar AS F1
WHERE Foobar.thekey1 = F1.thekey1
AND Foobar.thekey2 = F1.thekey2
GROUP BY F1.thekey1, F1.thekey2
HAVING COUNT(*) = 1) -- empty scalar table expressions become
NULL
tally =(SELECT COUNT(*)
FROM NewFoobar AS F1
WHERE Foobar.thekey1 = F1.thekey1
AND Foobar.thekey2 = F1.thekey2) -- empty table
expressions count zero
WHERE EXISTS
(SELECT *
FROM NewFoobar
WHERE Foobar.thekey1 = NewFoobar.thekey1
AND Foobar.thekey2 = NewFoobar.thekey2);
You can drop the WHERE clause on the UPDATE if you wish.

2012年2月16日星期四

Any documentation anywhere on vs.net 2005 + report services

Well, it finally arrived, my eval version of vs.net 2005...I was so
excited, I think I really must 'get a life'...
Anyway, I recall on here mention that in vs.net 2005 you get more
control over the parameter area....can anyone point me to any
documentation on how vs.net allows more control of reports than 2003?
Did anyone write something about it somewhere?
Thanks
Peter Nolan
www.peternolan.comYou are saying vs.net 2005. vs.net is not Reporting Service. VS 2005 comes
with 2 controls. A winform control and a webform control. If you have your
own application that is integrating with RS then these controls are great.
The controls work in local mode (render without a server) and server mode.
In server mode the server must be running RS 2005, it does not work with RS
2000.
It sounds like you are using Report Manager for your portal to the reports
(versus creating your own app that interacts with the user). If so, then VS
2005 does not provide anything of use to you. You need to upgrade to RS 2005
to see any improvement. As far as more control over the parameter area. RS
2005 has a calendar date picker and it support multi-selection parameters.
Two major improvements.
RS 2005 is faster and also has support for end user sorting.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1141230819.293974.223770@.u72g2000cwu.googlegroups.com...
> Well, it finally arrived, my eval version of vs.net 2005...I was so
> excited, I think I really must 'get a life'...
> Anyway, I recall on here mention that in vs.net 2005 you get more
> control over the parameter area....can anyone point me to any
> documentation on how vs.net allows more control of reports than 2003?
> Did anyone write something about it somewhere?
> Thanks
> Peter Nolan
> www.peternolan.com
>|||Hi Bruce,
yes, I mean vs.net 2005...I also have sql server 2005.....I have been
going through the 'upgrade' process from sql server 2000 + RS and
vs.net 2003. We are playing around with all the 2005 stuff and
integrating dundas chart controls.
We are building a product based on all the MSFT technology stack (music
to your eyes I am sure)...and we are trying to make it the very best we
can on all 2005 stuff.
We want to integrate it into dotnetnuke in the future but it looks like
it is a bit of work to do and we decided for version 1.0 we would go
with the out of the box report manager.
So currently, we want the 'best result' we can get with vs.net 2005 and
sql server 2005...sounds to me like we can't do any more with the
webform and we might just have wait until version 1.1 and we get it
into the dot net nuke portal...
This sound correct to you?
Best Regards
Peter
www.peternolan.com|||If you want your own frontend then look at the new webform controls that
come with VS 2005, they work with RS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1141333522.027909.311300@.j33g2000cwa.googlegroups.com...
> Hi Bruce,
> yes, I mean vs.net 2005...I also have sql server 2005.....I have been
> going through the 'upgrade' process from sql server 2000 + RS and
> vs.net 2003. We are playing around with all the 2005 stuff and
> integrating dundas chart controls.
> We are building a product based on all the MSFT technology stack (music
> to your eyes I am sure)...and we are trying to make it the very best we
> can on all 2005 stuff.
> We want to integrate it into dotnetnuke in the future but it looks like
> it is a bit of work to do and we decided for version 1.0 we would go
> with the out of the box report manager.
> So currently, we want the 'best result' we can get with vs.net 2005 and
> sql server 2005...sounds to me like we can't do any more with the
> webform and we might just have wait until version 1.1 and we get it
> into the dot net nuke portal...
> This sound correct to you?
> Best Regards
> Peter
> www.peternolan.com
>|||Hi Bruce,
we'd like out own but we see it is a lot of work to do....I bought the
hitch-hikers book and I agree with their opinion...too hard...
I also think someone else is going to do it and charge a reasonable fee
for it...failing that, we will put it into dotnetnuke....we don't
want to have to write an application just to present our
reports...there's too much to write...we like DNN as it now has
windows authentication, lots of modules, a developer ecosystem
happening, the source code is availble, and it's the right price.. LOL!
Personally, I'd love to see MSFT and DNN core team work together to
develop a really, really good suite of modules for Report Services.
There is one out there already and I am using it...but I think someone
actually spending a good amount of time and effort on it might be
useful...perhaps I should do that myself!!! Maybe we can use the new
webform inside DNN.....sounds like Version 1.1 to me...and we are
still working on getting V 1.0 out the door...
Best Regards
Peter
www.peternolan.com

订阅：博文 (Atom)

2012年3月27日星期二

Anyone recently installed SQL Server 2000 Eval version

Anyone know of a good T-Sql Reference Code book?

2012年3月19日星期一

Any way to create 5KB size of Database?

Any way to create 5KB size of Database?

Any way to create 5KB size of Database?

2012年3月11日星期日

Any unique datetime's in SQL2005?

Any unique datetime's in SQL2005?

Any unique datetime's in SQL2005?

Any standalone version of SQL2005 Express?

Any standalone version of SQL2005 Express?

Any standalone version of SQL2005 Express?

2012年3月8日星期四

Any SQL Server 2000 and XP SP2 issues?

Any SQL Server 2000 and XP SP2 issues?

Any SQL Server 2000 and XP SP2 issues?

2012年3月6日星期二

Any one who knows this error about SQL 65 upgrade? its urgent, thanks.

2012年2月23日星期四

any installation no-no's?

Any idea when the next version of SQL is out ?

2012年2月18日星期六

Any help with an update/join/count?

2012年2月16日星期四

Any documentation anywhere on vs.net 2005 + report services

Sql ANSI Padding

Blog Archive

About Me