Professional Web Applications Themes

Create a system table - Microsoft SQL / MS SQL Server

How would I create a system table or stored procedure?...

Sponsored Links
  1. #1

    Default Create a system table

    How would I create a system table or stored procedure?

    Sponsored Links
    ECR Guest

  2. #2

    Default Re: Create a system table

    Depends what you are trying to achieve. There is an undoented method for
    marking schema objects as "system" but this is definitely not recommended
    and is of little practical value.

    If you create a stored procedure in Master with the sp_ prefix it can be
    executed from any DB without specifying a three-part name, just like system
    SPs. But note that BOL says "It is strongly recommended that you do not
    create any stored procedures using sp_ as a prefix".

    --
    David Portas
    ------------
    Please reply only to the newsgroup
    --

    "ECR" <mattecr.net> wrote in message
    news:01f901c34650$9a313530$a501280aphx.gbl...
    > How would I create a system table or stored procedure?
    >

    David Portas Guest

Similar Threads

  1. using <mx:states> to create a Login system
    By kamleshgk in forum Macromedia Flex General Discussion
    Replies: 1
    Last Post: May 8th, 04:08 AM
  2. CREATE TABLE problem
    By Andrew in forum PHP Development
    Replies: 3
    Last Post: September 7th, 02:13 PM
  3. Inheriting from System.Web.UI.WebControls.Table
    By Jimmy [Used-Disks] in forum ASP.NET Building Controls
    Replies: 1
    Last Post: August 14th, 06:32 PM
  4. How to create a table with dynamic table name
    By cathy wang in forum Informix
    Replies: 3
    Last Post: July 17th, 12:46 PM
  5. protected it as a system table
    By arnaldobenitez in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 4th, 02:29 PM

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