In addition to Anil's suggestion, You will under utilize hardware resources if SQL Server machine has more than 4 CPUs and 2 GB RAM with Standard Edition.

Have a look at http://www.sqlsecurity.com for some tools.

Found from one of KB.

CREATE PROCEDURE sp_hexadecimal

    @binvalue varbinary(256),

    @hexvalue varchar(256) OUTPUT

AS

DECLARE @charvalue varchar(256)

DECLARE @i int

DECLARE @length int

DECLARE @hexstring char(16)

SELECT @charvalue = '0x'

SELECT @i = 1

SELECT @length = DATALENGTH (@binvalue)

SELECT...

Have a look at system table "sysmessages". Maybe you can do something from there.

In Acccess, create linked table to SQL Server.

No way I am aware of that can guarantee the remote/linked server is up when you perform operation to it.

What do you try to achieve by lower the status of...

TRUNCATE TABLE is functionally identical to DELETE statement with no WHERE clause: both remove all rows in the table. It needs at least db_ddladmin fixed database roles as you already...

No problem, Frank. Any inputs are welcomed. That is how we learn.

It is no necessary.

EMPTYFILE option migrates all data from the specified file to other files in the same filegroup.

Yes or No. In this case, you have to perform some DDL operation to the table user doesn't own. He/She needs at least db_ddladmin fixed database roles.

Have a look at "Set ANSI_PADDING" in BOL.

"Controls the way the column stores values shorter than the defined size of the column, and the way the column stores values that...

First to empty one of your log file by running "dbcc shrinkfile(logfile_logicalname, emptyfile). Once the file is empty, run "alter database remove file logfile_logicalname)

Maximum Amount of Physical Memory Supported by the Editions of SQL Server 2000

This table shows the maximum amount of physical memory, or RAM, that the database engine in each SQL...

DROP TABLE permissions default to the table owner, and are not transferable. However, members of the sysadmin fixed server role or the db_owner and db_dlladmin fixed database roles can drop...

Who is the owner of the table? Why drop and recreate table instead of truncating the table?