why am I looking so stupid now.

So easy, thx !!

Breaking my head already for a week about the rest of the game, don' see the easy stuff anymore 🙂

Many thx...

Hi thx for reply

The only difference between your statement and ours is in the dates where you equal to.

We need the info until that date.

it's a stored procedure which is...

Hi

thx for your advise.

be aware, the maintenance plan consists out of backing up the tranaction log, but it will not truncate, because it is in replication.

How to do this...

already found it my self.

thx

Hi

It's X64 and from 4Gb tot 7Gb

No I didn't

Server was off line when added.

Kind regards

El Jefe

Hi

We did add some memory to the server.

Can that be the cause ?

Thx

Hi

We didn't restore any database.

We are working with SQL 2005 SP2

What can we do about it ?

thx in advance

Hi thx for your answer

When I try to create the sp, I got following result :

Msg 2760, Level 16, State 1, Procedure sp_MSforeachtable, Line 27

The specified schema name "sys" either...

sorry

don't know if u can do this in RS, but u can always contact Blair Wright [blairw@dundas.com] @ Dundas.

Hope this helps

i took it out the stored procedure so i could use multi values

the problem was in the parameter values within my rdl.

But it is solved now. It should be "dd"...

Hi

I guess I've created the trigger.

Next problem is that SQL Mail does not work with the 64bit version :angry:

Any clue how to get around this one ?

Thx in advance

El Jefe

Hi Lowell

Thx for your quote.

But this is a Navision SQL database. So I cannot change the structure (mailsent flag). The table job contains projects. Is not the SQL job table...

Hi Prasad

That's already there.

Still get the error and he returns only one value in the error, the first.

Any idea ? Are my quotes in order (since i'm working with stored...

Hi this is my stored procedure :

ALTER PROCEDURE [dbo].[sp_sepia_Financieel_Ouderdomsanalyse]

-- Add the parameters for the stored procedure here

--@rcvarchar(30),

--@Methodvarchar(10)

@MultiParamList varchar(1000)

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

--...