|  |
| Author |
Problem with creating objects
|
Shawn R. Flanary
Guest
Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:
Total Posts: N/A
|
|
 Problem with creating objects
Everytime I create a new table, sp, view or any other object it
automatically gets created as a system object rather than a user object.
What's going on? Anybody know how to stop this?
Thanks!
Report this post to a moderator
|
|
 11-20-02 10:23 PM
|
|
Tibor Karaszi
Guest
Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:
Total Posts: N/A
|
|
|
Re: Problem with creating objects
Shawn,
Someone has been having fun with your SQL Server and configured it in a mode so that the objects
created will become system objects. There's a stored procedure to set/unset this mode, but I
can't remember the name of the proc offhand. You can try searching the archives (see my
signature), or searching the system procedures yourself (read the source code etc). Here's an
SQL statement that might get you started...
select distinct object_name(id) from syscomments where text like '%system%'
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Shawn R. Flanary" <sflanary@certiport.com> wrote in message news:#L0D20NkCHA.716@tkmsftngp11...
> Everytime I create a new table, sp, view or any other object it
> automatically gets created as a system object rather than a user object.
> What's going on? Anybody know how to stop this?
> Thanks!
>
>
Report this post to a moderator
|
|
|
11-21-02 12:23 PM
|
|
Shawn R. Flanary
Guest
Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:
Total Posts: N/A
|
|
|
Re: Problem with creating objects
I found it. The stored proc is 'sp_MS_upd_sysobj_category'. Thanks alot!!
-Shawn Flanary
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@cornerstone.se>
wrote in message news:usDPFaVkCHA.2248@tkmsftngp10...
> Shawn,
>
> Someone has been having fun with your SQL Server and configured it in a
mode so that the objects
> created will become system objects. There's a stored procedure to
set/unset this mode, but I
> can't remember the name of the proc offhand. You can try searching the
archives (see my
> signature), or searching the system procedures yourself (read the source
code etc). Here's an
> SQL statement that might get you started...
>
> select distinct object_name(id) from syscomments where text like
'%system%'
>
>
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
>
>
> "Shawn R. Flanary" <sflanary@certiport.com> wrote in message
news:#L0D20NkCHA.716@tkmsftngp11...
> > Everytime I create a new table, sp, view or any other object it
> > automatically gets created as a system object rather than a user object.
> > What's going on? Anybody know how to stop this?
> > Thanks!
> >
> >
>
>
Report this post to a moderator
|
|
|
11-21-02 06:24 PM
|
|
|
Forum Rules:
Who Can Read The Forum? Any registered user or guest.
Who Can Post New Topics? Any registered user.
Who Can Post Replies? Any registered user.
Changes: Messages can be edited by their author.
Posts: HTML code is OFF. Smilies are ON. vB code is ON. [IMG] code is OFF. |
|
ExamNotes forum archive
|
