Hi David,

That looks shorter and prettier.....

Have fun

Hi JR,

Did a bit of work on this a while ago and have a working example - not the prettiest code in the world but hopefully it will help. Should be enough comments...

Hi Ron,

If you are anticipating 0, 1 or many results from your query and you are trying to trap 0 (which is what I am interpreting here) @@ERROR is not...

Ron, why would you need to trap @@error with your statement?

Why not just handle success or failure with a flag e.g.

Declare a_flag

If Exists (Select * from mytable)

    Begin

    <True...

As I said, no intention of insulting or irritating anyone - it just made me laugh (but I have got a strange sense of humour.....). It gave me a good start to a...

Quote Hector 

every day one learnt a new thigs thanks my friend

one question are you a girl?

Nothing wrong with this at times. I guess you're in very good company here with this habit. - Too many home truths here for my liking.....

If the trigger is only firing once, the problem should really lie in the code / cursor used to perform the Insert / Update / Delete.

Any chance of posting the code...

Hi,

I think a little more information is required. Could you give us an idea of what you are trying to accomplish exactly and why you are using your current approach.

And a little further addition.....

Make sure you CAST / CONVERT to a format and length that is going to fit in with your query. e.g:

SET @SQLString = 'SELECT * FROM...

Orlando,

Syntax should sit something like this:-

DECLARE @Query nvarchar(4000),

 @Total int,

 @PrimaryKey int,

 @TableName varchar(255)

SET @primarykey-2 = 1

SET @TableName = 'ATableName'

SET @Query = N'SET @Total = (SELECT COUNT('+ CAST(@PrimaryKey as NVarchar(4)) +...

Hi Stephen,

Just out of interest - what are you trying to solve with this?

Can you give us some examples of data etc?

Have fun

BOL = Books OnLine - it's the help files for MS Sql Server and can be found in:

Start->Programs->MS Sql Server->Books OnLine

Have fun

Got it - that was a bit of a pig.....

When you create a new linked server using EM, under 'Provider Name' you get to set 'Provider Options'.

All make note,...

Hi Louise,

It will be as easy as you make it.......

If its as simple a crossover as you make it sound, a DTS package would be a simple way forward. 1...