SQL Server Takes too long to execute a script to create DB and Stored Procedures
Posted on 2004-09-13
Hi Experts !
I Was Instaling an ASP.NET Application wich came with the scripts to set up the SQL Server Backend.
The Script called TimeTracker_CreateDB.sql is a simple script to create the DataBase, create Tables, create stored procedures , constraints and that's about it.
This query took more than 1 hour to run on the server. To check if the problem was on the server i tried it also on MSDE (local server) and results were as bad.
What could be the cause for this huge amount of time for a simple script ?
Thanks in advance !