Hi all
I have got 3 columns in my table- start date,finish date and cost..in the
following format...
start_date finish_date cost
12/12/2000 20/12/2000 $2000
01/09/2000 12/10/2000 $400
Now if the month and year of the start and finish date is same, the cost
remains same...
but if the month of the two dates are different, i have to distribute the
cost between the two months by calculating the cost for the number of days
for both of the months..
but i am not able to figure out how?
i am using sql 2005 ..
my table has got about 1 million rows...
pls helpQuestion. What exactly is your expected result? It's not entirely clear
from your description. I think you're saying that for December 2000 the
cost should be $2,000. For the other, it soundes like you are looking to
pro-rate the $400? If so, across what time period do you want it pro-rated
exactly?
"mita" <mita@.discussions.microsoft.com> wrote in message
news:D24E0F04-CD11-4C6E-AB9D-6B23384F5964@.microsoft.com...
> Hi all
> I have got 3 columns in my table- start date,finish date and cost..in the
> following format...
> start_date finish_date cost
> 12/12/2000 20/12/2000 $2000
> 01/09/2000 12/10/2000 $400
> Now if the month and year of the start and finish date is same, the cost
> remains same...
> but if the month of the two dates are different, i have to distribute the
> cost between the two months by calculating the cost for the number of days
> for both of the months..
> but i am not able to figure out how?
> i am using sql 2005 ..
> my table has got about 1 million rows...
> pls help|||mita
USE My_Test1
CREATE TABLE dbo.Test
(
start_date DATETIME NOT NULL,
finish_date DATETIME NOT NULL,
cost DECIMAL(18,3)
)
INSERT INTO dbo.Test VALUES ('20001212','20001220',2000)
INSERT INTO dbo.Test VALUES ('20000901','20001012',400)
INSERT INTO dbo.Test VALUES ('20000901','20001212',300)
WITH mytest (start_date,finish_date,cost,Diff_Days)
AS
(
SELECT start_date,finish_date,cost,
DATEDIFF(month, start_date,finish_date) AS Diff_Days
FROM dbo.Test
)
SELECT CASE WHEN Diff_Days =0 THEN cost ELSE cost*Diff_Days END
FROM mytest
"mita" <mita@.discussions.microsoft.com> wrote in message
news:D24E0F04-CD11-4C6E-AB9D-6B23384F5964@.microsoft.com...
> Hi all
> I have got 3 columns in my table- start date,finish date and cost..in the
> following format...
> start_date finish_date cost
> 12/12/2000 20/12/2000 $2000
> 01/09/2000 12/10/2000 $400
> Now if the month and year of the start and finish date is same, the cost
> remains same...
> but if the month of the two dates are different, i have to distribute the
> cost between the two months by calculating the cost for the number of days
> for both of the months..
> but i am not able to figure out how?
> i am using sql 2005 ..
> my table has got about 1 million rows...
> pls help|||mita wrote:
> Hi all
> I have got 3 columns in my table- start date,finish date and cost..in the
> following format...
> start_date finish_date cost
> 12/12/2000 20/12/2000 $2000
> 01/09/2000 12/10/2000 $400
> Now if the month and year of the start and finish date is same, the cost
> remains same...
> but if the month of the two dates are different, i have to distribute the
> cost between the two months by calculating the cost for the number of days
> for both of the months..
> but i am not able to figure out how?
> i am using sql 2005 ..
> my table has got about 1 million rows...
> pls help
This will handle a two-month period, anything more than that is going to
be more complicated:
USE tempdb
GO
CREATE TABLE dbo.Test (
start_date DATETIME NOT NULL,
finish_date DATETIME NOT NULL,
cost DECIMAL(18,3)
)
INSERT INTO dbo.Test VALUES ('20001212','20001220',2000)
INSERT INTO dbo.Test VALUES ('20000901','20001012',400)
INSERT INTO dbo.Test VALUES ('20000901','20001212',300)
GO
CREATE FUNCTION dbo.DaysInMonth(@.Date DATETIME)
RETURNS INT
AS
BEGIN
RETURN (DATEPART(day, CONVERT(DATETIME, RTRIM(CONVERT(CHAR(2),
DATEPART(month, @.Date) + CASE WHEN DATEPART(month, @.Date) = 12 THEN -11
ELSE 1 END)) + '/1/' + CONVERT(CHAR(4), DATEPART(year, @.Date))) - 1))
END
GO
SELECT
start_date,
finish_date,
cost,
CASE WHEN DATEPART(month, start_date) = DATEPART(month, finish_date)
THEN cost ELSE cost * (dbo.DaysInMonth(start_date) - DATEPART(day,
start_date)) / CONVERT(NUMERIC, DATEDIFF(day, start_date, finish_date),
4) END AS portion1,
CASE WHEN DATEPART(month, start_date) = DATEPART(month, finish_date)
THEN 0 ELSE cost - (cost * (dbo.DaysInMonth(start_date) - DATEPART(day,
start_date)) / CONVERT(NUMERIC, DATEDIFF(day, start_date, finish_date),
4)) END AS portion2
FROM dbo.Test|||HI Mike u r right..i need to prorate $400 according to the no. of days...for
ex cost for 30 days of september and 12 days for october
"Mike C#" wrote:
> Question. What exactly is your expected result? It's not entirely clear
> from your description. I think you're saying that for December 2000 the
> cost should be $2,000. For the other, it soundes like you are looking to
> pro-rate the $400? If so, across what time period do you want it pro-rated
> exactly?
> "mita" <mita@.discussions.microsoft.com> wrote in message
> news:D24E0F04-CD11-4C6E-AB9D-6B23384F5964@.microsoft.com...
> > Hi all
> > I have got 3 columns in my table- start date,finish date and cost..in the
> > following format...
> >
> > start_date finish_date cost
> > 12/12/2000 20/12/2000 $2000
> > 01/09/2000 12/10/2000 $400
> >
> > Now if the month and year of the start and finish date is same, the cost
> > remains same...
> > but if the month of the two dates are different, i have to distribute the
> > cost between the two months by calculating the cost for the number of days
> > for both of the months..
> > but i am not able to figure out how?
> > i am using sql 2005 ..
> > my table has got about 1 million rows...
> > pls help
>
>|||On Sat, 17 Jun 2006 17:35:02 -0700, mita wrote:
>Hi all
>I have got 3 columns in my table- start date,finish date and cost..in the
>following format...
>start_date finish_date cost
>12/12/2000 20/12/2000 $2000
>01/09/2000 12/10/2000 $400
>Now if the month and year of the start and finish date is same, the cost
>remains same...
>but if the month of the two dates are different, i have to distribute the
>cost between the two months by calculating the cost for the number of days
>for both of the months..
>but i am not able to figure out how?
>i am using sql 2005 ..
>my table has got about 1 million rows...
>pls help
Hi mita,
First, you need to create a table that holds all months in your
reporting period (or more). Something like this:
CREATE TABLE dbo.Months
(MonthStart datetime NOT NULL PRIMARY KEY,
MonthEnd datetime NOT NULL);
go
DECLARE @.TheMonth datetime;
SET @.TheMonth = '200000101'; -- Start at january 2000
WHILE @.TheMonth <= '20191231' -- End at december 2019
BEGIN;
INSERT INTO dbo.Months (MonthStart, MonthEnd)
VALUES (@.TheMonth, DATEADD(day, -1, DATEADD(month, 1, @.TheMonth)));
SET @.TheMonth = DATEADD(month, 1, @.TheMonth);
END;
The above is a one time operation, provided you never drop the table.
Don't forget to add some extra months to the table in a year or ten!
With this table in place, your query becomes something like this:
SELECT PeriodStart, PeriodEnd,
TotalCost * DATEDIFF (day, PeriodStart, PeriodEnd)
/ DATEDIFF (day, start_date, finish_date) AS cost
FROM (SELECT CASE WHEN a.start_date > b.MonthStart
THEN a.start_date
ELSE b.MonthStart
END AS PeriodStart,
CASE WHEN a.finish_date < b.MonthEnd
THEN a.finish_date
ELSE b.MonthEnd
END AS PeriodEnd,
a.start_date, a.finish_date,
a.cost AS TotalCost
FROM dbo.MyTable AS a
INNER JOIN dbo.Months AS b
ON b.MonthStart <= a.finish_date
AND b.MonthStart >= a.start_date) AS d
(Untested - see www.aspfaq.com/5006 if you prefer a tested reply)
--
Hugo Kornelis, SQL Server MVP|||hi hugo
i just ran this query for creating the months table which u suggested... i
am getting an error....
"Conversion failed when converting datetime from character string." what do
i do?
"Tracy McKibben" wrote:
> mita wrote:
> > Hi all
> > I have got 3 columns in my table- start date,finish date and cost..in the
> > following format...
> >
> > start_date finish_date cost
> > 12/12/2000 20/12/2000 $2000
> > 01/09/2000 12/10/2000 $400
> >
> > Now if the month and year of the start and finish date is same, the cost
> > remains same...
> > but if the month of the two dates are different, i have to distribute the
> > cost between the two months by calculating the cost for the number of days
> > for both of the months..
> > but i am not able to figure out how?
> > i am using sql 2005 ..
> > my table has got about 1 million rows...
> > pls help
> This will handle a two-month period, anything more than that is going to
> be more complicated:
> USE tempdb
> GO
> CREATE TABLE dbo.Test (
> start_date DATETIME NOT NULL,
> finish_date DATETIME NOT NULL,
> cost DECIMAL(18,3)
> )
> INSERT INTO dbo.Test VALUES ('20001212','20001220',2000)
> INSERT INTO dbo.Test VALUES ('20000901','20001012',400)
> INSERT INTO dbo.Test VALUES ('20000901','20001212',300)
> GO
> CREATE FUNCTION dbo.DaysInMonth(@.Date DATETIME)
> RETURNS INT
> AS
> BEGIN
> RETURN (DATEPART(day, CONVERT(DATETIME, RTRIM(CONVERT(CHAR(2),
> DATEPART(month, @.Date) + CASE WHEN DATEPART(month, @.Date) = 12 THEN -11
> ELSE 1 END)) + '/1/' + CONVERT(CHAR(4), DATEPART(year, @.Date))) - 1))
> END
> GO
> SELECT
> start_date,
> finish_date,
> cost,
> CASE WHEN DATEPART(month, start_date) = DATEPART(month, finish_date)
> THEN cost ELSE cost * (dbo.DaysInMonth(start_date) - DATEPART(day,
> start_date)) / CONVERT(NUMERIC, DATEDIFF(day, start_date, finish_date),
> 4) END AS portion1,
> CASE WHEN DATEPART(month, start_date) = DATEPART(month, finish_date)
> THEN 0 ELSE cost - (cost * (dbo.DaysInMonth(start_date) - DATEPART(day,
> start_date)) / CONVERT(NUMERIC, DATEDIFF(day, start_date, finish_date),
> 4)) END AS portion2
> FROM dbo.Test
>|||GO
CREATE TABLE [dbo].[DSS](
[Service Start] [datetime] NULL,
[Service End] [datetime] NULL,
[FMIS Code] [nvarchar](255) COLLATE Latin1_General_CI_AS NULL,
[Client NHI] [nvarchar](255) COLLATE Latin1_General_CI_AS NULL,
[No of Units] [float] NULL,
) ON [PRIMARY]
"Hugo Kornelis" wrote:
> On Sat, 17 Jun 2006 17:35:02 -0700, mita wrote:
> >Hi all
> >I have got 3 columns in my table- start date,finish date and cost..in the
> >following format...
> >
> >start_date finish_date cost
> >12/12/2000 20/12/2000 $2000
> >01/09/2000 12/10/2000 $400
> >
> >Now if the month and year of the start and finish date is same, the cost
> >remains same...
> >but if the month of the two dates are different, i have to distribute the
> >cost between the two months by calculating the cost for the number of days
> >for both of the months..
> >but i am not able to figure out how?
> >i am using sql 2005 ..
> >my table has got about 1 million rows...
> >pls help
> Hi mita,
> First, you need to create a table that holds all months in your
> reporting period (or more). Something like this:
> CREATE TABLE dbo.Months
> (MonthStart datetime NOT NULL PRIMARY KEY,
> MonthEnd datetime NOT NULL);
> go
> DECLARE @.TheMonth datetime;
> SET @.TheMonth = '200000101'; -- Start at january 2000
> WHILE @.TheMonth <= '20191231' -- End at december 2019
> BEGIN;
> INSERT INTO dbo.Months (MonthStart, MonthEnd)
> VALUES (@.TheMonth, DATEADD(day, -1, DATEADD(month, 1, @.TheMonth)));
> SET @.TheMonth = DATEADD(month, 1, @.TheMonth);
> END;
> The above is a one time operation, provided you never drop the table.
> Don't forget to add some extra months to the table in a year or ten!
> With this table in place, your query becomes something like this:
> SELECT PeriodStart, PeriodEnd,
> TotalCost * DATEDIFF (day, PeriodStart, PeriodEnd)
> / DATEDIFF (day, start_date, finish_date) AS cost
> FROM (SELECT CASE WHEN a.start_date > b.MonthStart
> THEN a.start_date
> ELSE b.MonthStart
> END AS PeriodStart,
> CASE WHEN a.finish_date < b.MonthEnd
> THEN a.finish_date
> ELSE b.MonthEnd
> END AS PeriodEnd,
> a.start_date, a.finish_date,
> a.cost AS TotalCost
> FROM dbo.MyTable AS a
> INNER JOIN dbo.Months AS b
> ON b.MonthStart <= a.finish_date
> AND b.MonthStart >= a.start_date) AS d
> (Untested - see www.aspfaq.com/5006 if you prefer a tested reply)
> --
> Hugo Kornelis, SQL Server MVP
>|||On Sun, 18 Jun 2006 16:32:02 -0700, mita wrote:
>"Hugo Kornelis" wrote:
(snip)
>> First, you need to create a table that holds all months in your
>> reporting period (or more). Something like this:
>> CREATE TABLE dbo.Months
>> (MonthStart datetime NOT NULL PRIMARY KEY,
>> MonthEnd datetime NOT NULL);
>> go
>> DECLARE @.TheMonth datetime;
>> SET @.TheMonth = '200000101'; -- Start at january 2000
>> WHILE @.TheMonth <= '20191231' -- End at december 2019
>> BEGIN;
>> INSERT INTO dbo.Months (MonthStart, MonthEnd)
>> VALUES (@.TheMonth, DATEADD(day, -1, DATEADD(month, 1, @.TheMonth)));
>> SET @.TheMonth = DATEADD(month, 1, @.TheMonth);
>> END;
>hi hugo
>i just ran this query for creating the months table which u suggested... i
>am getting an error....
>"Conversion failed when converting datetime from character string." what do
>i do?
Hi Mita,
Sorry for the delayed reply.
The error is caused by a stupid typo in my code (quoted above) - I have
one zero to many in the date constant for Jan 1st, 2000. If you change
'200000101' to '20000101', the error should go away.
--
Hugo Kornelis, SQL Server MVP
Showing posts with label cost. Show all posts
Showing posts with label cost. Show all posts
Thursday, March 29, 2012
Sunday, February 26, 2012
enterprise manager cost?
I need to put enterprise mgr on a desktop at my office to administer a sql
server database that I am renting from a hosting service. The server is
shared at the hosting site and I pay only the monthly 39.00 for that right.
Do I have to buy enterprise manager to be legal. If so any idea how much it
would cost for a single processor, one user desktop computer?
thanks, leonThis one is tricky. For properly licensed copies of SQL Server
installations, which I am assuming your host has done on your behalf, there
is no additional charge for the installation nor use of the client-side
tools. However, it is unlikely that you will have port 1433 outbound open
on your company's firewall nor will the host likely have port 1433 inbound
opened to the SQL Server installation.
Normally, the host will provide terminal server sessions, in which case you
would use the remote installation of the client tools.
Sincerely,
Anthony Thomas
"enterprise manager cost?" <enterprise manager
cost?@.discussions.microsoft.com> wrote in message
news:11367BEF-6886-49FF-A5D7-B702AE964688@.microsoft.com...
> I need to put enterprise mgr on a desktop at my office to administer a sql
> server database that I am renting from a hosting service. The server is
> shared at the hosting site and I pay only the monthly 39.00 for that
right.
> Do I have to buy enterprise manager to be legal. If so any idea how much
it
> would cost for a single processor, one user desktop computer?
> thanks, leon|||Thanks for responding,
I orginally thought they would allow me to access through ts also but said I
would just be allowed to access that particular database which makes sense if
there are other people's databases on the server they wouldn't want to give
me access to the whole server.
I think I am just going to be given a domain.server name and once hooked up
only that database would appear because that is all I would have rights to.
I also don't think they are going to give me access to their copy of
Enterprise manager from there disk I will just be expected to provide it.
I found one company that offers an product to access from www.teratrax.com
but I am used to sql server tools and need the dts packages.
"AnthonyThomas" wrote:
> This one is tricky. For properly licensed copies of SQL Server
> installations, which I am assuming your host has done on your behalf, there
> is no additional charge for the installation nor use of the client-side
> tools. However, it is unlikely that you will have port 1433 outbound open
> on your company's firewall nor will the host likely have port 1433 inbound
> opened to the SQL Server installation.
> Normally, the host will provide terminal server sessions, in which case you
> would use the remote installation of the client tools.
> Sincerely,
>
> Anthony Thomas
>
> --
> "enterprise manager cost?" <enterprise manager
> cost?@.discussions.microsoft.com> wrote in message
> news:11367BEF-6886-49FF-A5D7-B702AE964688@.microsoft.com...
> > I need to put enterprise mgr on a desktop at my office to administer a sql
> > server database that I am renting from a hosting service. The server is
> > shared at the hosting site and I pay only the monthly 39.00 for that
> right.
> >
> > Do I have to buy enterprise manager to be legal. If so any idea how much
> it
> > would cost for a single processor, one user desktop computer?
> >
> > thanks, leon
>
>|||You could purchase the developers edition for around $50 -
you'd have all the client tools that way. Other options are
here: http://www.aspfaq.com/show.asp?id=2442
-Sue
On Thu, 11 Nov 2004 13:10:01 -0800, "LLittle"
<LLittle@.discussions.microsoft.com> wrote:
>Thanks for responding,
>I orginally thought they would allow me to access through ts also but said I
>would just be allowed to access that particular database which makes sense if
>there are other people's databases on the server they wouldn't want to give
>me access to the whole server.
>I think I am just going to be given a domain.server name and once hooked up
>only that database would appear because that is all I would have rights to.
>I also don't think they are going to give me access to their copy of
>Enterprise manager from there disk I will just be expected to provide it.
>I found one company that offers an product to access from www.teratrax.com
>but I am used to sql server tools and need the dts packages.
>
>
>"AnthonyThomas" wrote:
>> This one is tricky. For properly licensed copies of SQL Server
>> installations, which I am assuming your host has done on your behalf, there
>> is no additional charge for the installation nor use of the client-side
>> tools. However, it is unlikely that you will have port 1433 outbound open
>> on your company's firewall nor will the host likely have port 1433 inbound
>> opened to the SQL Server installation.
>> Normally, the host will provide terminal server sessions, in which case you
>> would use the remote installation of the client tools.
>> Sincerely,
>>
>> Anthony Thomas
>>
>> --
>> "enterprise manager cost?" <enterprise manager
>> cost?@.discussions.microsoft.com> wrote in message
>> news:11367BEF-6886-49FF-A5D7-B702AE964688@.microsoft.com...
>> > I need to put enterprise mgr on a desktop at my office to administer a sql
>> > server database that I am renting from a hosting service. The server is
>> > shared at the hosting site and I pay only the monthly 39.00 for that
>> right.
>> >
>> > Do I have to buy enterprise manager to be legal. If so any idea how much
>> it
>> > would cost for a single processor, one user desktop computer?
>> >
>> > thanks, leon
>>|||Sue Hoegemeier wrote:
> You could purchase the developers edition for around $50 -
> you'd have all the client tools that way. Other options are
> here: http://www.aspfaq.com/show.asp?id=2442
> -Sue
That wouldn't work legally.
You can use the SQL Server Web Administrator from MS without any
licensing requirements. I don't know that the ASP license for SQL Server
(what the ISP probably has) allows distribution of client tools. The web
data administrator should allow you to administer SQL Server from your
web browser.
http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en
David Gugick
Imceda Software
www.imceda.com|||Depends on how it's licensed. I never heard of the ASP
license for SQL Server though - don't think there is such a
thing. See the link referenced for options - there are some
licensing explanations for the different options.
-Sue
On Thu, 11 Nov 2004 23:13:01 -0500, "David Gugick"
<davidg-nospam@.imceda.com> wrote:
>Sue Hoegemeier wrote:
>> You could purchase the developers edition for around $50 -
>> you'd have all the client tools that way. Other options are
>> here: http://www.aspfaq.com/show.asp?id=2442
>> -Sue
>That wouldn't work legally.
>You can use the SQL Server Web Administrator from MS without any
>licensing requirements. I don't know that the ASP license for SQL Server
>(what the ISP probably has) allows distribution of client tools. The web
>data administrator should allow you to administer SQL Server from your
>web browser.
>http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en|||See the end of Brian's article for a note about using SQL Server in an
ASP environment:
http://www.developer.com/tech/article.php/630451
From Microsoft:
http://www.microsoft.com/serviceproviders/licensing/licensing.asp
David Gugick
Imceda Software
www.imceda.com
server database that I am renting from a hosting service. The server is
shared at the hosting site and I pay only the monthly 39.00 for that right.
Do I have to buy enterprise manager to be legal. If so any idea how much it
would cost for a single processor, one user desktop computer?
thanks, leonThis one is tricky. For properly licensed copies of SQL Server
installations, which I am assuming your host has done on your behalf, there
is no additional charge for the installation nor use of the client-side
tools. However, it is unlikely that you will have port 1433 outbound open
on your company's firewall nor will the host likely have port 1433 inbound
opened to the SQL Server installation.
Normally, the host will provide terminal server sessions, in which case you
would use the remote installation of the client tools.
Sincerely,
Anthony Thomas
"enterprise manager cost?" <enterprise manager
cost?@.discussions.microsoft.com> wrote in message
news:11367BEF-6886-49FF-A5D7-B702AE964688@.microsoft.com...
> I need to put enterprise mgr on a desktop at my office to administer a sql
> server database that I am renting from a hosting service. The server is
> shared at the hosting site and I pay only the monthly 39.00 for that
right.
> Do I have to buy enterprise manager to be legal. If so any idea how much
it
> would cost for a single processor, one user desktop computer?
> thanks, leon|||Thanks for responding,
I orginally thought they would allow me to access through ts also but said I
would just be allowed to access that particular database which makes sense if
there are other people's databases on the server they wouldn't want to give
me access to the whole server.
I think I am just going to be given a domain.server name and once hooked up
only that database would appear because that is all I would have rights to.
I also don't think they are going to give me access to their copy of
Enterprise manager from there disk I will just be expected to provide it.
I found one company that offers an product to access from www.teratrax.com
but I am used to sql server tools and need the dts packages.
"AnthonyThomas" wrote:
> This one is tricky. For properly licensed copies of SQL Server
> installations, which I am assuming your host has done on your behalf, there
> is no additional charge for the installation nor use of the client-side
> tools. However, it is unlikely that you will have port 1433 outbound open
> on your company's firewall nor will the host likely have port 1433 inbound
> opened to the SQL Server installation.
> Normally, the host will provide terminal server sessions, in which case you
> would use the remote installation of the client tools.
> Sincerely,
>
> Anthony Thomas
>
> --
> "enterprise manager cost?" <enterprise manager
> cost?@.discussions.microsoft.com> wrote in message
> news:11367BEF-6886-49FF-A5D7-B702AE964688@.microsoft.com...
> > I need to put enterprise mgr on a desktop at my office to administer a sql
> > server database that I am renting from a hosting service. The server is
> > shared at the hosting site and I pay only the monthly 39.00 for that
> right.
> >
> > Do I have to buy enterprise manager to be legal. If so any idea how much
> it
> > would cost for a single processor, one user desktop computer?
> >
> > thanks, leon
>
>|||You could purchase the developers edition for around $50 -
you'd have all the client tools that way. Other options are
here: http://www.aspfaq.com/show.asp?id=2442
-Sue
On Thu, 11 Nov 2004 13:10:01 -0800, "LLittle"
<LLittle@.discussions.microsoft.com> wrote:
>Thanks for responding,
>I orginally thought they would allow me to access through ts also but said I
>would just be allowed to access that particular database which makes sense if
>there are other people's databases on the server they wouldn't want to give
>me access to the whole server.
>I think I am just going to be given a domain.server name and once hooked up
>only that database would appear because that is all I would have rights to.
>I also don't think they are going to give me access to their copy of
>Enterprise manager from there disk I will just be expected to provide it.
>I found one company that offers an product to access from www.teratrax.com
>but I am used to sql server tools and need the dts packages.
>
>
>"AnthonyThomas" wrote:
>> This one is tricky. For properly licensed copies of SQL Server
>> installations, which I am assuming your host has done on your behalf, there
>> is no additional charge for the installation nor use of the client-side
>> tools. However, it is unlikely that you will have port 1433 outbound open
>> on your company's firewall nor will the host likely have port 1433 inbound
>> opened to the SQL Server installation.
>> Normally, the host will provide terminal server sessions, in which case you
>> would use the remote installation of the client tools.
>> Sincerely,
>>
>> Anthony Thomas
>>
>> --
>> "enterprise manager cost?" <enterprise manager
>> cost?@.discussions.microsoft.com> wrote in message
>> news:11367BEF-6886-49FF-A5D7-B702AE964688@.microsoft.com...
>> > I need to put enterprise mgr on a desktop at my office to administer a sql
>> > server database that I am renting from a hosting service. The server is
>> > shared at the hosting site and I pay only the monthly 39.00 for that
>> right.
>> >
>> > Do I have to buy enterprise manager to be legal. If so any idea how much
>> it
>> > would cost for a single processor, one user desktop computer?
>> >
>> > thanks, leon
>>|||Sue Hoegemeier wrote:
> You could purchase the developers edition for around $50 -
> you'd have all the client tools that way. Other options are
> here: http://www.aspfaq.com/show.asp?id=2442
> -Sue
That wouldn't work legally.
You can use the SQL Server Web Administrator from MS without any
licensing requirements. I don't know that the ASP license for SQL Server
(what the ISP probably has) allows distribution of client tools. The web
data administrator should allow you to administer SQL Server from your
web browser.
http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en
David Gugick
Imceda Software
www.imceda.com|||Depends on how it's licensed. I never heard of the ASP
license for SQL Server though - don't think there is such a
thing. See the link referenced for options - there are some
licensing explanations for the different options.
-Sue
On Thu, 11 Nov 2004 23:13:01 -0500, "David Gugick"
<davidg-nospam@.imceda.com> wrote:
>Sue Hoegemeier wrote:
>> You could purchase the developers edition for around $50 -
>> you'd have all the client tools that way. Other options are
>> here: http://www.aspfaq.com/show.asp?id=2442
>> -Sue
>That wouldn't work legally.
>You can use the SQL Server Web Administrator from MS without any
>licensing requirements. I don't know that the ASP license for SQL Server
>(what the ISP probably has) allows distribution of client tools. The web
>data administrator should allow you to administer SQL Server from your
>web browser.
>http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en|||See the end of Brian's article for a note about using SQL Server in an
ASP environment:
http://www.developer.com/tech/article.php/630451
From Microsoft:
http://www.microsoft.com/serviceproviders/licensing/licensing.asp
David Gugick
Imceda Software
www.imceda.com
enterprise manager cost?
I need to put enterprise mgr on a desktop at my office to administer a sql
server database that I am renting from a hosting service. The server is
shared at the hosting site and I pay only the monthly 39.00 for that right.
Do I have to buy enterprise manager to be legal. If so any idea how much it
would cost for a single processor, one user desktop computer?
thanks, leon
This one is tricky. For properly licensed copies of SQL Server
installations, which I am assuming your host has done on your behalf, there
is no additional charge for the installation nor use of the client-side
tools. However, it is unlikely that you will have port 1433 outbound open
on your company's firewall nor will the host likely have port 1433 inbound
opened to the SQL Server installation.
Normally, the host will provide terminal server sessions, in which case you
would use the remote installation of the client tools.
Sincerely,
Anthony Thomas
"enterprise manager cost?" <enterprise manager
cost?@.discussions.microsoft.com> wrote in message
news:11367BEF-6886-49FF-A5D7-B702AE964688@.microsoft.com...
> I need to put enterprise mgr on a desktop at my office to administer a sql
> server database that I am renting from a hosting service. The server is
> shared at the hosting site and I pay only the monthly 39.00 for that
right.
> Do I have to buy enterprise manager to be legal. If so any idea how much
it
> would cost for a single processor, one user desktop computer?
> thanks, leon
|||Thanks for responding,
I orginally thought they would allow me to access through ts also but said I
would just be allowed to access that particular database which makes sense if
there are other people's databases on the server they wouldn't want to give
me access to the whole server.
I think I am just going to be given a domain.server name and once hooked up
only that database would appear because that is all I would have rights to.
I also don't think they are going to give me access to their copy of
Enterprise manager from there disk I will just be expected to provide it.
I found one company that offers an product to access from www.teratrax.com
but I am used to sql server tools and need the dts packages.
"AnthonyThomas" wrote:
> This one is tricky. For properly licensed copies of SQL Server
> installations, which I am assuming your host has done on your behalf, there
> is no additional charge for the installation nor use of the client-side
> tools. However, it is unlikely that you will have port 1433 outbound open
> on your company's firewall nor will the host likely have port 1433 inbound
> opened to the SQL Server installation.
> Normally, the host will provide terminal server sessions, in which case you
> would use the remote installation of the client tools.
> Sincerely,
>
> Anthony Thomas
>
> --
> "enterprise manager cost?" <enterprise manager
> cost?@.discussions.microsoft.com> wrote in message
> news:11367BEF-6886-49FF-A5D7-B702AE964688@.microsoft.com...
> right.
> it
>
>
|||You could purchase the developers edition for around $50 -
you'd have all the client tools that way. Other options are
here: http://www.aspfaq.com/show.asp?id=2442
-Sue
On Thu, 11 Nov 2004 13:10:01 -0800, "LLittle"
<LLittle@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Thanks for responding,
>I orginally thought they would allow me to access through ts also but said I
>would just be allowed to access that particular database which makes sense if
>there are other people's databases on the server they wouldn't want to give
>me access to the whole server.
>I think I am just going to be given a domain.server name and once hooked up
>only that database would appear because that is all I would have rights to.
>I also don't think they are going to give me access to their copy of
>Enterprise manager from there disk I will just be expected to provide it.
>I found one company that offers an product to access from www.teratrax.com
>but I am used to sql server tools and need the dts packages.
>
>
>"AnthonyThomas" wrote:
|||Sue Hoegemeier wrote:
> You could purchase the developers edition for around $50 -
> you'd have all the client tools that way. Other options are
> here: http://www.aspfaq.com/show.asp?id=2442
> -Sue
That wouldn't work legally.
You can use the SQL Server Web Administrator from MS without any
licensing requirements. I don't know that the ASP license for SQL Server
(what the ISP probably has) allows distribution of client tools. The web
data administrator should allow you to administer SQL Server from your
web browser.
http://www.microsoft.com/downloads/d...displaylang=en
David Gugick
Imceda Software
www.imceda.com
|||Depends on how it's licensed. I never heard of the ASP
license for SQL Server though - don't think there is such a
thing. See the link referenced for options - there are some
licensing explanations for the different options.
-Sue
On Thu, 11 Nov 2004 23:13:01 -0500, "David Gugick"
<davidg-nospam@.imceda.com> wrote:
>Sue Hoegemeier wrote:
>That wouldn't work legally.
>You can use the SQL Server Web Administrator from MS without any
>licensing requirements. I don't know that the ASP license for SQL Server
>(what the ISP probably has) allows distribution of client tools. The web
>data administrator should allow you to administer SQL Server from your
>web browser.
>http://www.microsoft.com/downloads/d...displaylang=en
|||See the end of Brian's article for a note about using SQL Server in an
ASP environment:
http://www.developer.com/tech/article.php/630451
From Microsoft:
http://www.microsoft.com/serviceprov.../licensing.asp
David Gugick
Imceda Software
www.imceda.com
server database that I am renting from a hosting service. The server is
shared at the hosting site and I pay only the monthly 39.00 for that right.
Do I have to buy enterprise manager to be legal. If so any idea how much it
would cost for a single processor, one user desktop computer?
thanks, leon
This one is tricky. For properly licensed copies of SQL Server
installations, which I am assuming your host has done on your behalf, there
is no additional charge for the installation nor use of the client-side
tools. However, it is unlikely that you will have port 1433 outbound open
on your company's firewall nor will the host likely have port 1433 inbound
opened to the SQL Server installation.
Normally, the host will provide terminal server sessions, in which case you
would use the remote installation of the client tools.
Sincerely,
Anthony Thomas
"enterprise manager cost?" <enterprise manager
cost?@.discussions.microsoft.com> wrote in message
news:11367BEF-6886-49FF-A5D7-B702AE964688@.microsoft.com...
> I need to put enterprise mgr on a desktop at my office to administer a sql
> server database that I am renting from a hosting service. The server is
> shared at the hosting site and I pay only the monthly 39.00 for that
right.
> Do I have to buy enterprise manager to be legal. If so any idea how much
it
> would cost for a single processor, one user desktop computer?
> thanks, leon
|||Thanks for responding,
I orginally thought they would allow me to access through ts also but said I
would just be allowed to access that particular database which makes sense if
there are other people's databases on the server they wouldn't want to give
me access to the whole server.
I think I am just going to be given a domain.server name and once hooked up
only that database would appear because that is all I would have rights to.
I also don't think they are going to give me access to their copy of
Enterprise manager from there disk I will just be expected to provide it.
I found one company that offers an product to access from www.teratrax.com
but I am used to sql server tools and need the dts packages.
"AnthonyThomas" wrote:
> This one is tricky. For properly licensed copies of SQL Server
> installations, which I am assuming your host has done on your behalf, there
> is no additional charge for the installation nor use of the client-side
> tools. However, it is unlikely that you will have port 1433 outbound open
> on your company's firewall nor will the host likely have port 1433 inbound
> opened to the SQL Server installation.
> Normally, the host will provide terminal server sessions, in which case you
> would use the remote installation of the client tools.
> Sincerely,
>
> Anthony Thomas
>
> --
> "enterprise manager cost?" <enterprise manager
> cost?@.discussions.microsoft.com> wrote in message
> news:11367BEF-6886-49FF-A5D7-B702AE964688@.microsoft.com...
> right.
> it
>
>
|||You could purchase the developers edition for around $50 -
you'd have all the client tools that way. Other options are
here: http://www.aspfaq.com/show.asp?id=2442
-Sue
On Thu, 11 Nov 2004 13:10:01 -0800, "LLittle"
<LLittle@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Thanks for responding,
>I orginally thought they would allow me to access through ts also but said I
>would just be allowed to access that particular database which makes sense if
>there are other people's databases on the server they wouldn't want to give
>me access to the whole server.
>I think I am just going to be given a domain.server name and once hooked up
>only that database would appear because that is all I would have rights to.
>I also don't think they are going to give me access to their copy of
>Enterprise manager from there disk I will just be expected to provide it.
>I found one company that offers an product to access from www.teratrax.com
>but I am used to sql server tools and need the dts packages.
>
>
>"AnthonyThomas" wrote:
|||Sue Hoegemeier wrote:
> You could purchase the developers edition for around $50 -
> you'd have all the client tools that way. Other options are
> here: http://www.aspfaq.com/show.asp?id=2442
> -Sue
That wouldn't work legally.
You can use the SQL Server Web Administrator from MS without any
licensing requirements. I don't know that the ASP license for SQL Server
(what the ISP probably has) allows distribution of client tools. The web
data administrator should allow you to administer SQL Server from your
web browser.
http://www.microsoft.com/downloads/d...displaylang=en
David Gugick
Imceda Software
www.imceda.com
|||Depends on how it's licensed. I never heard of the ASP
license for SQL Server though - don't think there is such a
thing. See the link referenced for options - there are some
licensing explanations for the different options.
-Sue
On Thu, 11 Nov 2004 23:13:01 -0500, "David Gugick"
<davidg-nospam@.imceda.com> wrote:
>Sue Hoegemeier wrote:
>That wouldn't work legally.
>You can use the SQL Server Web Administrator from MS without any
>licensing requirements. I don't know that the ASP license for SQL Server
>(what the ISP probably has) allows distribution of client tools. The web
>data administrator should allow you to administer SQL Server from your
>web browser.
>http://www.microsoft.com/downloads/d...displaylang=en
|||See the end of Brian's article for a note about using SQL Server in an
ASP environment:
http://www.developer.com/tech/article.php/630451
From Microsoft:
http://www.microsoft.com/serviceprov.../licensing.asp
David Gugick
Imceda Software
www.imceda.com
enterprise manager cost?
I need to put enterprise mgr on a desktop at my office to administer a sql
server database that I am renting from a hosting service. The server is
shared at the hosting site and I pay only the monthly 39.00 for that right.
Do I have to buy enterprise manager to be legal. If so any idea how much it
would cost for a single processor, one user desktop computer?
thanks, leonThis one is tricky. For properly licensed copies of SQL Server
installations, which I am assuming your host has done on your behalf, there
is no additional charge for the installation nor use of the client-side
tools. However, it is unlikely that you will have port 1433 outbound open
on your company's firewall nor will the host likely have port 1433 inbound
opened to the SQL Server installation.
Normally, the host will provide terminal server sessions, in which case you
would use the remote installation of the client tools.
Sincerely,
Anthony Thomas
"enterprise manager cost?" <enterprise manager
cost?@.discussions.microsoft.com> wrote in message
news:11367BEF-6886-49FF-A5D7-B702AE964688@.microsoft.com...
> I need to put enterprise mgr on a desktop at my office to administer a sql
> server database that I am renting from a hosting service. The server is
> shared at the hosting site and I pay only the monthly 39.00 for that
right.
> Do I have to buy enterprise manager to be legal. If so any idea how much
it
> would cost for a single processor, one user desktop computer?
> thanks, leon|||Thanks for responding,
I orginally thought they would allow me to access through ts also but said I
would just be allowed to access that particular database which makes sense i
f
there are other people's databases on the server they wouldn't want to give
me access to the whole server.
I think I am just going to be given a domain.server name and once hooked up
only that database would appear because that is all I would have rights to.
I also don't think they are going to give me access to their copy of
Enterprise manager from there disk I will just be expected to provide it.
I found one company that offers an product to access from www.teratrax.com
but I am used to sql server tools and need the dts packages.
"AnthonyThomas" wrote:
> This one is tricky. For properly licensed copies of SQL Server
> installations, which I am assuming your host has done on your behalf, ther
e
> is no additional charge for the installation nor use of the client-side
> tools. However, it is unlikely that you will have port 1433 outbound open
> on your company's firewall nor will the host likely have port 1433 inbound
> opened to the SQL Server installation.
> Normally, the host will provide terminal server sessions, in which case yo
u
> would use the remote installation of the client tools.
> Sincerely,
>
> Anthony Thomas
>
> --
> "enterprise manager cost?" <enterprise manager
> cost?@.discussions.microsoft.com> wrote in message
> news:11367BEF-6886-49FF-A5D7-B702AE964688@.microsoft.com...
> right.
> it
>
>|||You could purchase the developers edition for around $50 -
you'd have all the client tools that way. Other options are
here: http://www.aspfaq.com/show.asp?id=2442
-Sue
On Thu, 11 Nov 2004 13:10:01 -0800, "LLittle"
<LLittle@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Thanks for responding,
>I orginally thought they would allow me to access through ts also but said
I
>would just be allowed to access that particular database which makes sense
if
>there are other people's databases on the server they wouldn't want to give
>me access to the whole server.
>I think I am just going to be given a domain.server name and once hooked up
>only that database would appear because that is all I would have rights to.
>I also don't think they are going to give me access to their copy of
>Enterprise manager from there disk I will just be expected to provide it.
>I found one company that offers an product to access from www.teratrax.com
>but I am used to sql server tools and need the dts packages.
>
>
>"AnthonyThomas" wrote:
>|||Sue Hoegemeier wrote:
> You could purchase the developers edition for around $50 -
> you'd have all the client tools that way. Other options are
> here: http://www.aspfaq.com/show.asp?id=2442
> -Sue
That wouldn't work legally.
You can use the SQL Server Web Administrator from MS without any
licensing requirements. I don't know that the ASP license for SQL Server
(what the ISP probably has) allows distribution of client tools. The web
data administrator should allow you to administer SQL Server from your
web browser.
http://www.microsoft.com/downloads/...&displaylang=en
David Gugick
Imceda Software
www.imceda.com|||Depends on how it's licensed. I never heard of the ASP
license for SQL Server though - don't think there is such a
thing. See the link referenced for options - there are some
licensing explanations for the different options.
-Sue
On Thu, 11 Nov 2004 23:13:01 -0500, "David Gugick"
<davidg-nospam@.imceda.com> wrote:
>Sue Hoegemeier wrote:
>That wouldn't work legally.
>You can use the SQL Server Web Administrator from MS without any
>licensing requirements. I don't know that the ASP license for SQL Server
>(what the ISP probably has) allows distribution of client tools. The web
>data administrator should allow you to administer SQL Server from your
>web browser.
>http://www.microsoft.com/downloads/...&displaylang=en|||See the end of Brian's article for a note about using SQL Server in an
ASP environment:
http://www.developer.com/tech/article.php/630451
From Microsoft:
http://www.microsoft.com/servicepro...g/licensing.asp
David Gugick
Imceda Software
www.imceda.com
server database that I am renting from a hosting service. The server is
shared at the hosting site and I pay only the monthly 39.00 for that right.
Do I have to buy enterprise manager to be legal. If so any idea how much it
would cost for a single processor, one user desktop computer?
thanks, leonThis one is tricky. For properly licensed copies of SQL Server
installations, which I am assuming your host has done on your behalf, there
is no additional charge for the installation nor use of the client-side
tools. However, it is unlikely that you will have port 1433 outbound open
on your company's firewall nor will the host likely have port 1433 inbound
opened to the SQL Server installation.
Normally, the host will provide terminal server sessions, in which case you
would use the remote installation of the client tools.
Sincerely,
Anthony Thomas
"enterprise manager cost?" <enterprise manager
cost?@.discussions.microsoft.com> wrote in message
news:11367BEF-6886-49FF-A5D7-B702AE964688@.microsoft.com...
> I need to put enterprise mgr on a desktop at my office to administer a sql
> server database that I am renting from a hosting service. The server is
> shared at the hosting site and I pay only the monthly 39.00 for that
right.
> Do I have to buy enterprise manager to be legal. If so any idea how much
it
> would cost for a single processor, one user desktop computer?
> thanks, leon|||Thanks for responding,
I orginally thought they would allow me to access through ts also but said I
would just be allowed to access that particular database which makes sense i
f
there are other people's databases on the server they wouldn't want to give
me access to the whole server.
I think I am just going to be given a domain.server name and once hooked up
only that database would appear because that is all I would have rights to.
I also don't think they are going to give me access to their copy of
Enterprise manager from there disk I will just be expected to provide it.
I found one company that offers an product to access from www.teratrax.com
but I am used to sql server tools and need the dts packages.
"AnthonyThomas" wrote:
> This one is tricky. For properly licensed copies of SQL Server
> installations, which I am assuming your host has done on your behalf, ther
e
> is no additional charge for the installation nor use of the client-side
> tools. However, it is unlikely that you will have port 1433 outbound open
> on your company's firewall nor will the host likely have port 1433 inbound
> opened to the SQL Server installation.
> Normally, the host will provide terminal server sessions, in which case yo
u
> would use the remote installation of the client tools.
> Sincerely,
>
> Anthony Thomas
>
> --
> "enterprise manager cost?" <enterprise manager
> cost?@.discussions.microsoft.com> wrote in message
> news:11367BEF-6886-49FF-A5D7-B702AE964688@.microsoft.com...
> right.
> it
>
>|||You could purchase the developers edition for around $50 -
you'd have all the client tools that way. Other options are
here: http://www.aspfaq.com/show.asp?id=2442
-Sue
On Thu, 11 Nov 2004 13:10:01 -0800, "LLittle"
<LLittle@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Thanks for responding,
>I orginally thought they would allow me to access through ts also but said
I
>would just be allowed to access that particular database which makes sense
if
>there are other people's databases on the server they wouldn't want to give
>me access to the whole server.
>I think I am just going to be given a domain.server name and once hooked up
>only that database would appear because that is all I would have rights to.
>I also don't think they are going to give me access to their copy of
>Enterprise manager from there disk I will just be expected to provide it.
>I found one company that offers an product to access from www.teratrax.com
>but I am used to sql server tools and need the dts packages.
>
>
>"AnthonyThomas" wrote:
>|||Sue Hoegemeier wrote:
> You could purchase the developers edition for around $50 -
> you'd have all the client tools that way. Other options are
> here: http://www.aspfaq.com/show.asp?id=2442
> -Sue
That wouldn't work legally.
You can use the SQL Server Web Administrator from MS without any
licensing requirements. I don't know that the ASP license for SQL Server
(what the ISP probably has) allows distribution of client tools. The web
data administrator should allow you to administer SQL Server from your
web browser.
http://www.microsoft.com/downloads/...&displaylang=en
David Gugick
Imceda Software
www.imceda.com|||Depends on how it's licensed. I never heard of the ASP
license for SQL Server though - don't think there is such a
thing. See the link referenced for options - there are some
licensing explanations for the different options.
-Sue
On Thu, 11 Nov 2004 23:13:01 -0500, "David Gugick"
<davidg-nospam@.imceda.com> wrote:
>Sue Hoegemeier wrote:
>That wouldn't work legally.
>You can use the SQL Server Web Administrator from MS without any
>licensing requirements. I don't know that the ASP license for SQL Server
>(what the ISP probably has) allows distribution of client tools. The web
>data administrator should allow you to administer SQL Server from your
>web browser.
>http://www.microsoft.com/downloads/...&displaylang=en|||See the end of Brian's article for a note about using SQL Server in an
ASP environment:
http://www.developer.com/tech/article.php/630451
From Microsoft:
http://www.microsoft.com/servicepro...g/licensing.asp
David Gugick
Imceda Software
www.imceda.com
Subscribe to:
Posts (Atom)