More universal script:

select *

from master.dbo.SYSREMOTE_TABLES (

'linked_server_name',

NULL,

NULL,

NULL,

NULL )

Works not only on SQL Server remote servers but any kind of remote servers, including ODBC connection to files using Jet.OLEDB driver.

UPDATE A

SET ....

FROM TableA A

INNER JOIN TableB B ON B.KeyCol = A.KeyCol

INSERT INTO TableA

(columns list)

SELECT B.Columns list

FROM TableB B

WHERE NOT EXISTS (

select 1 from...

Error with severity level 16 raised within a transaction (trigger is always within transaction) will cause rolling it back.

It must be [Extension]<80, not [Extension]<'80' .

Then you probably don't have columns in your WHERE clause.

Jeff, I believe you're ovecomplicationg the problem.

I would suggest:

1) create simple ReportTable

(

SeqNo smallint NOT NULL PRIMARY KEY,

ReportString varchar(8000) NULL

)

2) Populate this table with lines to be reported, lines must...

AVB, what if somebody will insert or update more than 1 row?

Any error in further rows will happily bypass your check and end up in the table.

And don't tell me...

I support sp_executesql approach.

But the query IMHO is built not in the best way.

I must be like this:

'select count(' + QUOTENAME(@fldname) + ' ) from CONTACT2 '

Never.

Period.

Unless you're an amateur and don't have plans to become a professional.

What would your car mechanic say if you'd...

Who told you that MS SQL Server is a text editor?

Don't trust that person any more. It's not true.

You should chose appropriate task for every job.

To spike with a microscope...

I guess that's a limitation of a relational database.

Data must be consistent.

Returned by what?

boumerlin (5/8/2008)

The one caveat to this approach is that you have to use a global temp table if you're planning on creating a temp table on the fly and inserting...

What are you trying to do?

Concatenate some values to a string?

Then search this forum and/or script section of this site for concatenate function(s), chose the one you like the most.

And...

If to add a simple instruction:

SET ANSI_WARNINGS OFF

select

count(*) as theCount,

count(n) as theOtherCount,

avg(n) as theAverage

from

( select 1.0 as n union all

select 3.0 union...