GilaMonster (12/17/2010)

---

The x64 processor architecture is sometimes known as AMD64 because AMD...

They do, indeed.

From http://www.virtualbox.org:

VirtualBox is a powerful x86 and AMD64/Intel64 virtualization product for enterprise as well as home use. Not...

Have you tried OPENQUERY?

SELECT *

FROM OPENQUERY(LinkedServerName, 'SELECT * FROM SomeRemoteTable')

If you provide table script and sample data in a more consumable format, I'll be glad to help.

Take a look at the article linked in my signature line.

ALZDBA (12/17/2010)

---

Steve Jones - SSC Editor (12/16/2010)

---

Stefan Krzywicki (12/16/2010)

---

I wonder if he's still doing that now that there's Intellisense. I like aliases, even one letter ones, but they have to...

I don't think it can be done, but I would be greatly interested in others' thoughts.

Some query plans can get out of the cache when the server is under memory pressure.

It could be something to check.

Paul White NZ (12/17/2010)

---

Gianluca Sartori (12/17/2010)

---

Just be sure to turn off "Auto List Members" and "Auto Parameter Info" if you're working on a database with lots of objects or you...

Paul White NZ (12/17/2010)

---

Gianluca Sartori (12/17/2010)

---

Has anyone tried SQLComplete intellisense[/url]? I'm trying it and it doesn't look bad at all. Since I work on 2005 servers it comes very handy....

Chris Morris-439714 (12/17/2010)

---

GSquared (12/16/2010)

---

I like the Red Gate intellisense more than the SSMS default, but I have to admit, they both get in the way as often as they help,...

I'm glad you solved your issue. It couldn't be otherwise with Jeff helping! 😉

However, I still suggest using command objects and parameters when setting up SQL query from the application.

It...

mister.magoo (12/16/2010)

---

WayneS (12/16/2010)

---

What are your preferences for VM machines - VMWare or VirtualPC?

I've been using VMWare for years (and am happy with it), but to install a 64-bit Windows 7...

This should do the trick:

UPDATE a

SET a.passwordHash = 'ca6588e891b19510c8a6d3d8fabd17ec1d54d201db23292250a69a36f3fca452',

a.creationDate = 1271954403664,

...

You're not updating the same table you declared in the UPDATE statement.

Just change the table to update accordingly:

UPDATE dbo.tmptblListPrices

SET dbo.tmptblListPrices.curListPrice_Jan = dbo.tblBrands_ListPrices.curListPrice,

dbo.tmptblListPrices.lngCategoryID ...

It can be done, just don't allow remote connections in SQL Server network configuration.

However, I don't see any reason for this.

Giving Terminal Server access could be much more harmful than...