Professional Web Applications Themes

BCP and taking off a database - Microsoft SQL / MS SQL Server

Hi Freinds, SQL 2000 I need to take offline <mydatabase> eveytime the computer restarts. I created a batch file with BCP utlity , I need the command for taking off the database from BCP Thanks in advance, Pat...

  1. #1

    Default BCP and taking off a database

    Hi Freinds,
    SQL 2000
    I need to take offline <mydatabase> eveytime the computer restarts. I
    created a batch file with BCP utlity ,
    I need the command for taking off the database from BCP

    Thanks in advance,
    Pat


    Patrick Guest

  2. #2

    Default Re: BCP and taking off a database

    You can use

    exec sp_dboption 'my_database', 'offline', 'true'

    "Patrick" <all-in-1.com> wrote in message
    news:phx.gbl... 


    Ammar Guest

  3. #3

    Default Re: BCP and taking off a database

    Thanks , I have another problem now.
    Cann't take offline while users are working !!!
    How can I disconnect and kill all connections?

    Pat


    "Ammar" <com> wrote in message
    news:phx.gbl... 
    >
    >[/ref]


    Patrick Guest

  4. #4

    Default Re: BCP and taking off a database

    Write a cursor and use command "kill spid#" e.g to skill spid 30, use "kill
    30".
    You can retrieve spids from master..sysprocesses.


    "Patrick" <all-in-1.com> wrote in message
    news:phx.gbl... 
    > >
    > >[/ref]
    >
    >[/ref]


    Ammar Guest

Similar Threads

  1. Taking up 50% CPU
    By newcitynixel in forum Macromedia Contribute General Discussion
    Replies: 0
    Last Post: April 25th, 07:23 PM
  2. rsh taking 7 min to respond???? please help
    By Davor Pavisic in forum Linux / Unix Administration
    Replies: 2
    Last Post: December 1st, 04:12 PM
  3. Replies: 5
    Last Post: July 31st, 03:43 AM
  4. Replies: 1
    Last Post: July 18th, 02:01 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139