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

In the bad old days of Access 97 and earlier there used to be horrendous problems with MS Access causing locking issues in the SQL Server database.

Has this been fixed...

Download to Access

OK now it becomes clear.  I have experienced what you are going through.

Firstly, I had two Access databases, template and live.  Template...

I probably wouldn't try joining a 22million row table to a 40 million row table directly.

I would probably insert a few thousand q12004.batch,q12004.phone records into a temporary table then do...

I sincerely doubt it!

I believe that the MASTER database is specific to the server on which it originates.

I could be wrong, but I don't think I am.

CASE WHEN LEN(CAST((@iRunNr AS VARCHAR(10)))<6

 THEN REPLICATE('0',6-LEN(CAST((@iRunNr AS VARCHAR(10))))+cast((@iRunNr as varchar(10))

 ELSE cast((@iRunNr as varchar(10))

end

In EM from the tools, options menu switch off server state polling or put it to a much larger interval.

My understanding of VPN software is very limited but I gather...