Thank you John.

Didn`t cross my mind to check that source.

Dan-Ketil

Solved, I forgot to copy the ldf files as well.

I found the error.

I can not use the simplest verison, but need to add @server definition.

Hi.

Sorry for extreme late respons but I forgott all about this because of some other hot issues and then my summer holiday set in.

How do I check that SMTP server...

Hi Mike.

I am not sure I understand this one:

"I personally find SQL Server's definition of the week number useful. As I mentioned before, it matches the physical calendar layout, as well...

Hi

Maybe I should have explained how these two tables are used, not sure if I need to, but just for the fun of it.

sales is a register of all sales...

Hi Ron K

You are right, t1 is larger one, about 50 000 records, while t2 has only 188 records.

I will try to add a where clause.

Thank you

Regards

Dan-Ketil

Hi

Item group template did not have any index.

I will create one, but before I do so, I would like your opinon on the different settings one can use.

I will use...

The server runs with  intel xeon cpu 2.0 GHZ and 1,5 GB RAM. Windows XP, SQL 2000

Stored Procedure:

CREATE PROCEDURE [xFF__Sale]

AS

Hi

Would it help if I provided some of the stored procedure?

Regars

DJ

Hi Remi

Sorry. My mistake, didn`t look at the top to get your correct name.

Regards

DJ

Hi guys

Thank you for all your input.

Old Hand, thank you  your code looks a lot like the one I am interested in. I will...

Thanks for your tip.

Do you know if this will work whwn you have more than one key.

I have two key`s.

Will try your tip and hope that helps to find the...

Hi

Thank you for the help.

I willtru detach attach instead of restore,hope that helps.

I will also set tempdb to shrink a couple of times during night job.

Again, thank you.

Regards,

Dan

case

when ([service date] = 0) then