Is the query running fine or has it as result Query batch completed ?

Are there other processes running at night such as db optimalisation ?

Thx Andy

Indeed the result was different, and I have now the one I need.

Nope, sorry.

Strangely enough it didn't show all records. Now it does.

David

Much obliged, it works super !!

I still need to learn a lot.

Thx J

Noeld

Sorry customer is same as client. This is not my real qquery but simple translation. Andy thx, I will giev it shot. Learned again !

Thx

J

Kenneth

What about the auto update stats and auto create stats ?

Thx

J

Yes indeed. I now turned it off.

What is the function of autoclose ?

Many thx

J

Hey thx for yr replies.

It seems that dynamic sql is dangerous 😉

But as we often have to create new databases, we don't want to have a list to do's when...

Guys

In advance thx for yr answers. Question though. It's not always AUBM in that columd. There are other customers too. So how do I go on from there ?

Thx

J

Ok guys

My time to be confused. On that link i only see trial software. How can I get to the real sofwtare ?

Thx

J

Hi

This is the result :

Microsoft SQL Server  2000 - 8.00.760 (Intel X86)   Dec 17 2002 14:22:05   Copyright (c) 1988-2003 Microsoft Corporation  Standard Edition on Windows NT 5.0 (Build 2195: Service...

Runtime version like in Acces Runtime.

Not a 'full program' but enough to run the application.

Kind regards.

thx pacarter

So using Excel templates should help ?

And does this happen even in the middle of the data ?

Kind regards

J

Hi

I need to dts an excel. Depending on where the excelfile is stored, this excel is must be dts'ed within the same database. So eg Folder :Track, file :...

Guy

Thx for the responses. We have some software that can trigger files. It's called automation. Then you can start stored procedures.

We'll try something out 😉