microsoft.public.sqlserver.server - Need advice on SS2k and UDF

Author

Need advice on SS2k and UDF

TradeHound

2002-11-26, 10:23 am

I currently have Sql Server 7 and Win2k Advanced Server. I am using IIS on
the same machine for web access to SS7.

I need to do a complicated "function" for every row in a Select statement in
a Join. I need to do this same "function" in several stored procedures. I
think the best way to do this is with a User Defined Function. I only have
SS7, so I guess I have to upgrade to SS2k, right?

I got SS7 and Win2k from an MSDN subscription in 1999. If I have to upgrade
to SS2k does anyone have any suggestions about the least expensive way to
obtain SS2k? I am really strapped for cash. Also I am not sure which
version of SS2k to get. Will the developer version work? The version of
SS7 says "Enterprise Edition" on one of my MSDN CDs and there is one that
also has the "Standard Edition". But since it was only about $2,000 dollars
to join MSDN in 1999 then I am thinking that these CDs that I have are
"Developer" editions, but I'm not sure. And I found a new MSDN Universal
subscription for $908, if I get this will it have the proper SS2k (I think
that it would since I have been using MSDN, but I'm not sure since I have
recently seen SS2k Enterprise editions for over $10,000).

Also my Win2k Adv.Server machine is a dual processor server and I have
noticed that Microsoft sometimes charges per processor, but my MSDN SS7
works fine on it.

I also use Visual InterDev 6.0 and Visual C++ 6.0. Will these still work if
I upgrade to SS2k?

I am so confused. Any advice would be greatly appreciated.

Thank you,
TH

Tibor Karaszi

2002-11-29, 2:23 am

I'm not sure I'm with you. The MSDN licenses are for development and testing only, not for
production. Does it matter then which edition you are running?

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver

"TradeHound" <Newsgroups@TradeHound.com> wrote in message
news:27NE9.3045$Ov1.1253196869@newssvr30.news.prodigy.com...
> I currently have Sql Server 7 and Win2k Advanced Server. I am using IIS on
> the same machine for web access to SS7.
>
> I need to do a complicated "function" for every row in a Select statement in
> a Join. I need to do this same "function" in several stored procedures. I
> think the best way to do this is with a User Defined Function. I only have
> SS7, so I guess I have to upgrade to SS2k, right?
>
> I got SS7 and Win2k from an MSDN subscription in 1999. If I have to upgrade
> to SS2k does anyone have any suggestions about the least expensive way to
> obtain SS2k? I am really strapped for cash. Also I am not sure which
> version of SS2k to get. Will the developer version work? The version of
> SS7 says "Enterprise Edition" on one of my MSDN CDs and there is one that
> also has the "Standard Edition". But since it was only about $2,000 dollars
> to join MSDN in 1999 then I am thinking that these CDs that I have are
> "Developer" editions, but I'm not sure. And I found a new MSDN Universal
> subscription for $908, if I get this will it have the proper SS2k (I think
> that it would since I have been using MSDN, but I'm not sure since I have
> recently seen SS2k Enterprise editions for over $10,000).
>
> Also my Win2k Adv.Server machine is a dual processor server and I have
> noticed that Microsoft sometimes charges per processor, but my MSDN SS7
> works fine on it.
>
> I also use Visual InterDev 6.0 and Visual C++ 6.0. Will these still work if
> I upgrade to SS2k?
>
> I am so confused. Any advice would be greatly appreciated.
>
> Thank you,
> TH
>
>

Sponsored Links