I am not an Analysis Services expert but 42000 as an error seems to be a login failure of some type.

Before engaging Microsoft I would first upgrade your SQL Server software. At present you are executing SQL Server 2005 with Service Pack #2 - the stack dump gives you the...

without asking too many why's and what "move" means I am taking a leap.

since the drive changed maybe it is a simple thing - give he following script a try:

---

---...

Here we go ...

OS & Security patching

- 3rd Saturday of odd numbered months 7:00 pm to 12:00 am - all development and test servers

- 3rd Saturday of even...

Actually bcp is not 'order sensitive' in its parameters.

When you specify -f it is expecting the format_file name immediately afterwards.

Below is an excerpt of the parameters from: http://msdn.microsoft.com/en-us/library/ms162802.aspx

bcp {[[database_name.][schema].]{table_name |...

could you post your actual bcp command and 2-3 lines of the source data file ?

a 1966 Chevy BelAir ... classic, roomy, easy on gas with the 260 cubic inch inline 6 cylinder engine and enough low gear torque to pull a semi cab out...

is not necessarily correct ... unless 'threads' are are construed to mean 'logical CPUs' or schedulers assigned by SQL Server...

yet another way to find out in 2008 R2

---

--- show_logical_and_physical_cpus.sql

---

use master

go

---

select cpu_count / hyperthread_ratio as 'Sockets',

...

Could you post your xp_cmdshell command please ...

Also, do you have the Sybase open client installed on your SQL Server for a linked server ?

Could you post your xp_cmdshell command please ...

Also, do you have the Sybase open client installed on your SQL Server for a linked server ?

This was entertaining - kind of like 'The Crusades' in the middle ages ...

An interesting article Phil - I have seen both sides of the fence throughout my career which is why I choose to be 'pure' Production Support DBA.

That point aside, let...

This is a forum and all comments are welcomed.

However, the forum readers, both new and experienced, need to take things with a grain of salt - meaning research, possibly vet,...

Here is our biggest SQL Server

(we will most probably max it out within the next 12-15 months)

Active/Passive cluster

Windows 2003 R2

SQL 2005 Enterprise SP3 CU8 (moving to SP4 CU2)

64 CPUs

256 GB...