"I'm a novice DBA and I'm trying to create stored procedure to truncate log for all databases (except for system databases) in my sql server."

This is a very bad idea....

The application is saving the values in memory not reading from the database:

Either:

Perform the update thru the application and not directly to the database

or

restart the application service as needed

or

Discuss with...

Please post a simplified DDL and your SQL. For more details, see

http://www.aspfaq.com/etiquette.asp?id=5006

create table mainItems

(MainItemNumber integer not null

,MainDescription varchar(255) not null

, MainColorvarchar(255) not null

, constraint mainItems_P primary key (MainItemNumber...

I created a very simple DTS Package that that inserts the global variable value into a table and it is working without any problems. Some things to check:

1. ...

Do you mean for alerts ? Yes, I have done this when the email server was Sun by having the alert response run a job that executes xp_SMTPmail. See...

Since you are currently in design mode, consider an alternative if you are using SQL Server 2000:

1. Partition the data such that each quarter's data is in a different...

Take at look "Looping, Importing and Archiving" with DTS at http://www.sqldts.com/246.aspx

Are you aware that in addition to "alter database" command and there is also the stored procedure "sp_dboption" which internally has an "alter database" ?

The "sp_dboption" isretained for backward compatability.

You...

Try searching the internet for "Entity Attribute Value". To get started, look at http://en.wikipedia.org/wiki/Entity-Attribute-Value_model

Some alternative:

Add a text column and use this column to store the values. The encoding...

Selects nested inside of selects can be replaced with a nested aggregate and then a left outer join. As the table being aggregated is being read once instead of...

You can move the indicies using the DROP_EXISTING option for create index. The data is moved by moving the clustered index. If the table does not have a clustered...

Are you attempting to get the password for a login ?

If so, then, no, you cannot copy the "password" displayed in Enterprise Manager.

SQL Server passwords are encyrpted before being stored...

I asked this question of a person who is an Oracle DBA and a Unix system adminstrator, and he said, yes it can be done and he has done this.

Here...

Using the Northwind demo database and the Employee table, below is a trigger that will only allow the Photo column to contain a value that begins with 'http'. Change...

Please confirm that the SQL Server Agent service is running under the expected account and then confirm that the SQL Server Agent service account has the the expected SQL Server...