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...

The particular routine was in-built into the CMS but here is something similar that we used as the base to a VB solution

Attribute VB_Name = "mEncryption"

I do something similar using a web CMS and a built in DES encryption algorithm.

A consideration is whether or not you need to recover the passwords in a human readable...

The idea of allowing Access to act as the front end to a SQL Server database gives me the horrors.

Firstly, Access causes horrendous locking and contention issues.

Secondly, Access is a...