Create a new system table

Is possible create a new table in master database with the
flag 'System'?
Thanks,
Rui OliveiraYes, if you work for Microsoft
For the rest of us NO
You should not mess with system tables and you should not be creating tables on the master database. You will not be able to do either when you move to Yukon so start developing good habits now
Regard
John|||Hi Rui
The following is the limit of what you can do:
create table mysystemtable ( ....)
go
sp_MS_marksystemobject mysystemtable
go
This table will show up as 'system' in Enterprise Manager, but NOT when you
use sp_help in Query Analzyer. You might be able to force it by making
directly updates to sysobjects, but I wouldn't do that on a production
machine.
Can you tell us why you need to do this?
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Rui Oliveira" <anonymous@.discussions.microsoft.com> wrote in message
news:553e01c40046$09f66570$a001280a@.phx.gbl...
> Is possible create a new table in master database with the
> flag 'System'?
> Thanks,
> Rui Oliveira
>|||Tks
>--Original Message--
>Hi Rui
>The following is the limit of what you can do:
>create table mysystemtable ( ....)
>go
>sp_MS_marksystemobject mysystemtable
>go
>This table will show up as 'system' in Enterprise
Manager, but NOT when you
>use sp_help in Query Analzyer. You might be able to force
it by making
>directly updates to sysobjects, but I wouldn't do that on
a production
>machine.
>Can you tell us why you need to do this?
>--
>HTH
>--
>Kalen Delaney
>SQL Server MVP
>www.SolidQualityLearning.com
>
>"Rui Oliveira" <anonymous@.discussions.microsoft.com>
wrote in message
>news:553e01c40046$09f66570$a001280a@.phx.gbl...
>> Is possible create a new table in master database with
the
>> flag 'System'?
>> Thanks,
>> Rui Oliveira
>
>.
>

Create a new system table

Is possible create a new table in master database with the
flag 'System'?
Thanks,
Rui OliveiraYes, if you work for Microsoft.
For the rest of us NO.
You should not mess with system tables and you should not be creating tables
on the master database. You will not be able to do either when you move to
Yukon so start developing good habits now.
Regards
John|||Hi Rui
The following is the limit of what you can do:
create table mysystemtable ( ....)
go
sp_MS_marksystemobject mysystemtable
go
This table will show up as 'system' in Enterprise Manager, but NOT when you
use sp_help in Query Analzyer. You might be able to force it by making
directly updates to sysobjects, but I wouldn't do that on a production
machine.
Can you tell us why you need to do this?
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Rui Oliveira" <anonymous@.discussions.microsoft.com> wrote in message
news:553e01c40046$09f66570$a001280a@.phx.gbl...
> Is possible create a new table in master database with the
> flag 'System'?
> Thanks,
> Rui Oliveira
>|||Tks

>--Original Message--
>Hi Rui
>The following is the limit of what you can do:
>create table mysystemtable ( ....)
>go
>sp_MS_marksystemobject mysystemtable
>go
>This table will show up as 'system' in Enterprise
Manager, but NOT when you
>use sp_help in Query Analzyer. You might be able to force
it by making
>directly updates to sysobjects, but I wouldn't do that on
a production
>machine.
>Can you tell us why you need to do this?
>--
>HTH
>--
>Kalen Delaney
>SQL Server MVP
>www.SolidQualityLearning.com
>
>"Rui Oliveira" <anonymous@.discussions.microsoft.com>
wrote in message
>news:553e01c40046$09f66570$a001280a@.phx.gbl...
the
>
>.
>

Cpu Usage 100% On 6.5 Sql

we have CPU Usage upto almost 100% i increased the tempdb, and master to almost double the size
then we increased the memory to high amount.
does anyone have suggestion pls help since it running too slow, since we did an upgradeUpgrade from what?

To 6.5?

Turn on Profiler to see what's going on.

How's is you r box configured.

Is SQL the only service on the box?|||Sorry Brett, no profiler on MS-SQL 6.5.

I'd be interested to know what the hardware/OS/software configuration is. MS-SQL 6.5 would run on a bare-bones Pentium, and maybe even on a 486. Some of those machines had 512 Kb of RAM or less.

I don't know that we even know enough to ask good questions yet, much less offer suggestions for how to fix the problem(s).

Is an upgrade to hardware/software less than five years old possible?

-PatP|||Sorry for being so incomplete

I am on window 2000 server running 6.5 sql , had upgraded the vendor application that runs on 6.5 this server ( only thing on box)

ram 3 gb and server 1.4 mhz with raid drive

was running well till this upgrade now.

we increased temp db, master , memory (sql configuration)

size of database 20 gb|||When you use the NT Task Manager, is SQL Server actually running the CPU wild, or is it only part of your problem?

There was a known problem prior to sp5 where SQL Server would go mad trying to manage more than 2 Gb of RAM. I assume that you are at sp6, right?

Try to use sp_who to identify long running tasks, then DBCC INPUTBUFFER to determine what SQL statements those tasks are running.

-PatP|||Yes sql is causing the wild ness

and i taught that 6.5 has only uptill spack 5a

http://www.microsoft.com/sql/downloads/servicepacks.asp

My window 2000 server has service pack 4|||You can try to use SQL Trace to catch some of the activity (queries) in the server. SQL Trace is the SQL Profiler ancestor.

What sort of application is this? Can you take parts of it down to narrow your search? And also, has the vendor said anything like "Oh, yeah. I remember this happened to another client with that setup."|||It was not tested on 6.5 but on 2000 ,

Now they are saying|||If SQL-2000 is an option, go there, NOW!