15 March, 2008

no title

A guy (say MrQ) on group microsoft.public.dotnet.framework.aspnet have posted a funny question

MrQ
Hi,
Can I backup & restore my sql server database from aspx page located on a
client machine ?
Thank You.
First answer (say MrA)
Sure you can .

use BACKUP DATABASE sql statement..

Just remember do not connect to the DB you want to back up. Connect to
master DB

MrQ
Thank you for your reply.
How can I implment this?
MrA
I am afraid you cant. If you asking this
MrQ
Sure I know how to backup and restore a db using sql server 2000 or 2005. Im
asking about how can I provide a web form, using asp.net 2.0, to the client
that can let him or her do the same task remotely?
Hmm, he can use sql statement to play with sql server but don't know how to use it in .net

08 March, 2008

Newsgroup in general

I've heard about newsgroup concept when I started studying IT at the university. But I couldn't be well aware of what it is, how to use. And I got into it by chance today, see this quote

On the web there are thousands, probably millions, of discussion forums, dedicated to particular areas of interest. You use your browser to navigate to the "forum" web page of a site that interests you, where you can read what other people have written. You can usually post new messages to the forum after completing a web form to register your name, e-mail address, etc, at the forum.

A newsgroup isn't like that. A newsgroup is a completely different, very much older, type of forum. Newsgroups were invented over a quarter of a century ago, long before the World Wide Web existed. Newsgroups work with special software called "newsreaders" and "news servers" instead of web browsers and web servers.

If you're not really interested in how newsgroups work – you simply want to know how to read and post messages with a minimum of fuss – you'll be pleased to hear that Google provides a web-based interface to newsgroups that makes them look pretty-much like normal web-based discussion forums. It's called Google Groups. But bear in mind that the Google Groups way of doing things is quite cumbersome, and most newsgroup users prefer to use the newsreader software described next.

To connect directly (not via Google) to a newsgroup you'll need newsreader software installed on your PC. Many PCs come with a newsreader already installed - it's Microsoft Outlook Express, the same program that many people use for e-mail. Popular alternative newsreaders include Forte Agent and Mozilla Thunderbird.

The newsreader needs to be configured to connect via the Internet to a suitable news server. There are thousands of news servers round the world and it usually doesn't matter much which one you connect to. Many ISPs provide free news servers. Alternatively many alt.usage.english regulars make use of the inexpensive server provided at News.Individual.NET.

Having configured your newsreader to use an available news server, you can "subscribe" to any number of newsgroups. Subscription is free and no registration process or password is required – all you have to provide is the name(s) of the newsgroup(s) you're interested in. more

Then I google the phrase "news server free" and got a lot of useful results. Anyway, it took a long time to know what it is ^^

I can't hear what they said but it might be funny, right ^^