Can MSS 2005 be clustered using VM images i.e. with out a SAN

We would like to do MSS 2005 cluster failover testing with out Application,
however we do not have a SAN (or shared disk storage). Oracle provide the
ablity to create a 10G cluster using 2 Virtual Machines, so we were wondering
if Micrsoosft provides a a similiar solution for MSS 2005 and if so if there
is any documentation?
The lab manual from the course at www.clusterhelp.com does the whole thing
in Virtual Server.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"mikekimber1" <mikekimber1@.discussions.microsoft.com> wrote in message
news:872804DE-56CD-454C-80E1-AD196E043D29@.microsoft.com...
We would like to do MSS 2005 cluster failover testing with out Application,
however we do not have a SAN (or shared disk storage). Oracle provide the
ablity to create a 10G cluster using 2 Virtual Machines, so we were
wondering
if Micrsoosft provides a a similiar solution for MSS 2005 and if so if there
is any documentation?
|||How about a TechNet webcast?
TechNet Support WebCast: How to cluster Microsoft SQL Server 2005 by using
Microsoft Virtual Server
http://support.microsoft.com/kb/891798/en-us
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"mikekimber1" <mikekimber1@.discussions.microsoft.com> wrote in message
news:872804DE-56CD-454C-80E1-AD196E043D29@.microsoft.com...
> We would like to do MSS 2005 cluster failover testing with out
> Application,
> however we do not have a SAN (or shared disk storage). Oracle provide the
> ablity to create a 10G cluster using 2 Virtual Machines, so we were
> wondering
> if Micrsoosft provides a a similiar solution for MSS 2005 and if so if
> there
> is any documentation?
>
|||Geoff, Tom,
Thanjs for this. We will give it a ago.
Regards Mike Kimber
"Geoff N. Hiten" wrote:

> How about a TechNet webcast?
> TechNet Support WebCast: How to cluster Microsoft SQL Server 2005 by using
> Microsoft Virtual Server
> http://support.microsoft.com/kb/891798/en-us
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "mikekimber1" <mikekimber1@.discussions.microsoft.com> wrote in message
> news:872804DE-56CD-454C-80E1-AD196E043D29@.microsoft.com...
>

can i make one query out of these two?

i have two views. the first finds related images for products, but only if the image is the primary image. here it is:

CREATE VIEW images AS
SELECT
p.product_id,
pI.productImage_title as productImage_title
FROM
dbo.products p INNER JOIN
dbo.productImages pI ON p.product_id = pI.product_id
WHERE pI.productImage_primary = 1

the second view gets all the products, and uses the first view to find an image, if there is one:

SELECT
p.product_id as product_id,
p.product_partNumber as part_number,
p.product_name as product_name,
i.productImage_title as small_image,
FROM
dbo.products p LEFT OUTER JOIN
dbo.images i ON p.product_id = i.product_id

i would like to be able to do this with just one view. i'm not sure how to do it though while still limiting the images to only primary ones.

thanks for any help :)If this in Oracle, you could use inline views as follows :

SELECT
p.product_id as product_id,
p.product_partNumber as part_number,
p.product_name as product_name,
i.productImage_title as small_image,
FROM
dbo.products p,
(SELECT p.product_id,
pI.productImage_title as productImage_title
FROM dbo.products p INNER JOIN
dbo.productImages pI ON p.product_id = pI.product_id
WHERE pI.productImage_primary = 1) i
WHERE p.product_id = i.product_id(+)

Originally posted by kfenstad
i have two views. the first finds related images for products, but only if the image is the primary image. here it is:

CREATE VIEW images AS
SELECT
p.product_id,
pI.productImage_title as productImage_title
FROM
dbo.products p INNER JOIN
dbo.productImages pI ON p.product_id = pI.product_id
WHERE pI.productImage_primary = 1

the second view gets all the products, and uses the first view to find an image, if there is one:

SELECT
p.product_id as product_id,
p.product_partNumber as part_number,
p.product_name as product_name,
i.productImage_title as small_image,
FROM
dbo.products p LEFT OUTER JOIN
dbo.images i ON p.product_id = i.product_id

i would like to be able to do this with just one view. i'm not sure how to do it though while still limiting the images to only primary ones.

thanks for any help :)|||i am working in SQL server.|||Sorry, I cant help you with exact syntax but SQL Server also supports inline views -- dont know which version. May be, you can look into the documentation.

Originally posted by kfenstad
i am working in SQL server.

Can I keep the border of an image visible all the time?

Here is my problem. I have a series of checkmark images in a table that have
the visibility toggled with an expression. That works fine, however, the
border around the image is not displayed if the image is not. I need to have
a "grid" appearance because the majority of times these images will not be
shown, but I need to to indicate its placement.
Any suggestions would be appreciated.
Thank you,
BobInstead of placing the image directly on a table column, First place a
rectangle in the table column, and then the image in the rectangle, and set
the properties on the rectangle to show its borders, and with your toggle,
since your are only toggling the visiblity of the image, the rectangle should
always be visible.
"Bob" wrote:
> Here is my problem. I have a series of checkmark images in a table that have
> the visibility toggled with an expression. That works fine, however, the
> border around the image is not displayed if the image is not. I need to have
> a "grid" appearance because the majority of times these images will not be
> shown, but I need to to indicate its placement.
> Any suggestions would be appreciated.
> Thank you,
> Bob