I'm a developer and wanting to confirm the following:
Does anyone here have experience with SQL Server Replication (transactional) on 2000? We are trying to convince the DBAs to allow this in a production environment so that we can concurrently run "tests" -- but the DBAs are telling us that Replication in SQL Server 2000 doesn't work and/or that it has a severe performance impact on the source server.
I tried googling some information on this but haven't found any such information.
Also, do you know if it is true/not true that queries from Stored Procedures or queries called from a Linked Servers will take precedence over other queries (e.g. dynamic queries from a connecting application). I didn't think this was possible and have found no reference to this via my google searches... but the DBA claims this is true for SQL Server 2000, and as a result, causes notable performance slowdown from users of the web app connecting to the database.