Dear Sir/Madam

SQL Server 2005

I am new to this so please bear with me.

What is the best method that ensures data entry can only be via an application

Also, what are the methods, which would restrict the database, to be updated using other methods such as scripts in query analyzer?

Thanks in advance