I disagree that XMLs are for web stuff only.

I use them fairly often for EDI data transfer & other data transfer requirements.

Anyway, that's beside the point. I just want...

There's nothing "at play".

I just like editing data directly in a multi-table view. It is fast, easy, safe (if you're careful) and convenient.

Usually it is to quickly make changes...

Well, I'm the OP and I still haven't found a suitable answer 18 months later. Surely this a really common question? I find it hard to believe that...

Dave,

IMHO, todays disk controllers whether fast SCSI, SATA or whatever will be able to keep up with whatever demands you care to throw at them.

As for the disks attached to...

FANTASTIC!

I have posted this same query on a few forums & this is the only one to give some real help!  BUT now I've removed those bits from my file,...

Hi,

I thought this might've been the solution!  But alas, changes to the view designer's properties didn't help.

And the link refers to VisualFoxPro, not SSMS.

Sure direct editing may be frowned upon.  Side issue.

Still looking for a solution!

I shouldn't need the IDB=(select min(IDB) from T2)  clause

Like in EM, I should...

And the person who answers Moin's question will likely be able to answer this...

I've upgraded from 2000 to 2005, 2005 on a new server.

I have moved a DTS package from...

Anyone?

This is my biggest problem moving from 2000 to 2005.

I REALLY need to be able to edit data from the results pane in views.  I did it all the time...

Thanks Dick,

Although you say that you could update individually, that's not really what I'm asking.

If I create a view, I need to be able to edit the results, not through...

The view is identical to one I'd do in Enterprise Manager.

Same ownership as 2000 ( I think - I just detached from 2000, copied MDF & LDF to a new...

I might be barking up the wrong tree, but I think thehumantrashcan needs something like

SELECT word FROM dbo.Words WHERE word IN ('abc','fgm','klm','pqr' etc etc)

Not sure what the speed on that...

Karl is correct.  The memory is released by an OS function, not a SQL function.  If another Windows app needs the memory currently used by SQL then it'll get released...

Thanks Wanderer.

I was able to create a simple package and just need to massage it somewhat to make it work.  Super answer!

Doncha love how SSIS is soooo intuitive?   NOT

cheers

Danster