All checked an stucked by the problem I posted since 1 week 🙁

Yes, members of the domain and physical machines.

The cluster generation fails at the OS Level. We've got 2 servers with Windows Server 2008 R2 Enterprise 64Bit. When I want to create the cluster in failover cluster manager,...

If money ain't a problem...

No...not a performance gain, but an availability gain!

Why not a active\active cluster?

You could execute :

SELECT @@VERSION

It's always cumulative :-D!

This would help you too!

I'll have a try. How about that :

SELECT TOP 10 [Total Reads] = SUM(total_logical_reads) ,[Execution count] = SUM(qs.execution_count) ,DatabaseName = DB_NAME(qt.dbid)

FROM sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as qt GROUP...

Suprotim Agarwal

In order to change the owner of an object in the current database, use the sp_changeobjectowner system stored procedure. The basic syntax is as follows:

SELECT 'EXEC sp_changeobjectowner '''

+...

So if it's a prodution environment it's always better to use a cluster for high availibility. The momentary solution is not clustered, is it?

I mean how many licences? Are these processor licences?

So you mean a documentation?

Found this[/url] for ya from Brad McGehee.

Can you create a clustered index on the table. The tables seems to suffer of fragmentation.

Doens't need much CPU or RAM, but has to be reliable. So, why dont you install it in a second instance on an existing sql server prefrably in a cluster?

Did you choose "detach/attach" or SMO? Couldn't you just schedule the package, or does the error come up during package creation?

Got it working now?