Thanks for the reply Phillip.

Another Gotcha I found was if you develop an SSIS package on a 32 bit machine and deploy on a 64 bit server it fails when running via the GUI...

Morning All,

I am having the exact same problem when trying to re-install 64bit SQL Standard Edition on a 64bit Win 2003 Server. I am only trying to install Database Services,...

I think the Q&A from MSDN should shed some light on the issue:

http://www.microsoft.com/technet/technetmag/issues/2007/05/SQLQA/

Q In addition to hyperthreading and dual-core technology, chip vendors are beginning to release processors with...

I think the safest bet is if I unistall and reinstall SQL Server.

Am I correct in thinking that If I install SQL Server and change the default location for the...

Minaz.

It is a fresh install of SQL Server 2005 and I am moving the system databases onto seperate logical drives.

C: - binary files

D: - data files

E: - log files

Regards

Carl

To be honest this is my first hands-on experience with SQL Server 2005.

I installed SQL Server, installed SP2 and lastly moved the system databases.

Should I install SQL Server, move system...

John,

Thanks for your help. I was getting confused using the -c -m switches. I used them switches for moving the model and msdb databases.

I have been following the instruction...

John,

I have started the SQL Server with the parameters using SQL Configuration Manager and adding -c -m -T3608 into the startup parameter list and when I try and run the...

I've moved the master database but the mssqlsystemresource is still in the default directory.

Thanks Anders.

Steve,

I was particularly interested to read what you had to say about the 4 CPU limit into 2005. I was attempting to find out last week whether or not...

Sorry to sound dumb, but, if I buy SQL 2005 Standard Edition and I have 2 quad-core processors will it use all 8 cores? I guess thats what I...

I haven't actually developed the system yet. But the thinking would be to develop the system using SQL 2000 DTS as I am experienced in DTS and when we...

Thanks for your help.

I have been asked to develop a batch type system in very short notice and haven't had any experience using SQL 2005. The system will heavily...