Try creating a SP per component

ie

usp_CreateDB

usp_CreateSchema

usp_GenerateData

etc etc

Then within one file exec each of the SPs.

On the timeout issue...

(1) Check indexes exist on the correct columns. There are many blogs out there that have scripts to look at the DMVs and report potential "missing indexes"....

Is your database set to single user mode?

I use this script from Job Web

http://weblogs.sqlteam.com/joew/archive/2007/08/31/60316.aspx

It shows you ALL indexes and the date/time they were updated.

Rgds

JL

Try this proc

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/08/05/passing-an-array-csv-to-a-stored-procedure-with-data-validation-no-loops-no-self-joins-just-replace.aspx

Credit goes to Tony on this one!!!

create PROC csv_extract

@csv varchar(500),

...

Have you checked that the following are in the "PATH" enviroments.

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;

C:\Program Files\Microsoft SQL Server\90\Tools\binn\;

C:\Program Files\Microsoft SQL Server\90\DTS\Binn\;

To check :

- Start | Run

- CMD

- Type PATH

To...

I like to monitor long running queries so that this can be enhancement by you of the dev team (link 1).

As in the previous post you have to track your...

I think that the post below should help.

http://www.sqlservercentral.com/Forums/Topic222383-9-1.aspx

Hope this helps

SELECT

DISTINCT so.name AS [Table Name] ,sch.name AS [Schema Name], si.name AS [Index Name],si.Type_desc AS [Index Type] ,

CASE

WHEN si.index_id = 1 THEN 'clustered' ELSE 'nonclustered' END

+

CASE WHEN...

Flo

One last thing 😉

What is need if I want to group the CurrentTime and Current calls by Department?

i.e.

Sales 2009-01-02 07:47:00.000 23

Sales 2009-01-02 07:48:00.000 21

Sales 2009-01-02 07:49:00.000 2

Acc 2009-01-02 07:47:00.000 2

Acc...

PERFECT.....

Works an absolute treat!!!

JL

Thank you for the quick response.

Is not the list of dates i am having trouble with, it is the Conncurrent/Active calls.

Cheers

JL