I would like to point out that this was orginally supposed to be a flamewar over being nice about suggesting that someone read the directions before asking questions.

Now this.

We finally get...

From the BOL Clustering Overview:

...Install SQL Server on multiple nodes in a failover cluster. You are limited only by the number of nodes supported by the operating system....

So, you can...

Although this is not a very good approach, it should work.  You could divide by zero.  That will raise an error.

There's got to be a better way, however.

As is customary, it is snowing in Milwaukee on Opening Day.  W00T!

jg

The DTS copy object task will not do what you've asked.

Try this script:

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1642

It was posted to sqlservercentral 2 days ago.

It has some conditions that may prevent it from working...

The optimizer should use the cheapest index without any hints.  It would find that the second index has a lower I/O cost (Because it has less data pages). 

Now, if...

There are a couple reasons that I can think of where you would want a duplicate of a clustered index.

1.  The Nonclustered index will be spread out across fewer data...

You should probably gather the business requirements before you go too much farther on this package.  Once you know what those requirements are, you'll have a better idea of how...

You can put a call to the sproc in an "execute SQL" task and make that task depend on the success of the data pump task.

at the end of the...

The .bas module is Visual Basic.  You have Visual Basic.Net, which is a somewhat different language.  You'll need Visual Basic for the module to run, unless the "upgrade wizard" will...

If you don't specify an IDENTITY column in an insert statement, or if you don't specify the column in a DTS transform, the identity column will "auto fill".   By "Identity...

This should be simple.  But something is choking.  Are there any values in the first column that can't be converted to a 4 byte integer?

Does your input file have the...

Have a look at "indexed views" header , "view indexes" topic in the BOL.  That may either help solve your problem, or at least help explain why you can't pin a...

If I understand the question you are trying to ask, the answer is: "It depends".

I think you'd like to know if it is faster to re-use the same view 10 times...

Was the correct answer chosen by using the RAND() function or by using NEWID()?