" ... But sometimes in the future, it may become full. So need to shrink/truncate it, right?  ... "

As per my previous post, "Unless you're experiencing a large amount of...

First thing, make sure you have a working and current database backup.

Then the best thing I can think of would be to script out all the tables. Make sure "Generate...

The interval of the transaction log backup should be determined by the business users. How much data can they afford to lose? If they can't afford to lose more than...

"... I don't wish to grant this user access to DB1 at all ..."

They'll need access to the database to retrieve data. You don't need to apply any specific permissions...

Why would you use DTS? Wouldn't it be better to run a simple one-off loop in your web-app to perform the same hashing process?

To avoid any wild stabs in the dark you'll need to provide a bit more detail about your issue. eg: definition of tables and their indexes. Query that is being...

First, with my DBA hat well and truly screwed on tight. I wouldn't be running an external application to issue backup commands to my SQL Servers across a network link....

I presume this is still not running

I'd say it'd be a safe bet that killing a process thats shuffling data around in the...

What are you trying to achieve by specifying both /S and /F?

From Books Online,

/F filename

Is the name of a structured storage file containing DTS packages. If server_name is also specified,...

Anatol Romanov, it's the session timeout. Given the number of users accessing the system I wouldn't expect the SQLServerCentral guys to hold onto...

Which ODBC driver are you using to link to the Progress database? If its the standard Merant driver, make sure you select 'READ UNCOMMITTED' as the Isolation level on the...

With the growth in the Business Intelligence area, I have a feeling this will become a defacto best practice. One only needs to look at the MDX syntax, almost everything...

In response to your question,

"... if we have orphaned user then why sql server allows to assign it as the owner of a table ..."

You don't mention how the programmer changed...

"... How do I create a new sproc. R-clicking the stored procedures node or the database node doesn't appear to give me that option ..."

Templates.

Was/Is the auto-update turned on? If so then this could be the reason for the irregular bloating. If you turn it off, shrink the Database/Tran log, you should have more...