CLR programming: best place to define utilities functions

Hallo,

I find the CLR integration very handy and I would like to use it in the proper way but I need some helps because is not easy to find "best practice" programming info.

This is what I have to do: from a "period" coming from the DB I have to compute start/End date and save them in the DB.

The computation involves regular expression and several functions that makes several calculations on date type variable.

I have created my UserDefinedFunction class that contains the TV function to return a row with 2 fields (startdate,enddate).
Now my question is: what is the base place to define my utilities functions that perform the computation?
In the same class or it is better to add a new class?

For example I have created a module that contains all the Regular expressions patterns.

Any help is appreciated!

Thankx

Marina B.

I think that this is no matter of a SSQL Server decision rather than a cidong decision. It is always good to have a namespace schema and separated classes which allow you to reuse your your. I would split the regular expressions in you case out of the datetime classes if you want to use them in other projects as well. If this is an internal regular expression calculation you should use them in the same class (and make them evtl. internal if you don′t want to call them directly from SQL Server).

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Client utilities for MSDE

Hi,

I heard from a guy that the client utilities (Enterprice Manager and Query Analyser) that are on the Sql Server 2000 CD can be fetched separatly from Microsoft and that they can be deployed with MSDE to a potential customer.

Is that correct?

And if it is, where can I obtain those client apps?

TIA

OhlywohlyNope. You can't get the client utilities for free (legally), and deploy it to a customer.

http://msdn.microsoft.com/sql/downloads/tools/default.aspx

That's what you're limited to.|||You absolutely cannot deploy the Client Tools with MSDE to a customer! The whole point of MSDE is that it's an engine and your application should supply the means necessary to manage it.

If the client already owns a version of SQL Server then they may legally use the Client Tools to manage MSDE.

Unfortunately the Client Tools are not available for purchase separately. You might consider a set of 3rd party tools.

Terri
Disclaimer: I am not a lawyer nor a licensing expert

Client tools licensing question

Hello,
If we have a full version of SQL2K and want to install MSDE on about 30
mobile laptops can we install the client utilities from the SQL2K cd onto
each laptop? If not is there any other options? What would be the cost per
laptop to install the client software? Thanks.
Jake
Hi Jake,
No, you can't. We have a utility that's free for personal use and licensing
for things like you describe. Details are at our site. For other options,
look at: www.microsoft.com/sql/msde/partners/default.asp
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Jake" <rondican@.hotmail.com> wrote in message
news:O5In$G%23rEHA.3848@.TK2MSFTNGP14.phx.gbl...
> Hello,
> If we have a full version of SQL2K and want to install MSDE on about 30
> mobile laptops can we install the client utilities from the SQL2K cd onto
> each laptop? If not is there any other options? What would be the cost per
> laptop to install the client software? Thanks.
> Jake
>
|||Greg,
Is there one that would be good for setting up and managing replication.
We are planning on using merge replication.
Jake
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:eKmUUt%23rEHA.2948@.TK2MSFTNGP11.phx.gbl...
> Hi Jake,
> No, you can't. We have a utility that's free for personal use and
> licensing for things like you describe. Details are at our site. For other
> options, look at: www.microsoft.com/sql/msde/partners/default.asp
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "Jake" <rondican@.hotmail.com> wrote in message
> news:O5In$G%23rEHA.3848@.TK2MSFTNGP14.phx.gbl...
>
|||Hi Jake,
That's on the way in our next version but it's not here yet. I've tried many
of the others but haven't come across one yet that does.
Regards,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Jake" <rondican@.hotmail.com> wrote in message
news:OepQcx%23rEHA.868@.TK2MSFTNGP10.phx.gbl...
> Greg,
> Is there one that would be good for setting up and managing
> replication. We are planning on using merge replication.
> Jake
>
> "Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
> news:eKmUUt%23rEHA.2948@.TK2MSFTNGP11.phx.gbl...
>
|||Greg,
Any idea on a release date? Will it work with SQLExpress?
Jake
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:u%234Y7IEsEHA.376@.TK2MSFTNGP14.phx.gbl...
> Hi Jake,
> That's on the way in our next version but it's not here yet. I've tried
> many of the others but haven't come across one yet that does.
> Regards,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "Jake" <rondican@.hotmail.com> wrote in message
> news:OepQcx%23rEHA.868@.TK2MSFTNGP10.phx.gbl...
>
|||Hi Jake,
Still about 6 weeks. Separate product coming for SQL Express. It's a little
more challenging because SQL Agent isn't included.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Jake" <rondican@.hotmail.com> wrote in message
news:ORLaiyFsEHA.2136@.TK2MSFTNGP14.phx.gbl...
> Greg,
> Any idea on a release date? Will it work with SQLExpress?
> Jake
> "Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
> news:u%234Y7IEsEHA.376@.TK2MSFTNGP14.phx.gbl...
>
|||Pop me an email offline with what you need it to do so I can make sure it's
getting covered.
Regards,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Jake" <rondican@.hotmail.com> wrote in message
news:ORLaiyFsEHA.2136@.TK2MSFTNGP14.phx.gbl...
> Greg,
> Any idea on a release date? Will it work with SQLExpress?
> Jake
> "Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
> news:u%234Y7IEsEHA.376@.TK2MSFTNGP14.phx.gbl...
>
|||"Jake" <rondican@.hotmail.com> wrote in message news:O5In$G%
| If we have a full version of SQL2K and want to install MSDE on about 30
| mobile laptops can we install the client utilities from the SQL2K cd onto
| each laptop? If not is there any other options? What would be the cost per
| laptop to install the client software? Thanks.
|
For 30 servers, wouldn't you want to script it anyway? Seems odd to want to
install a GUI for such a task. I don't like using EM to make changes on even 1
production box.
Also, if you are going to use EM, I would want either the same person or 'team'
of dba's doing the configs. What you can do is put the msde box on the LAN and
connect to it from the dba's copy of EM that is probably installed on their
desktop.
Carl Karsten
|||if you go to the MS site and search for SQL 2000 eval version, it states
that the enterprise t tools can be used indefinitely. confirmed with MS.
Use the EVAL version to intstall just the Enterprise Mgr. everything works
properly with MSDE2000 except the scheduled backups.
steve
"Jake" <rondican@.hotmail.com> wrote in message
news:O5In$G%23rEHA.3848@.TK2MSFTNGP14.phx.gbl...
> Hello,
> If we have a full version of SQL2K and want to install MSDE on about
30
> mobile laptops can we install the client utilities from the SQL2K cd onto
> each laptop? If not is there any other options? What would be the cost per
> laptop to install the client software? Thanks.
> Jake
>
|||hi Steve,
"bozo" <bozo@.bozosplace.com> ha scritto nel messaggio
news:10nc2v5ff2iambe@.corp.supernews.com
> if you go to the MS site and search for SQL 2000 eval version, it
> states that the enterprise t tools can be used indefinitely.
> confirmed with MS. Use the EVAL version to intstall just the
> Enterprise Mgr. everything works properly with MSDE2000 except the
> scheduled backups.
I'm really not certain you are allowed to use the Eval tools on production
servers, or, anyway, after the evaluation time is finished...
they do work after the evaluation expires, but I'm confident you are not
allowed at all to use them...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply