CREATE TABLE Code (

  CodeID int IDENTITY(1,1)

  , CodeType int

  , Description varchar(255))

ALTER TABLE Code ADD CONSTRAINT PK_Code PRIMARY KEY (CodeID, CodeType)

I would put CodeID as the PRIMARY KEY and...

OK here is a provocative comment.

IT outsourcing is the fault of the existing IT departments.  Failure to communicate and integrate with their businesses has lead to them being viewed as...

My big beef about outsourcing is that there is a huge separation between the people requesting the system and the people delivering the system.

If you work within a company then...

I got quite enthusiastic about the ability to append group procs together, until I realised you can't explicitly drop a particular proc in a group.

Are you querying the SQL2K box from the SQL7 box or vice verse?

You will either have to add the the SQL7 box to the SQL2K box as a linked server...

I prefer to have the different functions in separate stored procedures so that it is immediately obvious to the programmer what the procedure is supposed to do.

usp_GetContacts = SELECT

usp_SetContacts =...

LIMIT is a bit more specialised than the nearest SQL equivalent which is the TOP predicate

SELECT TOP 20 C.Firstname, C.Surname

FROM Customers AS C

ORDER BY C.FirstName

There is also SET ROWCOUNT that...

I would add that in the UK salary rates are still down on what they were 4 years ago.

Outsourcing is more of a risk in the UK.  I put this...

Have you tried stepping through the stored procedure in SQL query analyser?

Right click on the offending procedure within the Object Browser and you will see "Debug" at the bottom of...

How do you mean Steve?

Take it down in 10Mb increments?

I would tend to keep date and time together.  If you can get away with a SMALLDATETIME field then do so.

If you do decide to store date and time separate...

MySQL is a database that is very good at pumping out information at a very fast rate of knots especially for web-site deployment.

I have some concerns with its ability to...

I have the same situation as you with a staging database for CMS publication and a live database for CMS presentation.

I set up transactional push replication.

Firstly, I only want one...

If your production and development DBs are on the same box then simply restore the last production backup over the top of the development DB.

If you want to delete a...

I haven't got my head around the full ADO.NET feature set yet but from what I have seen .NET provides a great deal of freedom to get away with bad...