Results 1 to 6 of 6

Thread: How to drop SQL Server Database by using VbScript

  1. Jan 17th, 2005, 08:38 PM #1
    Winanjaya
    Winanjaya is offline

    Thread Starter
    Fanatic Member
    Join Date
    Nov 2003
    Posts
    784

    How to drop SQL Server Database by using VbScript

    Dear all,

    How to drop SQL Server Database by using VbScript? .. please advise

    Regards
    Winanjaya
    Reply With Quote Reply With Quote
  2. Jan 18th, 2005, 09:21 AM #2
    aidan
    aidan is offline
    Lively Member
    Join Date
    Sep 2002
    Posts
    103

    Re: How to drop SQL Server Database by using VbScript

    What do you mean by 'dropping' a database?
    Reply With Quote Reply With Quote
  3. Jan 18th, 2005, 10:35 AM #3
    SeanGrebey
    SeanGrebey is offline
    Frenzied Member
    Join Date
    Mar 2004
    Location
    Orlando, FL
    Posts
    1,618

    Re: How to drop SQL Server Database by using VbScript

    Look into the SQL-DMO.
    Sean

    Some days when I think about the next 30 years or so of my life I am going to spend writing code, I happily contemplate stepping off a curb in front of a fast moving bus.
    Reply With Quote Reply With Quote
  4. Jan 18th, 2005, 10:35 AM #4
    Danial
    Danial is offline
    Big D Danial's Avatar
    Join Date
    Jul 2000
    Location
    ASP.Net Forum
    Posts
    2,877

    Re: How to drop SQL Server Database by using VbScript

    Quote Originally Posted by aidan
    What do you mean by 'dropping' a database?
    "Dropping" in SQL usually refers to "Delete". I assume he wants to delete Delete an SQL server DataBase.

    Are you sure you want to perform this kind of action using VBScript?Deleting a entire db is a bit dangerous and should be done manuallu.

    But if thats what you want use ADO...

    Here is an article which discusses about Dropping DB.

    http://www.aspfree.com/c/a/MS-SQL-Se...2000-Part-3/2/
    [VBF RSS Feed]

    There is a great war coming. Are you sure you are on the right side? Atleast I have chosen a side.

    If I have been helpful, Please Rate my Post. Thanks.

    This post was powered by :
    Reply With Quote Reply With Quote
  6. Jan 18th, 2005, 10:51 AM #5
    SeanGrebey
    SeanGrebey is offline
    Frenzied Member
    Join Date
    Mar 2004
    Location
    Orlando, FL
    Posts
    1,618

    Re: How to drop SQL Server Database by using VbScript

    Actually, when he said drop, I assume he means he wants to detach it, not delete it.
    Sean

    Some days when I think about the next 30 years or so of my life I am going to spend writing code, I happily contemplate stepping off a curb in front of a fast moving bus.
    Reply With Quote Reply With Quote
  7. Jan 18th, 2005, 11:25 AM #6
    Danial
    Danial is offline
    Big D Danial's Avatar
    Join Date
    Jul 2000
    Location
    ASP.Net Forum
    Posts
    2,877

    Re: How to drop SQL Server Database by using VbScript

    Quote Originally Posted by SeanGrebey
    Actually, when he said drop, I assume he means he wants to detach it, not delete it.
    If its "Detaching" then there is a built in stored proc that comes in master Database, one just need to pass the Database name to detach.

    Though "Drop" usually means Delete, there is a SQL Command called Drop which can be used to Delete Database(IN SQL Server), Table etc.
    [VBF RSS Feed]

    There is a great war coming. Are you sure you are on the right side? Atleast I have chosen a side.

    If I have been helpful, Please Rate my Post. Thanks.

    This post was powered by :
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width