Solved

update systables

Posted on 2006-10-20
4
210 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

Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

Question has a verified solution.

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

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
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.

635 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