Do you want to open or save this file ?

When you go to url which is a non-html file ( for example - PDF, WMV , AVI ) ,

and the IE just automatically opens the file in the appropriate application - it's great !

BUT .. sometimes you would like it to ask you what do you want to do with the file ?

For example - maybe you don't want to watch the WMV right now , but rather download it , and watch it later.

Well .. I wanted the IE to ask me about WMV's - but it just automatically opens it with the Media Player .

Why ?

Since once when I opened a wmv file - IE asked me the following :

And I choosed "Open" and removed the "V" from the "Always ask before opening this type of file".

Now the question is how do you get back to this to mark that checkbox ..?

Well .. here you go :

Explorer ( Windows file explorer ... not IE ) ->

Tools->

Folder Options->

File Types ->

->

Advanced ->

Mark the "Confirm Open after download"

I just wonder .. shouldn't it be much simpler ? And why it's not in IE !?!?!

Do you want 100% privecy ?

Come to Israel .. we need English teachers !

ASM Language

Just read in IE blog , that IE8 is now available in additional languages .

One of them is "Assamese" - a languge I've never heard about

( well.. I guess it's not the only one )

Anyway - it's code is "ASM" :)

jmpl %r15+4,%r0

addcc %r3,%r5,%r3

Google.. pro-arab ???

Well... as I were using "Google Trends" and "Google Insights for search",

I noticed an interesting fact..

That's from Google Trends :

And that's from  Insights for search:

Can anyone tell the difference ??

Mutiple Language Bars in remote desktop

This bugged me for a long time..
When you log in to a server via remote destop , the taskbar is messed up with multiple language bars . And every time you log in , you get another one .

Well here is the solution from MS :

http://support.microsoft.com/kb/932039/en-us

( to those of you who transferred to that article on the MS Israel site - you need to choose your location as US at the top of the page , and then this article contains a link to the hotfix .
The Israeli version for some reason does not contain the link to the hotfix )

System.Net.Mail.SmtpClient.Send

Ok.

Thanks to MS for moving it from System.Web.Mail t0 System.Net.Mail (in .NET 2) ,
and improving the API .
And writing the code that replaces CDO.
And giving an option to use embedded resources ( besides attachments)

But WHY !! WHY when I send the mail , there is a delay , or executes only when thread is closed ??

The answer and the solution is here :
http://forums.microsoft.com/msdn/showpost.aspx?postid=164793&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=0

( On the second page there is the answer from "jptros" . Also look at the post from Damienb about solving CPU problem)

Took about an hour to find the reason . Annoying and stupid .

Also following links are usefull resources :
http://www.systemwebmail.com/
http://systemnetmail.com/
System.Net.Mail and embedded images

Script to reset DB.

Having a script to delete contents of all tables in the DB of your application is handy -
to clean the test data from DB .

(I'm talking in this post about Sql Server 2000)

So far I've used a script which contained a bunch of DELETE statements in the right order ( according to the FK's).
( In my case I always leave some tables non-touched - for example : USERS,GROUPS and etc' - just for not entering all this info again every time I clean the DB)

But since the application is under development - new tables are added all the time.
And I became annoyed by the need to update the script with each new table.

So I wanted to write some kind of script that will delete data from all tables in the DB, besides those I specify .

This way the script almost never needs an update.

I did it in the following way :

exec sp_msforeachtable

@command1 = "ALTER TABLE ? NOCHECK CONSTRAINT ALL",

@command2 = "DELETE ?",

@command3 = "ALTER TABLE ? CHECK CONSTRAINT ALL",

@whereand = ' and name not like ''%LUT%'' and name not in(''USER'',''USER_GROUP'',''SECTION_GROUP'')'

Another option is to write code with CURSOR which runs over all the tables you want (taking it from the sysobjects table ) .

But this is simpler , since sp_msforeachtable
does that for you.

I wasn't familiar with sp_msforeachtable untill now.
Here some info on this sp and other useful undocumented Sql Server sp's :

http://www.databasejournal.com/features/mssql/article.php/1490661

http://www.databasejournal.com/features/mssql/article.php/3441031

http://www.mssqlcity.com/Articles/Undoc/SQL2000UndocSP.htm