No, SQL Server does not know the concept of constraint deferability.

As far as I understand it, this depends on how you delete the data. If you use DELETE, the data is actually physically deleted. If you use, say, TRUNCATE, the...

See if this helps:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

Hm, I've just downloaded ActiveState PERL. Why not give it a try? It's always good to look over the rim of one's coffee cup. 

Can you com up with something general enough that will account for all the possibilities in all parts of the world

Noel, you know that this is almost impossible and my post...

SHA is a hash algorithm, no encryption algorithm

This might be interesting:

http://groups.google.de/groups?hl=de&lr=&frame=right&th=7dee1e40ec9591fb&seekm=%23PKq%23RLFFHA.2832%40TK2MSFTNGP14.phx.gbl#link6

Like athurgar already said, there is really no sense in shrinking the log just because of the shrinking itself. Growing the log file is somewhat expensive and leadds to fragementation...

Forgive my ignorance, but what can PERL do what Windows scripting cannot do?

I don't want to start a discussion what is superior or...

I don't know, if third-party tools can do this. However, I would script my procedures in one file, add this WITH ENCRYPRTION for every proc and run that file back...

Noel,

while your query works on the sample data presented, it fails in two ways when you have someone like the one in bold.

It cuts off the last letter of van...

Not sure if I understand you here, but this works for me without errors

use tempdb

create table #test

(

 c1 int null

 , c2 int null

 , c3 int not null default 1

)

create clustered index...

You are aware that you can find this information here:

http://www.sqlservercentral.com/forums/default.aspx at the bottom of the page?

Maybe these will help (at least something to read )

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_queryrecompilation.asp

http://support.microsoft.com/default.aspx?scid=kb;EN-US;243586

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/statquery.asp

http://www.microsoft.com/sql/techinfo/tips/development/queryopstats.asp

http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx

Last one is for SQL Server 2005

Yes, there is a timeout. Don't know if it is configurable.

Usually when I need more time for an answer I copy the reply to the clipboard, cancel that reply,...

When you store data in a text column, SQL Server will not interpret this data in any way. This is the job of your front-end, in your case Access. So,...