Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Location
    here
    Posts
    19

    Unanswered: Create Or Replace

    Looking for something analogous to the Create Or Replace option in Oracle. Is there an equivalent command in SQL Server?
    Program, that's what I do.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    ALTER PROC <PROC Name>

    You want to do this because of the GRANTS?

    SQL Server sometimes tends to be finicky....I alway DROP & CREATE, then GRANT
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jul 2003
    Location
    here
    Posts
    19
    Hey man, thanks for the reply. I'm just trying to get use to SQL Server and I'm working on a script to create a db, tables, grants, yadayadayada.

    I guess that no different then any other ANSI stanard DB...

    Drop... DUH! my bad, boy am I rusty...

    Program, that's what I do.

Posting Permissions

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