If you want to shrink the database and you can set up a maintenance plan and schedule it which will create the job. However, you ask about truncate log on...

thanks - at least I now know it's not specific to our systems.

Paul Ibison

Paul.Ibison@btinternet.com

If you're on SQL 2000 I'd use Steve's solution - the table variable - as it's easier and doesn't need any clearing up of a temporary table. Also, the temp...

Could use "select top 1 identitycol from Answers_Eligible" after the update

Paul Ibison

Paul.Ibison@btinternet.com

You could store the results of the ExecuteSQL task in a recordset and loop through the recordset in the package. (Peterson's book explains how to set up a loop in...

For input formats, have a look at SET DATEFORMAT in bol. This changes the interpreted format of text dates when entered into datetime variables/columns. Otherwise I think the language setting...

Interesting - never thought of this as a discrepancy before. However, I suppose there is a distinction. In the case of "Select @column, col1 from Table" the @column is not...

I guess it's because @table will be interpreted as the name of a table itself, rather than a variable holding the name. So if you didn't have a table called...

Don't know if it will be suitable for your case, but there is a simple way of doing this. You could login users of your application using an sp. This...

You could construct the slq text as a string and use: EXEC("sqlstring") or sp_Executesql.

Alternatively you could use a user defined function, which can be used in l=place of a tablename...

It sounds like the whole sql statement needs to be treated as dynamic. In this case, I'd look at using a AcxiveX task to reassign the sql text before the...

Tthere is not an automatic method I know of to do the whole db, and even if there was a system sp, I guess it would still have to iterate...

Have just mimiced this on my work system, and found I needed to check Dynamically Determine Port - hope this helps.

Paul Ibison

Paul.Ibison@btinternet.com

Not 100% sure, but I think the port number won't be 1433. Have a look on the server to see what it's using.

Paul Ibison

Paul.Ibison@btinternet.com

The difference of fillfactor or none depends on the initial create index statement. As your index increased in size (1MB -> 2MB) when you ran DBCC DBREINDEX - no fillfactor,...