|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > Problem with creating objects
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Problem with creating objects
|
|
| Shawn R. Flanary 2002-11-20, 4:23 pm |
| 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!
| |
| Tibor Karaszi 2002-11-21, 6:23 am |
| 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!
>
>
| |
| Shawn R. Flanary 2002-11-21, 12:24 pm |
| 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!
> >
> >
>
>
|
|
|
|
|