I use a different method.

I use one temporary table with an additional field (Session_ID)

This Session ID isgenerated by the application.

Dear Murad,

From you message what I understand is you have a column called 'VBPCRBPXA' It is defined as integer in table1 and as varchar in table2

The error happens when you...

I am including the a part of the code from sp_Compare2Tables

(removed part is actually checking the structure)

I didn't check the code throughly, sa there may be errors.

In case...

Do you have primary keys or unique keys to identify the rows uniquely?

Is the name of the fields same?

I can get a part from my script (Compare 2 Tables) by...

I have tested the sp from another databse too.

It worked fine.

Please Check your T-SQL statement. (Is the database name correct? Is the Schema name DB in the first database?)

...

Please check the syntax and input data of the command.

Hope you have full rights.

Preethi

(G.R.Preethiviraj Kulasingham)

Please check the syntax and input data of the command.

Hope you have full rights.

This is a very good article.

So, How can we prevent our computer from attacks.

1. Deny rights to syslogins.

2. Deny rights to xp_ procedures

3. Make your sa password lengthly (according...

In addition to What Antares686 had said, I would like to suggest some other things which could be used to improve the performance.

Change Varchar (6) and Varchar(3) into Char if...

=NULL is possible if you set the server to ANSI_NULLS OFF. (Through SET Statement, sp_DBOption, or ALTER DATABASE).

The Problem is it is not ANSI92 Compliant. It is better always to...

I saw your article only today.

It is very usefull, and practical.

I learned so many new things in your article.

Thanks, Keep it up.

Preethi

In the way I understood your problem, I believe that your result sould be some thing else.

("..I only want the 6 PENDING rows where..")

Do you say the call_ID should have...

The SysProperties Table has the description.

the name should be 'MS_Description'

Here I have a sample code

select O.Name [Table_name], c.name [Column_Name],

p.Value [description]

From dbo.SysObjects O,

dbo.SysColumns C Left Outer Join

(select id, smallid, name,...