Click here to Skip to main content
15,905,071 members
Home / Discussions / Database
   

Database

 
GeneralRe: Migrate SQL to Oracle Pin
Guillermo Rivero12-Nov-03 7:31
Guillermo Rivero12-Nov-03 7:31 
GeneralRe: Migrate SQL to Oracle Pin
Mike Dimmick13-Nov-03 2:54
Mike Dimmick13-Nov-03 2:54 
GeneralIn-Memory Databases Pin
Andrew Shapira10-Nov-03 12:16
Andrew Shapira10-Nov-03 12:16 
GeneralRe: In-Memory Databases Pin
Arjan Einbu10-Nov-03 22:45
Arjan Einbu10-Nov-03 22:45 
GeneralStopping SQL Pin
Megan Forbes10-Nov-03 3:12
Megan Forbes10-Nov-03 3:12 
GeneralRe: Stopping SQL Pin
Jeff Varszegi10-Nov-03 3:36
professionalJeff Varszegi10-Nov-03 3:36 
GeneralRe: Stopping SQL Pin
Megan Forbes10-Nov-03 3:47
Megan Forbes10-Nov-03 3:47 
GeneralRe: Stopping SQL Pin
Jeff Varszegi10-Nov-03 7:21
professionalJeff Varszegi10-Nov-03 7:21 
So you're not trying to stop SQL Server, just the database, right? Is that the same thing as bringing it offline? I found this in Books Online:

ALTER DATABASE database

{ ADD FILE < filespec > [ ,...n ] [ TO FILEGROUP filegroup_name ]

| ADD LOG FILE < filespec > [ ,...n ]

| REMOVE FILE logical_file_name

| ADD FILEGROUP filegroup_name

| REMOVE FILEGROUP filegroup_name

| MODIFY FILE < filespec >

| MODIFY NAME = new_dbname

| MODIFY FILEGROUP filegroup_name {filegroup_property | NAME = new_filegroup_name }

|
SET < optionspec > [ ,...n ] [ WITH < termination > ]

| COLLATE < collation_name >

}



<nobr>< filespec > ::=

( NAME = logical_file_name

    [ , NEWNAME = new_logical_name ]

    [ , FILENAME = 'os_file_name' ]

    [ , SIZE = size ]

    [ , MAXSIZE = { max_size | UNLIMITED } ]

    [ , FILEGROWTH = growth_increment ] )



<nobr>< optionspec > ::=

    < state_option >

    | < cursor_option >

    | < auto_option >

    | < sql_option >

    | < recovery_option >



    < state_option > ::=

        { SINGLE_USER | RESTRICTED_USER | MULTI_USER }

        | { OFFLINE | ONLINE }

        | { READ_ONLY | READ_WRITE }



    < termination > ::=

        ROLLBACK AFTER integer [ SECONDS ]

        | ROLLBACK IMMEDIATE

        | NO_WAIT



    < cursor_option > ::=

        CURSOR_CLOSE_ON_COMMIT { ON | OFF }

        | CURSOR_DEFAULT { LOCAL | GLOBAL }



    < auto_option > ::=

        AUTO_CLOSE { ON | OFF }

        | AUTO_CREATE_STATISTICS { ON | OFF }

        | AUTO_SHRINK { ON | OFF }

        | AUTO_UPDATE_STATISTICS { ON | OFF }



    < sql_option > ::=

        ANSI_NULL_DEFAULT { ON | OFF }

        | ANSI_NULLS { ON | OFF }

        | ANSI_PADDING { ON | OFF }

        | ANSI_WARNINGS { ON | OFF }

        | ARITHABORT { ON | OFF }

        | CONCAT_NULL_YIELDS_NULL { ON | OFF }

        | NUMERIC_ROUNDABORT { ON | OFF }

        | QUOTED_IDENTIFIER { ON | OFF }

        | RECURSIVE_TRIGGERS { ON | OFF }



    < recovery_option > ::=

        RECOVERY { FULL | BULK_LOGGED | SIMPLE }

        | TORN_PAGE_DETECTION { ON | OFF }




HTH!

Jeff Varszegi

GeneralRe: Stopping SQL Pin
Bruce Duncan10-Nov-03 7:05
Bruce Duncan10-Nov-03 7:05 
QuestionHow to set null values in dataset ? Pin
susree9-Nov-03 19:46
susree9-Nov-03 19:46 
AnswerRe: How to set null values in dataset ? Pin
Mike Dimmick11-Nov-03 10:22
Mike Dimmick11-Nov-03 10:22 
GeneralRe: How to set null values in dataset ? Pin
susree11-Nov-03 17:53
susree11-Nov-03 17:53 
GeneralMS Access Database Connection with VB.NET Pin
EdZa8-Nov-03 12:21
EdZa8-Nov-03 12:21 
GeneralRe: MS Access Database Connection with VB.NET Pin
Pauwll8-Nov-03 16:27
Pauwll8-Nov-03 16:27 
GeneralRe: MS Access Database Connection with VB.NET Pin
Mike Dimmick11-Nov-03 10:24
Mike Dimmick11-Nov-03 10:24 
GeneralRe: MS Access Database Connection with VB.NET Pin
Member 59242011-Nov-03 19:20
Member 59242011-Nov-03 19:20 
GeneralConverting from SQL server to MS Access Pin
pankajdaga8-Nov-03 12:05
pankajdaga8-Nov-03 12:05 
QuestionExecuteScalar with COUNT causes Exception? Pin
Pauwll8-Nov-03 1:21
Pauwll8-Nov-03 1:21 
AnswerRe: ExecuteScalar with COUNT causes Exception? Pin
jeff_martin11-Nov-03 11:54
jeff_martin11-Nov-03 11:54 
GeneralRe: ExecuteScalar with COUNT causes Exception? Pin
Pauwll12-Nov-03 6:00
Pauwll12-Nov-03 6:00 
GeneralRe: ExecuteScalar with COUNT causes Exception? Pin
jeff_martin12-Nov-03 7:25
jeff_martin12-Nov-03 7:25 
GeneralRe: ExecuteScalar with COUNT causes Exception? Pin
Pauwll12-Nov-03 16:27
Pauwll12-Nov-03 16:27 
GeneralRe: ExecuteScalar with COUNT causes Exception? Pin
jeff_martin13-Nov-03 3:41
jeff_martin13-Nov-03 3:41 
GeneralRe: ExecuteScalar with COUNT causes Exception? Pin
Pauwll13-Nov-03 5:07
Pauwll13-Nov-03 5:07 
GeneralPutting fixed array into DB field Pin
EddieSD647-Nov-03 11:31
sussEddieSD647-Nov-03 11:31 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.