The creation of a database, tables, stored procs, etc is EXTREMELY slow. This same script with Sql Server 2000 took about 8-10 minutes is now taking 45-50 minutes with Sql Server 2005.
This is an example: osql -E -S (local) -n -d <DB> -i <StoredProc>.sql
using SQL Server 9.0.1399
Any thoughts are appreciated.
with sql server 2005 you should use sqlcmd instead. You should find that is faster.
No comments:
Post a Comment