Automatic updates

[Don Grover]

Using MsSqlSrv 2k in an asp environment,.

I need to check a coloum in one table and update another coloum in another
table every three hours.
Can some one point me how to do this in an automated fashion in mssql2k

Don

[Bob Barrows]

Don Grover wrote:

> Using MsSqlSrv 2k in an asp environment,.
>
> I need to check a coloum in one table and update another coloum in
> another table every three hours.
> Can some one point me how to do this in an automated fashion in
> mssql2k
>
> Don

Create a SQL Agent job on your SQL Server to do this. See BOL (or post to a
sqlserver group) for more details.

HTH,
Bob Barrows

[Manohar Kamath [MVP]]

A SQL Job as Bob indicated, or use a Trigger. Triggers occur real-time, so
you don't have to check regularly.

--
Manohar Kamath
Editor, .netBooks
[url]www.dotnetbooks.com[/url]


"Don Grover" <spamfree@assoft.com.au> wrote in message
news:eQvH3wckDHA.2080@TK2MSFTNGP10.phx.gbl...

> Using MsSqlSrv 2k in an asp environment,.
>
> I need to check a coloum in one table and update another coloum in another
> table every three hours.
> Can some one point me how to do this in an automated fashion in mssql2k
>
> Don
>
>

[Don Grover]

Thanks for the heads up, its a bit like spelling if you cant spell it how do
you find it in dictionary.

Don

"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
news:%23eyDNbdkDHA.2592@TK2MSFTNGP10.phx.gbl...

> Don Grover wrote:

> > Using MsSqlSrv 2k in an asp environment,.
> >
> > I need to check a coloum in one table and update another coloum in
> > another table every three hours.
> > Can some one point me how to do this in an automated fashion in
> > mssql2k
> >
> > Don

>
> Create a SQL Agent job on your SQL Server to do this. See BOL (or post to

a

> sqlserver group) for more details.
>
> HTH,
> Bob Barrows
>
>

[Steffen Netz]

Hello,

I want to update the installed site_lib automatically in batch-mode.
Is there a module for this?
I've tried the following :

my $cb = CPANPLUS::Backend->new( );
my @modules = $cb->installed();
foreach $mod (@modules) {
if ( !$mod->is_uptodate() && !$mod->package_is_perl_core()) {
print "INSTALL:\t" , $mod->name(), "\t" , $mod->installed_version() ,"-" , $mod->version() ,"\n";
$rc = $mod->install(verbose=>TRUE) ;
print "INSTALLATION " , $rc ? "OK!\n" : "NOOK !\n";
}

}

But there are problems:
interactivity - i.e. Mail::Mbox::MessageParser asks for the location of bzips,gzip ...
packages - i.e. GD::Graph installs all Submodules with the whole module, therefore I get n times GD::Graph

any ideas?

Thanks,

Steffen Netz

[wderman]

I was wondering if anyone has insight into how automatic updates get applied to
Shockwave (and Flash) players. I have a strange situation where some people
have auto-updated to Shockwave 10.1.3.r19, while others stay at 10.1.3.r18.
Also, it seems that the user needs to be in the local Administrators group in
XP, in order to update to r19, or they get an error message.. this is not good,
as we want to leave most of our people in Power Users.

And actually, what we would prefer to do is turn off auto updates entirely,
for both players, but I have not found a place to configure that. We push out
all software installs and updates to our users using Active Directory, and it
can cause errors if we push out an update to a machine, that has already
installed that update. If there is a registry setting or file that controls
update behavior, I'd like to know about it so I can change it in the package we
push out.