The right way to create a system object (Desk, Saved Process, View…)

It’s very easy. You simply want so as to add the article identify as a parameter to “SYS.SP_MS_MARKSYSTEMOBJECT”. Within the following code we’re making a system desk named“TestSysTable”:

IF OBJECT_ID(N’TestSysTable’) IS NULL

start

              CREATE TABLE dbo.TestSysTable

              (

                     C1 int NOT NULL,

                     C2 int NOT NULL,

                     C3 int PRIMARY KEY IDENTITY

              )

EXEC SYS.SP_MS_MARKSYSTEMOBJECT ‘TestSysTable’

Finish

All executed!

Get pleasure from!