So basically you're running this SQL statement over every table in the database. Some of the tables don't contain the column you're referencing, so you want to ignore the "invalid...

Ok, so I gather you get a text file with the T-SQL statments, still got no idea how you're executing the T-SQL.

If you're running a client application, like a VB...

Where are you executing the T-SQL? Query Analyzer, application, etc... ???

What T-SQL are you executing?

What error are you getting?

You might not be able to suppress all error messages because some...

From Books Online, the correct syntax to make the database read-only is,

ALTER DATABASE booka SET READ_ONLY

The command you're trying is setting the filegroup to be read-only.

How does you VB\VBA procedure execute the package? Does it execute it via the object model? eg: pkg.Execute, or using the command shell using DTSRUN?

Easiest thing I can think of...

Like the naming convention, just hate it when you look at the package and can't see the full name because of those annoying dots.

DECLARE @MyVar varchar(30)
SET @MyVar = '000000045654'
SELECT SUBSTRING(@MyVar, PATINDEX('%[^0]%', @MyVar), LEN(@MyVar))

Sorry, mis-read the "...should not..." line.

The Data Driven Query is a task in DTS. Basically you give a source SQL Statement and a set of insert/update/delete statements to run on...

"...you are only saving $900..."

Yes, but Carl, some of us work for companies where $900 is a big thing. I recently specc'd out a couple of new servers and had...

If you can use Linked Servers then this is probably the way to go.

Update t2
Set t2.status = t1.status
From dbo.table2 t2 
Inner Join server1.db1.dbo.table1 t1 
On t1.agentid = t2.agentid

If a...

Keith

Hopefully your exercise has taught you not to go crazy for two weeks.

Searching for 'multiple values in report parameter' right here at SQLServerCentral would have produced a resolution a lot...

If the transaction hasn't been committed in the transaction log, then it is rolled back when the server restarts.

That is precisely why I switched from using MAPI based SQL Agent Mail to xp_smtp_sendmail from http://www.sqldev.net

Once setup, you can bounce the Exchange server as much as you like...

The is no task in DTS that will do this.

I did a Google search and came up with the following

URL="target URL"
 TEMPPATH = "C:\test\"
 OUTPUTFILE = TEMPPATH & Mid(URL,...

Why bother with the additional overhead of MAPI?

There is a perfectly useable free extended stored procedure that utilises SMTP available at http://www.sqldev.net

This was complimented recently with the addition of...