Hi.
When I execute the following sql statement in SQL 2000 DTS or query analyzer, I received the following error message. I used [ ] because my field names have spaces in between.
The same sql statement ran perfect in SQL 7. What could be wrong? Please advise. Thanks a million.
Update SAPvsSQL set [Sales Organisation] = sales_org,
[Value Out By] = val_diff, [Qty Out By] = qty_diff
Error message:
Server: Msg 16882, Level 11, State 1, Procedure sp_runwebtask, Line ...
SQL Web Assistant: Web task not found. Verify the name of the name for possible errors.
Best regardsYou sure you just didn't execute all of the code in the QA window, and you're executing something you don't see?|||And also, what are you setting the columns to?
Those aren't local variables...is there more to the statement?|||Originally posted by Brett Kaiser
And also, what are you setting the columns to?
Those aren't local variables...is there more to the statement?
Hi,
Thank you for your email reply.
Those in [ ] were actual field names in my database table. I used them for display purposes so instead of showing Sales_organation, I display Sales Organisation, Value Out By instead of val_diff and finally Qty Out By instead of qty_diff (look more meanful to the users).
You are right that I didn't show all the script in my previous message because they worked ok until this line. I am just being curious why the same script work PERFECT in SQL 7 but not in SQL 2000. I have been running this same set of script for more than a year and still running fine as at this morning. Reason why I am trying it on SQL 2000 because we will be moving to SQL 2000 totally by end this month.|||No problems here...your doing something else wrong...
USE Northwind
GO
CREATE TABLE SAPvsSQL (
[Sales Organisation] varchar(10)
, [Value Out By] varchar(10)
, [Qty Out By] varchar(10)
)
GO
DECLARE @.Sales_Org varchar(10), @.val_diff varchar(10), @.qty_diff varchar(10)
SELECT @.Sales_Org = 'A', @.val_Diff = 'B', @.qty_diff = 'C'
INSERT INTO SAPvsSQL ([Sales Organisation], [Value Out By], [Qty Out By])
SELECT 'X', 'Y', 'Z'
SELECT * FROM SAPvsSQL
UPDATE SAPvsSQL
SET [Sales Organisation] = @.sales_org
, [Value Out By] = @.val_diff
, [Qty Out By] = @.qty_diff
SELECT * FROM SAPvsSQL
GO
DROP TABLE SAPvsSQL
GO
Showing posts with label received. Show all posts
Showing posts with label received. Show all posts
Wednesday, March 21, 2012
Friday, February 24, 2012
Developer Edition- is that enough?
I am working for a university and we received funding to create an online
searchable database for Company A. Company A has SQL Server 2005 and uses it
within its company. We would like to create a database of articles and
research for them, test it, post it on the Web, see if it works and then giv
e
the database to Company A. Can we do that with only the Developer Edition, o
r
do we need to buy the SQL Server 2005? I know the only difference between th
e
Developer Edition and the Enterprise edition is the license, what does that
mean'
Thank you so much for any advice you have."lana1916" <lana1916@.discussions.microsoft.com> wrote in message
news:30191BB1-2DBD-4A67-BC8C-9AC8DB11649C@.microsoft.com...
>I am working for a university and we received funding to create an online
> searchable database for Company A. Company A has SQL Server 2005 and uses
> it
> within its company. We would like to create a database of articles and
> research for them, test it, post it on the Web, see if it works and then
> give
> the database to Company A. Can we do that with only the Developer Edition,
> or
> do we need to buy the SQL Server 2005? I know the only difference between
> the
> Developer Edition and the Enterprise edition is the license, what does
> that
> mean'
> Thank you so much for any advice you have
Here's the operative language from the SQL Server 2005 Developer Edition
license
If you comply with these license terms, you have the rights below for each
license you acquire.
1. OVERVIEW.
a. Software. The software includes development tools, software programs
and documentation.
b. License Model. The software is licensed on a per user basis.
2. INSTALLATION AND USE RIGHTS.
a. General. One user may install and use copies of the software to
design, develop, test and demonstrate your programs. Testing does not
include staging on a server in a production environment, such as loading
content prior to production use.
b. Included Microsoft Programs. These license terms apply to all
Microsoft programs included with the software. If the license terms with
any of those programs give you other rights that do not expressly conflict
with these license terms, you also have those rights.
3. ADDITIONAL LICENSING REQUIREMENTS AND/OR USE RIGHTS.
a. User Testing. Your end users may access the software to perform
acceptance tests on your programs.
b. Demonstration. Any person that has access to your internal network
may install and use copies of the software to demonstrate use of your
programs with the software. Those copies may not be used for any other
purpose.
If this doesn't answer your question, you might want to check with your
Microsoft representitive. Note that any number of developers, each of whom
owns a seperate Developer Edition license, can share one server instance of
SQL Server Developer edition.
To move from development to production an instance of SQL Server Developer
Edition can be upgraded to SQL Server Enterprise Edition, or the database
can be moved to a server running any other edition of SQL Server.
David.|||The fact that you want to post it on the Web is usually considered by
Microsoft as a production database; so the developer edition is not
sufficient. However, as this is only for tests, SQL-Server Express 2005
should be sufficient as the backend for this web thing; so you will be OK if
you use the Express edition as your backend database.
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"lana1916" <lana1916@.discussions.microsoft.com> wrote in message
news:30191BB1-2DBD-4A67-BC8C-9AC8DB11649C@.microsoft.com...
>I am working for a university and we received funding to create an online
> searchable database for Company A. Company A has SQL Server 2005 and uses
> it
> within its company. We would like to create a database of articles and
> research for them, test it, post it on the Web, see if it works and then
> give
> the database to Company A. Can we do that with only the Developer Edition,
> or
> do we need to buy the SQL Server 2005? I know the only difference between
> the
> Developer Edition and the Enterprise edition is the license, what does
> that
> mean'
> Thank you so much for any advice you have.
searchable database for Company A. Company A has SQL Server 2005 and uses it
within its company. We would like to create a database of articles and
research for them, test it, post it on the Web, see if it works and then giv
e
the database to Company A. Can we do that with only the Developer Edition, o
r
do we need to buy the SQL Server 2005? I know the only difference between th
e
Developer Edition and the Enterprise edition is the license, what does that
mean'
Thank you so much for any advice you have."lana1916" <lana1916@.discussions.microsoft.com> wrote in message
news:30191BB1-2DBD-4A67-BC8C-9AC8DB11649C@.microsoft.com...
>I am working for a university and we received funding to create an online
> searchable database for Company A. Company A has SQL Server 2005 and uses
> it
> within its company. We would like to create a database of articles and
> research for them, test it, post it on the Web, see if it works and then
> give
> the database to Company A. Can we do that with only the Developer Edition,
> or
> do we need to buy the SQL Server 2005? I know the only difference between
> the
> Developer Edition and the Enterprise edition is the license, what does
> that
> mean'
> Thank you so much for any advice you have
Here's the operative language from the SQL Server 2005 Developer Edition
license
If you comply with these license terms, you have the rights below for each
license you acquire.
1. OVERVIEW.
a. Software. The software includes development tools, software programs
and documentation.
b. License Model. The software is licensed on a per user basis.
2. INSTALLATION AND USE RIGHTS.
a. General. One user may install and use copies of the software to
design, develop, test and demonstrate your programs. Testing does not
include staging on a server in a production environment, such as loading
content prior to production use.
b. Included Microsoft Programs. These license terms apply to all
Microsoft programs included with the software. If the license terms with
any of those programs give you other rights that do not expressly conflict
with these license terms, you also have those rights.
3. ADDITIONAL LICENSING REQUIREMENTS AND/OR USE RIGHTS.
a. User Testing. Your end users may access the software to perform
acceptance tests on your programs.
b. Demonstration. Any person that has access to your internal network
may install and use copies of the software to demonstrate use of your
programs with the software. Those copies may not be used for any other
purpose.
If this doesn't answer your question, you might want to check with your
Microsoft representitive. Note that any number of developers, each of whom
owns a seperate Developer Edition license, can share one server instance of
SQL Server Developer edition.
To move from development to production an instance of SQL Server Developer
Edition can be upgraded to SQL Server Enterprise Edition, or the database
can be moved to a server running any other edition of SQL Server.
David.|||The fact that you want to post it on the Web is usually considered by
Microsoft as a production database; so the developer edition is not
sufficient. However, as this is only for tests, SQL-Server Express 2005
should be sufficient as the backend for this web thing; so you will be OK if
you use the Express edition as your backend database.
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"lana1916" <lana1916@.discussions.microsoft.com> wrote in message
news:30191BB1-2DBD-4A67-BC8C-9AC8DB11649C@.microsoft.com...
>I am working for a university and we received funding to create an online
> searchable database for Company A. Company A has SQL Server 2005 and uses
> it
> within its company. We would like to create a database of articles and
> research for them, test it, post it on the Web, see if it works and then
> give
> the database to Company A. Can we do that with only the Developer Edition,
> or
> do we need to buy the SQL Server 2005? I know the only difference between
> the
> Developer Edition and the Enterprise edition is the license, what does
> that
> mean'
> Thank you so much for any advice you have.
Developer Edition- is that enough?
I am working for a university and we received funding to create an online
searchable database for Company A. Company A has SQL Server 2005 and uses it
within its company. We would like to create a database of articles and
research for them, test it, post it on the Web, see if it works and then give
the database to Company A. Can we do that with only the Developer Edition, or
do we need to buy the SQL Server 2005? I know the only difference between the
Developer Edition and the Enterprise edition is the license, what does that
mean'
Thank you so much for any advice you have."lana1916" <lana1916@.discussions.microsoft.com> wrote in message
news:30191BB1-2DBD-4A67-BC8C-9AC8DB11649C@.microsoft.com...
>I am working for a university and we received funding to create an online
> searchable database for Company A. Company A has SQL Server 2005 and uses
> it
> within its company. We would like to create a database of articles and
> research for them, test it, post it on the Web, see if it works and then
> give
> the database to Company A. Can we do that with only the Developer Edition,
> or
> do we need to buy the SQL Server 2005? I know the only difference between
> the
> Developer Edition and the Enterprise edition is the license, what does
> that
> mean'
> Thank you so much for any advice you have
Here's the operative language from the SQL Server 2005 Developer Edition
license
--
If you comply with these license terms, you have the rights below for each
license you acquire.
1. OVERVIEW.
a. Software. The software includes development tools, software programs
and documentation.
b. License Model. The software is licensed on a per user basis.
2. INSTALLATION AND USE RIGHTS.
a. General. One user may install and use copies of the software to
design, develop, test and demonstrate your programs. Testing does not
include staging on a server in a production environment, such as loading
content prior to production use.
b. Included Microsoft Programs. These license terms apply to all
Microsoft programs included with the software. If the license terms with
any of those programs give you other rights that do not expressly conflict
with these license terms, you also have those rights.
3. ADDITIONAL LICENSING REQUIREMENTS AND/OR USE RIGHTS.
a. User Testing. Your end users may access the software to perform
acceptance tests on your programs.
b. Demonstration. Any person that has access to your internal network
may install and use copies of the software to demonstrate use of your
programs with the software. Those copies may not be used for any other
purpose.
--
If this doesn't answer your question, you might want to check with your
Microsoft representitive. Note that any number of developers, each of whom
owns a seperate Developer Edition license, can share one server instance of
SQL Server Developer edition.
To move from development to production an instance of SQL Server Developer
Edition can be upgraded to SQL Server Enterprise Edition, or the database
can be moved to a server running any other edition of SQL Server.
David.|||The fact that you want to post it on the Web is usually considered by
Microsoft as a production database; so the developer edition is not
sufficient. However, as this is only for tests, SQL-Server Express 2005
should be sufficient as the backend for this web thing; so you will be OK if
you use the Express edition as your backend database.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"lana1916" <lana1916@.discussions.microsoft.com> wrote in message
news:30191BB1-2DBD-4A67-BC8C-9AC8DB11649C@.microsoft.com...
>I am working for a university and we received funding to create an online
> searchable database for Company A. Company A has SQL Server 2005 and uses
> it
> within its company. We would like to create a database of articles and
> research for them, test it, post it on the Web, see if it works and then
> give
> the database to Company A. Can we do that with only the Developer Edition,
> or
> do we need to buy the SQL Server 2005? I know the only difference between
> the
> Developer Edition and the Enterprise edition is the license, what does
> that
> mean'
> Thank you so much for any advice you have.
searchable database for Company A. Company A has SQL Server 2005 and uses it
within its company. We would like to create a database of articles and
research for them, test it, post it on the Web, see if it works and then give
the database to Company A. Can we do that with only the Developer Edition, or
do we need to buy the SQL Server 2005? I know the only difference between the
Developer Edition and the Enterprise edition is the license, what does that
mean'
Thank you so much for any advice you have."lana1916" <lana1916@.discussions.microsoft.com> wrote in message
news:30191BB1-2DBD-4A67-BC8C-9AC8DB11649C@.microsoft.com...
>I am working for a university and we received funding to create an online
> searchable database for Company A. Company A has SQL Server 2005 and uses
> it
> within its company. We would like to create a database of articles and
> research for them, test it, post it on the Web, see if it works and then
> give
> the database to Company A. Can we do that with only the Developer Edition,
> or
> do we need to buy the SQL Server 2005? I know the only difference between
> the
> Developer Edition and the Enterprise edition is the license, what does
> that
> mean'
> Thank you so much for any advice you have
Here's the operative language from the SQL Server 2005 Developer Edition
license
--
If you comply with these license terms, you have the rights below for each
license you acquire.
1. OVERVIEW.
a. Software. The software includes development tools, software programs
and documentation.
b. License Model. The software is licensed on a per user basis.
2. INSTALLATION AND USE RIGHTS.
a. General. One user may install and use copies of the software to
design, develop, test and demonstrate your programs. Testing does not
include staging on a server in a production environment, such as loading
content prior to production use.
b. Included Microsoft Programs. These license terms apply to all
Microsoft programs included with the software. If the license terms with
any of those programs give you other rights that do not expressly conflict
with these license terms, you also have those rights.
3. ADDITIONAL LICENSING REQUIREMENTS AND/OR USE RIGHTS.
a. User Testing. Your end users may access the software to perform
acceptance tests on your programs.
b. Demonstration. Any person that has access to your internal network
may install and use copies of the software to demonstrate use of your
programs with the software. Those copies may not be used for any other
purpose.
--
If this doesn't answer your question, you might want to check with your
Microsoft representitive. Note that any number of developers, each of whom
owns a seperate Developer Edition license, can share one server instance of
SQL Server Developer edition.
To move from development to production an instance of SQL Server Developer
Edition can be upgraded to SQL Server Enterprise Edition, or the database
can be moved to a server running any other edition of SQL Server.
David.|||The fact that you want to post it on the Web is usually considered by
Microsoft as a production database; so the developer edition is not
sufficient. However, as this is only for tests, SQL-Server Express 2005
should be sufficient as the backend for this web thing; so you will be OK if
you use the Express edition as your backend database.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"lana1916" <lana1916@.discussions.microsoft.com> wrote in message
news:30191BB1-2DBD-4A67-BC8C-9AC8DB11649C@.microsoft.com...
>I am working for a university and we received funding to create an online
> searchable database for Company A. Company A has SQL Server 2005 and uses
> it
> within its company. We would like to create a database of articles and
> research for them, test it, post it on the Web, see if it works and then
> give
> the database to Company A. Can we do that with only the Developer Edition,
> or
> do we need to buy the SQL Server 2005? I know the only difference between
> the
> Developer Edition and the Enterprise edition is the license, what does
> that
> mean'
> Thank you so much for any advice you have.
Sunday, February 19, 2012
Developer edition 2005 upgrade to standard 2005?
We are trying to transisiton our network to sql server 2005... however
havent received our media kit yet for sql server 2005 and probably wont for
a while going by their transit times... we already have the license for sql
server 2005 standard edition but need to get this server up and running
soon! is there any way to install our developer edition copy or install the
trial edition then later "upgrade" to the standard edition license? thanks!Unless it has changed (which I doubt) it is not possible to upgrade from
developer to a licensed edition. You will need to uninstall and reinstall.
Andrew J. Kelly SQL MVP
"Brian Henry" <nospam@.nospam.com> wrote in message
news:OLz%23rGCLGHA.720@.TK2MSFTNGP14.phx.gbl...
> We are trying to transisiton our network to sql server 2005... however
> havent received our media kit yet for sql server 2005 and probably wont
> for a while going by their transit times... we already have the license
> for sql server 2005 standard edition but need to get this server up and
> running soon! is there any way to install our developer edition copy or
> install the trial edition then later "upgrade" to the standard edition
> license? thanks!
>|||The following article will help when the time comes to move the databases to
the new server instance.
How to move SQL Server databases to a new location by using Detach and
Attach functions in SQL Server
http://support.microsoft.com/kb/224071
"Brian Henry" <nospam@.nospam.com> wrote in message
news:OLz%23rGCLGHA.720@.TK2MSFTNGP14.phx.gbl...
> We are trying to transisiton our network to sql server 2005... however
> havent received our media kit yet for sql server 2005 and probably wont
> for a while going by their transit times... we already have the license
> for sql server 2005 standard edition but need to get this server up and
> running soon! is there any way to install our developer edition copy or
> install the trial edition then later "upgrade" to the standard edition
> license? thanks!
>|||SQL2005 BOL at
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/702359c4-6ca9-42a8-860c-
a95a802898a1.htm
indicates that SQL Server 2005 Developer edition to SQL2005 Standard edition
is one of the supported paths.
But I have not tried to do an in-place upgrade from Dev to Standard.
Linchi
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eGDoZ$CLGHA.360@.TK2MSFTNGP12.phx.gbl...
> Unless it has changed (which I doubt) it is not possible to upgrade from
> developer to a licensed edition. You will need to uninstall and reinstall.
> --
> Andrew J. Kelly SQL MVP
>
> "Brian Henry" <nospam@.nospam.com> wrote in message
> news:OLz%23rGCLGHA.720@.TK2MSFTNGP14.phx.gbl...
>|||You learn something new every day<g>. Back when 2000 just came out in RTM I
was told by a MS employee that this was not possible and never had a reason
to doubt it. I too would like to actually see it done successfully but it
appears it is possible. Thanks Linchi and sorry Brian.
Andrew J. Kelly SQL MVP
"Linchi Shea" <linchi_shea@.NOSPAMml.om> wrote in message
news:eY$dIUSLGHA.1124@.TK2MSFTNGP10.phx.gbl...
> SQL2005 BOL at
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/702359c4-6ca9-42a8-860
c-a95a802898a1.htm
> indicates that SQL Server 2005 Developer edition to SQL2005 Standard
> edition is one of the supported paths.
> But I have not tried to do an in-place upgrade from Dev to Standard.
> Linchi
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:eGDoZ$CLGHA.360@.TK2MSFTNGP12.phx.gbl...
>|||thanks everyone
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OCWCcvXLGHA.3732@.TK2MSFTNGP10.phx.gbl...
> You learn something new every day<g>. Back when 2000 just came out in RTM
> I was told by a MS employee that this was not possible and never had a
> reason to doubt it. I too would like to actually see it done successfully
> but it appears it is possible. Thanks Linchi and sorry Brian.
> --
> Andrew J. Kelly SQL MVP
>
> "Linchi Shea" <linchi_shea@.NOSPAMml.om> wrote in message
> news:eY$dIUSLGHA.1124@.TK2MSFTNGP10.phx.gbl...
>
havent received our media kit yet for sql server 2005 and probably wont for
a while going by their transit times... we already have the license for sql
server 2005 standard edition but need to get this server up and running
soon! is there any way to install our developer edition copy or install the
trial edition then later "upgrade" to the standard edition license? thanks!Unless it has changed (which I doubt) it is not possible to upgrade from
developer to a licensed edition. You will need to uninstall and reinstall.
Andrew J. Kelly SQL MVP
"Brian Henry" <nospam@.nospam.com> wrote in message
news:OLz%23rGCLGHA.720@.TK2MSFTNGP14.phx.gbl...
> We are trying to transisiton our network to sql server 2005... however
> havent received our media kit yet for sql server 2005 and probably wont
> for a while going by their transit times... we already have the license
> for sql server 2005 standard edition but need to get this server up and
> running soon! is there any way to install our developer edition copy or
> install the trial edition then later "upgrade" to the standard edition
> license? thanks!
>|||The following article will help when the time comes to move the databases to
the new server instance.
How to move SQL Server databases to a new location by using Detach and
Attach functions in SQL Server
http://support.microsoft.com/kb/224071
"Brian Henry" <nospam@.nospam.com> wrote in message
news:OLz%23rGCLGHA.720@.TK2MSFTNGP14.phx.gbl...
> We are trying to transisiton our network to sql server 2005... however
> havent received our media kit yet for sql server 2005 and probably wont
> for a while going by their transit times... we already have the license
> for sql server 2005 standard edition but need to get this server up and
> running soon! is there any way to install our developer edition copy or
> install the trial edition then later "upgrade" to the standard edition
> license? thanks!
>|||SQL2005 BOL at
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/702359c4-6ca9-42a8-860c-
a95a802898a1.htm
indicates that SQL Server 2005 Developer edition to SQL2005 Standard edition
is one of the supported paths.
But I have not tried to do an in-place upgrade from Dev to Standard.
Linchi
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eGDoZ$CLGHA.360@.TK2MSFTNGP12.phx.gbl...
> Unless it has changed (which I doubt) it is not possible to upgrade from
> developer to a licensed edition. You will need to uninstall and reinstall.
> --
> Andrew J. Kelly SQL MVP
>
> "Brian Henry" <nospam@.nospam.com> wrote in message
> news:OLz%23rGCLGHA.720@.TK2MSFTNGP14.phx.gbl...
>|||You learn something new every day<g>. Back when 2000 just came out in RTM I
was told by a MS employee that this was not possible and never had a reason
to doubt it. I too would like to actually see it done successfully but it
appears it is possible. Thanks Linchi and sorry Brian.
Andrew J. Kelly SQL MVP
"Linchi Shea" <linchi_shea@.NOSPAMml.om> wrote in message
news:eY$dIUSLGHA.1124@.TK2MSFTNGP10.phx.gbl...
> SQL2005 BOL at
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/702359c4-6ca9-42a8-860
c-a95a802898a1.htm
> indicates that SQL Server 2005 Developer edition to SQL2005 Standard
> edition is one of the supported paths.
> But I have not tried to do an in-place upgrade from Dev to Standard.
> Linchi
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:eGDoZ$CLGHA.360@.TK2MSFTNGP12.phx.gbl...
>|||thanks everyone
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OCWCcvXLGHA.3732@.TK2MSFTNGP10.phx.gbl...
> You learn something new every day<g>. Back when 2000 just came out in RTM
> I was told by a MS employee that this was not possible and never had a
> reason to doubt it. I too would like to actually see it done successfully
> but it appears it is possible. Thanks Linchi and sorry Brian.
> --
> Andrew J. Kelly SQL MVP
>
> "Linchi Shea" <linchi_shea@.NOSPAMml.om> wrote in message
> news:eY$dIUSLGHA.1124@.TK2MSFTNGP10.phx.gbl...
>
Subscribe to:
Posts (Atom)