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

Is Phone your primary key, if not is in indexed?

How may records are there in each table.

Where is your WHERE clause?

I passed the Ids of the listbox options as a VARCHAR and had a function to take that delimited list and return it as a table.

I could then join the...

It depends which table or tables have altered transactions.

You could have a table with two tinyint fields or you could have a table with 8060 bytes per record which includes...

http://www.sqlservercentral.com/columnists/sjones/movingmsdb.asp

http://www.sqlservercentral.com/columnists/sjones/moveyourmaster.asp

http://www.sqlservercentral.com/columnists/sjones/atemporarymove.asp

I'm not sure about moving the master to a completely separate box.

I can understand moving MSDB because of all the jobs etc, but I understood that master...

Registry setting HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLSERVER\MSSQLServer\BackupDirectory

I've got a great big list of what all these registry settings do somewhere and I plan to write them up as an article.  It's just one of...

Another migration tool that I have used in the past is Datawatch Monarch.  I'm not sure what it can do these days but at the time I was using it...