Re: SQL DB

From: William (anonymous_at_discussions.microsoft.com)
Date: 07/05/04 

Date: Mon, 5 Jul 2004 07:14:30 -0700

Hello,

What I want to do is delete all data found in jobs table
because I need to update it by running a script on a log
file.

When i wrote your function it gave me a script error in
the syntax in near '<'. Here's what i re-wrote:

FROM Jobs alter_database < Jobs >
SET single_user WITH ROLLBACK immediate go
DROP DATABASE < Jobs >

I also looked for the easier way which is by from
Enterprise manager .. Expland databases.. Select
database.. Right click
and Delete, but I can't find Expland databases in
Enterprise Manager.

Can someone tell me where it is and tell why I'm not able
to delete everything from Jobs table?

Cheers!

>-----Original Message-----
>Hi,
>
>Are you trying to delete the data from table or remove
the database fully.
>
>Command to remove database. (Can anyone tell me the
function that will
>allow me to delete my current db?)
>
>alter_database <dbname> set single_user with rollback
immediate
>go
>drop database <dbname
>
>or
>from Enterprise manager .. Expland databases.. Select
database.. Right click
>and Delete
>
>
>command to delete data from table (I need to delete all
JobId's from the
>db.)
>
>See
>
>DELETE command in books online.
>
>--
>Thanks
>Hari
>MCDBA
>
>"William" <anonymous@discussions.microsoft.com> wrote in
message
>news:267dd01c46292$c42c95a0$a501280a@phx.gbl...
>> G'Day folks,
>>
>> My question is related to deleting an existing db in
sql.
>>
>> The reason why I need to delete the existing db in sql
is
>> to update the db from my log file.
>>
>> Example for the table jobs, I need to delete all
JobId's
>> from the db.
>>
>> Can anyone tell me the function that will allow me to
>> delete my current db?
>>
>> Sincerely your's.
>
>
>.
>

Relevant Pages

  • Re: mysql connection failing as CGI
    ... some new hosting which comes with a MySQL database but I'm struggling ... to get it working with any perl scripts; the hosting support are being ... The problem basically is that when the script is run as a CGI script it ... the command line it runs fine. ...
    (comp.lang.perl.misc)
  • RE: problem with DBD::Oracle
    ... Next, if it runs from the command line, then you most likely have a permissions issue with either the Perl script itself, or the Oracle.so library. ... Oracle database that is on a different machine. ... sender of the delivery error by replying to this message, or notify us by ...
    (perl.dbi.users)
  • mysql connection failing as CGI
    ... some new hosting which comes with a MySQL database but I'm struggling ... to get it working with any perl scripts; the hosting support are being ... The problem basically is that when the script is run as a CGI script it ... the command line it runs fine. ...
    (comp.lang.perl.misc)
  • Re: How do I Edit a list of files associated with a product ?
    ... So it succesfully adds the product and the files in a database and the filesystem. ... and you have done something like that or you know a url or script that does that, ... Just build an edit command with the selected file name and ... you better check out the syntax for the exec command since it has additional parameters. ...
    (comp.lang.php)
  • Re: Unload Event Problem
    ... come up with that will allow the database to be used as it is now. ... working so they validly have records with no StopTime yet, ... the jobs relating to the user who is closing down. ... The unload event on the hidden form with null StopTime forcing user to ...
    (microsoft.public.access.forms)