Home Forums SQL Server 7,2000 T-SQL Cross-server query in a stored procedure RE: Cross-server query in a stored procedure

  • cross-server queries are considered heterogenous queries so you have to set ansi_nulls/warnings "on" with the "GO"s

    then you have to create the procedure in QA (because you cant put three seperate statements in a "create sp window" in Enterprise Mangler. Once it is created you can alter it in Enterprise Mangler.


    Kindest Regards,

    Seth Washeck

    If nothing in this world satisfies me, perhaps it is because I was made for another world.
    C. S. Lewis