Re: SQL 2005 Question

I guess that the easiest way to explain it is that Enterprise Mangler
included what amounted to some user/client interfaces (e.g., Query Designer)
that have not been exposed in SSMS.

In my opinion, that makes SSMS a better product.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"bill_atwork" <bill_atwork2000@xxxxxxxxx> wrote in message
news:1159453209.572650.186510@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Yes I noticed that, but if I were looking for one specific record in a
table holding millions of records it is so much easier to just pull a
query for example (Select * from mytable where email =
someSpecificEmaillAddress@xxxxxxxxx) and then update any field needing
to be updated.

Do they (microsoft) actually expect us to hunt through millions of
records?

There must be another way.


Dejan Sarka wrote:
Bill,

When you right-click on a table, the third option in the pop-up menu is
Open
Table. When you open the table, you can edit the data in SSMS.

--
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of
the
sender.
This message does not imply endorsement from Solid Quality Learning, and
it
does not represent the point of view of Solid Quality Learning or any
other
person, company or institution mentioned in this message

"bill_atwork" <bill_atwork2000@xxxxxxxxx> wrote in message
news:1159389393.253901.266410@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Question, I just came from an ms sql 2000 enviroment to the new 2005
sql server management studio. In 2000 enterprise manager, if I wanted
to update some data quickly, I could expand the database tree on the
left side of the app... right click on any table and select "Open as
Query" type in my sql statement and then I could freely edit the
returned results. When I try this in 2005, the nearest I can find by
right clicking a table is "Script table as..." and then choose "Select
to". I am not able to edit the results in this manner. I used to use
this process all day long on 2000 enterprise manager and now I am at a
complete loss!

I know just enough about sql server to get my asp apps to run. Can
someone tell me how best to acheive what I need to do in 2005 and
provide a little step by step?

Thanks in advance.




.

Relevant Pages

  • Re: Maybe the Records Are There After All
    ... Run DBCC UPDATEUSAGE to correct the row count display in Enterprise Mangler. ... Senior Database Administrator ... I support the Professional Association for SQL Server ... > Enterprise Manager and it gave me the sensation that ALL of the data had ...
    (microsoft.public.sqlserver.server)
  • Re: Tools with/for Express
    ... Enterprise Manager does not work with SQL Server 2005. ... Analyzer is pretty dumb and just passes on what you type, ... But Enterprise Manager tries to write it's own code and it doesn't use SQL ... I then attempted to use Query Analyzer. ...
    (microsoft.public.sqlserver.tools)
  • Re: Strange SQL Server Timeout Problem
    ... Windows 2003 Server - Enterprise ... > We're seeing a very strange SQL Server access problem. ... > once Enterprise Manager accesses the database, ...
    (microsoft.public.sqlserver.server)
  • Re: Indexed Views
    ... Note Indexed views can be created in any edition of SQL Server 2000. ... SQL Server 2000 Enterprise Edition, the indexed view will be automatically ... considered by the query optimizer. ... >> clestered index contains all the data at its leaf level, ...
    (microsoft.public.sqlserver.server)
  • RE: Enterprise Manager error after setup
    ... says and rerun the Sql Server setup. ... Sql Server Support, North Carolina ... using the Enterprise Manager snap-in: ... | "The query cannot be executed because some files are either ...
    (microsoft.public.sqlserver.setup)
Loading