System Tables

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » System Tables

System Tables

Rate Topic

Display Mode

Topic Options

Author

Message

Raghavender

Posted Wednesday, January 02, 2008 7:43 PM

Right there with Babe

Group: General Forum Members
Last Login: Today @ 4:39 AM
Points: 722, Visits: 843

Can we modify System Tables, and can we delete the system tables of MASTER Database ?

Thank you.

Raghavender C

Thanks and Regards!!

Raghavender Chavva

Post #438213

Steve Jones - SSC Editor

Posted Wednesday, January 02, 2008 7:52 PM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 5:09 AM
Points: 31,526, Visits: 13,864

No and No.

The system tables contain information that keeps the server running. Logins, users, databases, etc. are contained there.

Why do you want to mess with the system tables?

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #438217

Raghavender

Posted Friday, January 11, 2008 8:17 AM

Right there with Babe

Group: General Forum Members
Last Login: Today @ 4:39 AM
Points: 722, Visits: 843

Thank you for your reply

Thanks and Regards!!

Raghavender Chavva

Post #441797

Jeff Moden

Posted Friday, January 11, 2008 9:13 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:18 AM
Points: 33,112, Visits: 27,038

Raghavender (1/11/2008)

Thank you for your reply

You didn't answer the question... What is it that you want to do and why do you think you need to modify the system tables to do it? These types of questions are not meant to harass... they're short for "tell us what you want to do (not how, but what) and we may be able to help without you killing a perfectly good server and you costing yourself your job". ;)

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #442081

« Prev Topic | Next Topic »

Permissions