Solved

update systables

Posted on 2006-10-20
4
209 Views
Last Modified: 2008-02-01
I know it is not recommened but how do i update the sysdatabases table?

I detached my tempdb and i need to add it back into that table.

I have tried everything.

I am using sql server 2005.

thanks
0
Comment
Question by:DJMoonLight
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 29

Accepted Solution

by:
Nightman earned 250 total points
ID: 17779184
Before you try to update the sysdatabase table directly (REALLY ill advised) let's try work through this in http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_22032679.html 
0
 
LVL 75

Assisted Solution

by:Aneesh Retnakaran
Aneesh Retnakaran earned 250 total points
ID: 17779574
DJMoonLight,
> I detached my tempdb and i need to add it back into that table.
there is no need to reattach the temp db, tempdb will be created automatically with each restart of the sql server service
:)
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Force application to connect using sql native client for mirroring 3 21
Report 8 27
sql server string_split 4 30
Rewriting a simple query 2 36
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how the fundamental information of how to create a table.

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question