"Enric" <vta***@terra.es.(donotspam)> wrote in message
news:633618A6-5345-4F82-B27F-4C362546AA93@microsoft.com...
> Dear all,
>
> I've got the following scenario:
>
> -Got two EM instances running at the same time. The same view on the right
> for both, this is, Tables.
> From EM1 I create a table called T. After that I'm going to EM2 and
> refresh.
> Fine because I am seeing the same object.
>
> -Come back to EM1 and drop T object and create again another T object but
> different, with more fields. When this time I'm going to EM2 and I do drop
> action I've dropped the most new object not the old one when I was waiting
> a
> messagebox or something like that warning me that I am deleting an object
> which is different than I though.
>
> Jezz, how can I do for to change this behaviour?
>
> Any help or comment woud be very appreciated.
>
> --
> Current location: Alicante (ES)

"Stephany Young" wrote:

> The behaviour you describe is exactly os should be expected.
>
> When you drop a table in EM, EM actually executes a T-SQL drop table
> statement.
>
>
>
> "Enric" <vta***@terra.es.(donotspam)> wrote in message
> news:633618A6-5345-4F82-B27F-4C362546AA93@microsoft.com...
> > Dear all,
> >
> > I've got the following scenario:
> >
> > -Got two EM instances running at the same time. The same view on the right
> > for both, this is, Tables.
> > From EM1 I create a table called T. After that I'm going to EM2 and
> > refresh.
> > Fine because I am seeing the same object.
> >
> > -Come back to EM1 and drop T object and create again another T object but
> > different, with more fields. When this time I'm going to EM2 and I do drop
> > action I've dropped the most new object not the old one when I was waiting
> > a
> > messagebox or something like that warning me that I am deleting an object
> > which is different than I though.
> >
> > Jezz, how can I do for to change this behaviour?
> >
> > Any help or comment woud be very appreciated.
> >
> > --
> > Current location: Alicante (ES)
>
>
>

"ML" wrote:

> What would you like to change? Do you want to drop objects without actually
> dropping them?
>
> What are you trying to achieve?
>
> ML
>
> ---
> http://milambda.blogspot.com/

"Enric" <vta***@terra.es.(donotspam)> wrote in message
news:633618A6-5345-4F82-B27F-4C362546AA93@microsoft.com...
> Dear all,
>
> I've got the following scenario:
>
> -Got two EM instances running at the same time. The same view on the right
> for both, this is, Tables.
> From EM1 I create a table called T. After that I'm going to EM2 and
> refresh.
> Fine because I am seeing the same object.
>
> -Come back to EM1 and drop T object and create again another T object but
> different, with more fields. When this time I'm going to EM2 and I do drop
> action I've dropped the most new object not the old one when I was waiting
> a
> messagebox or something like that warning me that I am deleting an object
> which is different than I though.
>
> Jezz, how can I do for to change this behaviour?
>
> Any help or comment woud be very appreciated.
>
> --
> Current location: Alicante (ES)

"Uri Dimant" wrote:

> > Jezz, how can I do for to change this behaviour?
> Stop using EM at all :-))
>
> "Enric" <vta***@terra.es.(donotspam)> wrote in message
> news:633618A6-5345-4F82-B27F-4C362546AA93@microsoft.com...
> > Dear all,
> >
> > I've got the following scenario:
> >
> > -Got two EM instances running at the same time. The same view on the right
> > for both, this is, Tables.
> > From EM1 I create a table called T. After that I'm going to EM2 and
> > refresh.
> > Fine because I am seeing the same object.
> >
> > -Come back to EM1 and drop T object and create again another T object but
> > different, with more fields. When this time I'm going to EM2 and I do drop
> > action I've dropped the most new object not the old one when I was waiting
> > a
> > messagebox or something like that warning me that I am deleting an object
> > which is different than I though.
> >
> > Jezz, how can I do for to change this behaviour?
> >
> > Any help or comment woud be very appreciated.
> >
> > --
> > Current location: Alicante (ES)
>
>
>

> In fact, I hope that in early period of time EM will be living and sharing
> time with Sql Management Studio

"Aaron Bertrand [SQL Server MVP]" wrote:

> Great, trade in your Yugo for a Kia.  Management Studio is certainly a
> better tool than Enterprise Manager in general, but it still shares a lot of
> its flaws and limitations.
>
> Hopefully, at least, you'll learn commands like DROP TABLE and BEGIN TRAN /
> COMMIT TRAN, instead of pointing and clicking yourself to inevitable
> disaster.
>
>
>
>
>
>
>
>
> > In fact, I hope that in early period of time EM will be living and sharing
> > time with Sql Management Studio
>
>
>

"Aaron Bertrand [SQL Server MVP]" wrote:

> > drop and commit? I unfortunately know them
>
> Well, I should have said, learn to use them.  I would much rather write DROP
> TABLE and/or wrap my commands in transactions than blindly trust what some
> GUI is going to do.  Especially when I'm doing some backhanded thing like
> just trying to see what will happen when I bounce quickly between two open
> apps on the same machine...
>
> A
>
>
>