ok thank you guys for your reply...no i was just copying and pasting it and i put this post a long time ago and i didn't receive any notifications...

this is weird when i right click on my table and see wrong the collation it is right but when i saw the script it was the wrong collation...

nope still same problem:angry: man this is killing me i have alot of work to do and i want to make sure there no more database creation and copiying before...

no actually i think it solved my problem, the data i am showing is combining 2 tables one is remote and one is local...after adding the union command i got...

again thanks for your help Mr.Gianluca i am going to research it and see if it fits my needs

ok i didn't mention this ..i am a newbie in sql server i never heard of SSIS i am going to research it now ...do u think its going to...

this can be an issue because i am not authorized to do anything with the remote database[:s] yesterday i was thinking about it ... maybe i can a loop in...

its the oposite when the remote table is updated a record or deleted...i want that to be reflected on my table...if a record is deleted..deletion should occur..i thought about it...

ok thanks man really it worked

ok i did it but i got this error

"cannot initialize the data source object of the ole db provider sqlncli for linked server ERP1"

i searched for this error and i...

ok but i would do the querying every time the page loads? and i can make the reloading process automatic say every 2 minutes

ok let me get something first in a linked server i should be presenting the data from the original database so why would if it was updated or not.i don't...

nigelrivett (3/2/2009)

---

Does the table have anything to say when a row was updated? A last updated column, a timestamp, and audit trail?

How many rows are there in the table? How...

1-guys right now i am still developing the web application later on the database will be uploaded to the server

2- ok i will tell what my problem is...there is this...