News Stay informed about the latest enterprise technology news and product updates.

Microsoft brings SQL Server up to speed with Vista

Microsoft released a Vista-compatible version of its SQL Server 2005 database this week, rectifying a critical gap in its own Vista-enabled product line, and eliminating virtualization restrictions on the popular database at the same time.

The rules that come with SQL Server 2005 Service Pack 2 remove any limit on the number of instances of SQL Server that can run in virtual machines as long as the server on which they run has a SQL Server license for each CPU on the machine.

Earlier rules would have required a license for each virtual machine.

The new version does not support the Microsoft Data Engine, the database engine under SQL Server 2000. SQL Server is important to Microsoft customers because it’s widely embedded in applications that require a local database, though it is typically not considered robust enough to scale to the levels of Oracle or IBM’s top databases.

The original version of this story appeared on TechTarget sister site

Join the conversation


Send me notifications when other members comment.

Please create a username to comment.

how could I add comments to a new table when creating it?
article did not tell us how to bring up the property display for the table. I suppose it was just assumed that you must already know that...
I was thinking this was going to talk about defining the table in SQL code rather than a designer.  I find the former to be a bit better from my experience, but I understand why some people fall hard on the WYSIWYGs
I had thought this article would be about table definitions via actual SQL, using the pre-parser to verify syntax before running the query.  That's fine, some people enjoy using the WYSIWYG interface of the designer a lot too.
Can you let me know how filegroup placement and character collation have and impact on creation of table.