Viewing 15 posts - 121 through 135 (of 2,435 total)
I am not an Analysis Services expert but 42000 as an error seems to be a login failure of some type.
April 2, 2012 at 3:51 pm
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...
April 2, 2012 at 2:51 pm
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:
---
---...
April 2, 2012 at 12:09 pm
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...
March 23, 2012 at 2:59 pm
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...
March 23, 2012 at 10:19 am
could you post your actual bcp command and 2-3 lines of the source data file ?
March 22, 2012 at 9:27 am
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...
March 22, 2012 at 8:10 am
b) SQL Server will have access to the 16 threads.
is not necessarily correct ... unless 'threads' are are construed to mean 'logical CPUs' or schedulers assigned by SQL Server...
March 22, 2012 at 7:58 am
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',
...
March 21, 2012 at 3:51 pm
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 ?
March 20, 2012 at 4:15 pm
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 ?
March 20, 2012 at 4:14 pm
This was entertaining - kind of like 'The Crusades' in the middle ages ...
March 20, 2012 at 3:06 pm
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...
March 20, 2012 at 12:15 pm
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,...
March 9, 2012 at 1:21 pm
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...
March 11, 2011 at 2:24 pm
Viewing 15 posts - 121 through 135 (of 2,435 total)