You can have more than one instance on the clustered resources however don't try it out for the first time on your production server.

if you have hardware you can setup...

Can you please provide the source and destination table creation scripts and some sample data? Otherwise no one can really help you.

You can also create unattended installation using .iss files

try This.

SELECTo.Name as TableName,

c.Name as ColumnName,

t.name as DataType,

t.length as [DataLength],

c.collation

FROM sysobjects o

JOIN syscolumns c

ON o.id = c.id

JOIN systypes t

ON c.xtype = t.xtype

WHERE o.xtype = 'u'

ORDER By o.name

Thanks I had a look none of the SQL Server Counters are there. I have been googling and it appears that its a fairly common problem on Windows 2008,...

As you havn't posted any sample data or table srtucture this example below might not be what your looking for but might give you some inspiration.

It is a cursor which...

the book does cover everything you need for the exam, the only other real substitute is experience and practice.

I would recommend the testing software from

http://www.selftestsoftware.com.

This helps assess your knowledge...

I would use the...

Emailed you the two test xml files hope fully should give you some ideas.

John here is a SPR I created that might help:

I can send you the xml files if you can pm me an email address.

IF OBJECT_ID ('AxSp_Process_XML_File','P') IS NOT NULL

DROP PROCEDURE...

Technet has a really good whitepaper called:

Failover Clustering for Microsoft SQL Server 2005 and SQL Server 2005 Analysis Services

Writers: Allan Hirt (Avanade, Inc.) and Dave Whitney (Microsoft)

2008 Clustering is...

I started out in application support for a software house that used SQL Server 6.5 as the database platform, this let me learn alot of usefull skills in SQL and...

Hi,

Option two works well. Thanks.

Thanks for the help XML is not my forte but it least gives me a head start. Thank You.

The second suggestion gave the better performance of the two with exactly the results I was looking for.

Thank You