Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Sql server 2008 r2 list of tables and other objects is incovenient vs Sql server 2000

Posted on 2013-11-21
11
Medium Priority
?
265 Views
Last Modified: 2013-11-26
Recently I upgraded an sql server 2000 database to sql server 2008 r2... But I saw that the list of tables, jobs,sps and others is not in an convenient format as was like in sql server 2000 where we had a list of jobs with more information at a glance... I thought that when we upgrade something then we have more convenient environment to work not the opposite...
0
Comment
Question by:nonlinearly
  • 5
  • 4
  • 2
11 Comments
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 39665476
So what exactly is your question?
0
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 39665479
Not every upgrade is better.

DOS -> Windows = downgrade
Windows 98 -> Windows ME = downgrade
Windows XP -> Vista = downgrade
Windows 7 -> Windows 8 = downgrade

Sometimes you just have to work with what you've got.
0
 

Author Comment

by:nonlinearly
ID: 39665512
The question is obvious and has to do with a confirmation... I am right or is there alternative view?
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
LVL 25

Expert Comment

by:Lee Savidge
ID: 39665534
The question isn't obvious as you've just made a statement saying that you don't like the interface changes.

SQL Interface for SQL 2008 R2
What is wrong with this interface? It shows you a split by database and within each database you can see your stored procedures and functions and then if you expand the tables you can see your triggers and indexes. I find this a very convenient interface for the most part. The only bit I don't particularly like is if I'm trying to find a trigger and I am not sure what table it is on but then I can write a query to list me the triggers.
0
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 39665538
For a list of Jobs you can expand the SQL Server Agent branch. For Maintenance Plans you expand the maintenance branch.
0
 

Author Comment

by:nonlinearly
ID: 39665569
It is obvious that you have not worked with Sql Server 2000...
Thanks anyway...
0
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 39665672
Thank you for your observation. I have been working with SQL since version 6.5 days which was back before SQL 2000 and I've been working with it ever since, so yes, I have worked with SQL 2000 but not for a number of years now, since about 2005 and certainly not since its mainstream support ended back in 2008.

This forum is to ask for help with a problem you're having. You have expressed an opinion because you don't like something and not asked a question. Your query is asking an opinion at best because the answer you strive for is based on a very subjective statement as you find that the updated layout is not convenient for you. This is not a question and therefore has no definitive answer.

I'm sorry you haven't found what you're looking for.
0
 
LVL 27

Expert Comment

by:Zberteoc
ID: 39665865
In order to be able to help we need few clarifications:

1. Can you give an example of what you see and what you expected?

2. Are you looking for something in particular?
0
 

Author Comment

by:nonlinearly
ID: 39668369
Ok... so... Can you make a sorting in jobs in the field of disabled job like in sql server 2000? Or if I want to find a table I can type the firsts letters like in Sql server 2000 but now I have the dbo. in front of the table name and the time I have to type until the first leter of the table is not enough... Or if I want to find at a glance information for all jobs (like the next schedule time) without having to go through each job's properties...
Is there anyone that can not understand the difference? I am surprised!
I have 60 jobs and 3.000 tables so it is obvious that I am suffering with this new viewing format...
Thanks...
0
 
LVL 27

Accepted Solution

by:
Zberteoc earned 1500 total points
ID: 39668621
For jos expand the SQL Server Agent node and then double click on Job Activity Monitor. In the window that opens you will see a list of jobs. You can order that list by any column asc or desc by clicking on the column header.

In the case of the tables you can right click on the Tables node and then set a filter but what you say worked in 2000 doesn't exist anymore.

For a list of tables in any database you can execute:
select * from database_name.INFORMATION_SCHEMA.TABLES order by TABLE_TYPE,TABLE_NAME

Open in new window

This will give you a list of tables on top and views on bottom in alphabetical order.

I understand that it can be frustrating that things change and behave differently but that is life, ultimately, and we all have to adapt. Change is generally good and it is done for a reason, exceptions can exist though, but in the end we will come to use to the new features and understand their benefit.
0
 

Author Closing Comment

by:nonlinearly
ID: 39677203
"...but in the end we will come to use to the new features and understand their benefit."
I do not see the benefit to find quickly a specific table among 3000 tables in this tree view anyway...
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

916 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