Sounds like I'm late to the party - but why not simply switch it to an identity column right now? You're going to keep getting these kinds of headaches...

Yup - and both you and Jeff caught that. The schema.ini needs to be with the import files.

You're definitely going to need indexing. Recommend state, salesperson with an include for cost

;with firstCte as (

select salesperson,

[state],

...

If you're talking just once - then use the "Import and Export data" wizard from SQL 2000 (DTS wizard). It's fast and clean, and will be importing it in...

The bigger question is - why is it set up this way? The fact that the hosting company has your database server set up "in the open" would be...

break it up into 2 batches. Put the alter in its own batch, and then it should compile and execute.

The GAC being what it is - you won't be able to do much about that. That being said - you theoretically CAN avoid all other C: drive usage...

I wouldn't expect this to return anything, since it looks to me that you'd get an error before you even can get past the SQL parser. You declare one...

george sibbald (3/24/2008)

---

Matt, Pauls question was could he use standard edition in a two node cluster or would he have to use enterprise edition. The answer is yes he can...

Also - as you've probably gathered from the above answers - there are lots of ways to accomplish what you want. IMO one of the WORSE ways to go...

I'd skip trying to start the service until you get some of the other items configured.

My Current shot at what to do:

- click on Report Server Virtual Directory, click...

george sibbald (3/18/2008)

---

you can use standard. Its only limitation (cluster-wise) is it only goes up to two nodes, which is what you have got. No. of instances, active\passive or active\active...

The question is - WHICH database? On what machine? using what kind of software?

SQL Server is not required if you only intend to connect to a shared database...

Keep in mind that users "reserve the right to change their mind" at any...

navpreet.khurmi (3/24/2008)

---

so for what you have explained Unicode can handle more then what non unicode handles. but then why would anyobe use a non unicode as non unicode takes double...