Forum Replies Created

Viewing 14 posts - 1 through 14 (of 14 total)

  • RE: copying stored procedure from sqlserver 2005 to sql 2000

    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...

  • RE: table case sensitive

    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...

  • RE: table case sensitive

    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...

  • RE: 2 sql statmetns 1 table

    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...

  • RE: linked server question

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

  • RE: linked server question

    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...

  • RE: linked server question

    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...

  • RE: linked server question

    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...

  • RE: linked server problem

    ok thanks man really it worked

  • RE: linked server problem

    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...

  • RE: linked server

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

  • RE: linked server

    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...

  • RE: linked server

    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...

  • RE: linked server

    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...

Viewing 14 posts - 1 through 14 (of 14 total)