Steve,

I recreated the source table with the same destination datatypes... surprisingly i still get the same error..

Oh good to know... I will check on dat.. and get back...

Steven Willis (2/25/2013)

---

BEGIN

SET @sql = @sql +'INSERT INTO ' + @dbname + '.dbo.Organization (Last_Backup, Backupsize) select '

-- The problem...

joeroshan (2/25/2013)

---

The error clearly says that you cannot insert null to organazationId column. I assume this column to be not null or even primary key.

If it is not null try...

so what you say is, even if it doesn't show the result in SSMS when i try to exec the local variable it works???? Problem is only with displaying it...

Ya I changed it in the very first step... But still getting the same error.. 🙁 🙁 🙁

mrTexasFreedom (1/17/2013)

---

Lowell,

Sadly, this isn't matching any rows:

select id, name

FROM my_user_table

WHERE CHARINDEX(name,CHAR(0),1) > 0

No rows returned. Likewise, the replace operation doesn't touch any of the rows. Ideas?

Thank you very much...

M sorry i mean 11 instead of 12... Sry for the confusion

Ahhh This works.... and you are a fantastic listener.. Thanks a ton

select

h_Address_1,

N as Position,

DioUniqueID,

LogDate,

SUBSTRING(h_Address_1,N,1) As TheChar,

ASCII(SUBSTRING(h_Address_1,N,1)) TheAsciiCode

from LOG_tblAddressBK

CROSS APPLY (SELECT TOP 255 ROW_NUMBER() OVER (ORDER BY (SELECT...

Thankyou Again:)

Lowell,

Thankyou for ur response.. It worked so well.. I just couldnt believe that my problem resolves in no tym... 🙂 Would you also help me Now if i want to...

hey did u find any solution at all... its coz i have same scenario at my work place.. Two servers which are not connected and are remote but shd synchronize...

they are replicating a database... The main database is Michigan.. But they set up pull subscription from newyork... both the databases are remote... and the newyork people dont have access...

Yep...dont forget to practise.. Install trail version of Sql server Mgmt studio and play around..Post any questions with your approach after trying them. dont post any questions without trying..dat helps...