As Brian says, the default instance of SQL 2005 will do what you want.  The default instance actually has a name of MSSQLSERVER, but you do not need to specify...

I would avoid doing an in-place upgrade if at all possible.  You end up with a mix of SQL 2000 and SQL 2005 folder names and file locations.  SAC normally...

I have found SAC to be very reluctant to display all the SQL services.  One sure way I have found to upset it is install SQL 2005, uninstall it, then...

Try NigelRivett.net, who has some sample routines on his site.  Also try Googling 'Jobserver class', for more details on how to use it.

Steve is right.

In SQL2000, Simple recovery mode logs virtually the same amount of information as Full recovery mode.  In SQL2005, Simple recovery mode logs virtually the same amount of information as Bulk Logged...

The error message you are getting means you need a Service Principal Name (SPN).  Google SETSPN and SQL to see the syntax, and persuade one of your Infrastructure people to...

You have hit the 2 CD problem.

The SQL 2005 install media are divided into 2 CDs.  CD 1 contains the server components, and CD 2 contains the client components.  For...

It is great being able to help others, and to get help on my problems.  Thanks for the prize!

My view is that if your 'opponents' have produced an Expert's report stating a particular view, then your organisation will need to commission an Expert report also.  Your responsibility should be to...

I am now working about 5 miles from where I was born, both in London, but I live about 80 miles away.  Between then and now I have lived and/or worked in...

The statement CASE WHEN Col001 NOT LIKE 'NULL' will be looking for the character string 'NULL'.  If this is really what you want to do, then it would be more...

You should plan to upgrade your SQL Server release to RTM code.

Any service pack is only supported when applied to RTM code.  Even if you do get SQL 2005 SP2...

The priorities of a good manageer should be: 1) Managing their own staff; 2) Managing their peers and superiors; 3) Managing relationships with customers and vendors; 4) Managing their own...

Is there anyone out there who has replaced the SQL2005 xp_sendmail with a custom SP that calls sp_send_dbmail?  As I only need send capability, I am thinking of doing this...

I'm a Christion, so I have some sympathy with what drnetwork says.  However, to put a logical business-orientated viewpoint (which is the only thing most people will accept), the separation...