I am creating a large number of stored procedures from vb code which are done dynamically because they need to be amended depending on the server names/IPs of the servers in each installation. The stored procedures copy data between a local server and a linked server.
When I have an empty database my vb code creates the stored procedures at a rate of 6 a second, but if the database has data in it, the rate drops to about 1 stored procedure every 6 seconds. 36 times slower!!!
Has anyone got any ideas why this might be happening and what on earth I can do about it! Sometimes the linked server refers back to the same machine, but other times it is a different sql server entirely.
Thanks in anticipation
Phil
When I have an empty database my vb code creates the stored procedures at a rate of 6 a second, but if the database has data in it, the rate drops to about 1 stored procedure every 6 seconds. 36 times slower!!!
Has anyone got any ideas why this might be happening and what on earth I can do about it! Sometimes the linked server refers back to the same machine, but other times it is a different sql server entirely.
Thanks in anticipation
Phil