try this

INSERT INTO Company2.dbo.CUSTVEND

SELECT *

,CASE WHEN DIVISION='DIV1' THEN 'DIV2' END

FROM Company1.dbo.CUSTVEND c1

WHERE not exists (SELECT 1 FROM Company2.dbo.CUSTVEND c2

...

What dioes this returns exec usp_Main_TEST @CustID = '123'

Actually your no. of columns return from Sp are nto matching with temp table coluimns count ?

Does the testing script has similar exec plan in both the environment ?

aeri_q (10/26/2013)

---

If i write a trigger for INSERT ON ASSET_CLASS, i dunt know how to put a check on the value which is tried to be inserted , I mean...

No

Yes. Transactional replication only replicate DML operation. see http://technet.microsoft.com/en-us/library/ms151706(v=sql.105).aspx

Worth reading here http://www.dbsophic.com/SQL-Server-Articles/sql-server-logical-reads-what-they-really-tell.html

Francis,

Can ypu try one more thing ?

start the profiler and look for "Sort Warning" option and see if its is coming when you execute the SP ?...

SscLover (10/25/2013)

---

Since no one has replied on the topic, thats new thing to me that increasing the server memory causing bad plan for query,

yes server memory is one of aspect...

Francis Kioko (10/24/2013)

---

It sounds crazy but it is very true. I have tried it in two separate environments i.e. another physical host using SQL Server 2012 and SQL Server 2008...

it will actually it must be ....

i dont think reducing memory can ...

Sanjay Thakur-488205 (10/23/2013)

---

Hi,

Kindly advice the same How to remove/ Delete Transaction Log from SQL Server 2008 R2. as previously we are using SQL Server 2000 Detach database and remove log...

INdexes is definitely a MUST thing here or everywhere .

other thing can below will return the same data too ?

;WITH e_Dupe AS

(

SELECT mcrn

,mpidm

FROM Registration_loaderr

WHERE error_check = '142285'

GROUP BY...

Sqlsavy (10/24/2013)

---

I want to movie Tempdb files to different disk say from A to B while SQL server is down.

When I restart SQL server will it pickup new location (B)...

declare @updatedef table ( id int identity, tablename varchar(30), columnname varchar(50), Status_fl bit)

declare @max-2 int ,@cnt int ,@lstr varchar(200),@tablename varchar(30),@columnname varchar(50)

set nocount on

insert into @updatedef (tablename,columnname,Status_fl...