The Problem for your proposal is that I cannot (at least not yet!) add a additional column to each table for holding this status bit (data live or archived) because...

Thanks for your interest on this topic.

The problem is that we did not think yet of maintaining the databases yet as we delivered the systems with SQL 7 and SQL...

I set the ConnectionTimeout = 0 but still after ca. 60 secs running ActiveX task in DTS package it times out. Doing the deleting task in query analyzer takes ca....

Thanks for your help

I still have three questions:

How do I remove an index on @SelectedColumn

of my dynamic SQL statement?

I do not understand what you mean by "have each month in...

Hi

How can I debug such applications as VBScript and is it possible to do it with Visual Studio 6?

Mipo

Thanks for the information. Still I do not understand how to overcome the problem if I do not yet know how many lines (e. g. PresenceTickets,24,24) there are in the...

Thanks for your input.

Someone has a sample how to pass the parameters (read from the ini file by means of a VBScript) to the SP within the VBSript/DTS?

The string looks...

Thanks for your input.

The problem is that the ini file is not only for my application respectively there are other sections in threre. So I have to jump to my...

I used the rebuildm tool and I succeded to rebuild the master. One known problem is that you have to put your *.mdf files from the orgiginal CD first to...

thanks - it works!

mipo

This is just an example of my sql code. I reduced it down to find the problem how to embed the variable @Keepmonthsindatabase in this dynamic sql statement.

The original idea...

I am getting an error when executing the following:

DECLARE@KeepMonthsInDatabase varchar (25)

DECLARE @ProcessTable varchar (30)

DECLARE @SelectedColumn varchar (30)

SET @ProcessTable = 'Transactions'

SET @KeepMonthsInDatabase = '3'

SET @SelectedColumn = 'transactionDatestamp'

DECLARE @STR nvarchar...

quote:

---

When any literal string is preceded by a N, it tells SQL Server to make it an nchar/nvarchar/ntext (Unicode) string.

For instance:

SET @String...

Thanks for your reply - what is the purpose of the N' in your statement?

Thanks

Mipo

Thanks for the superb workaround.

A last question - how would you pass on a varialbe (containing a table name or more) to this procedure and process it? With other words

the...