As I suspected the problem is with the user.

When I run the job or run the query from a query window as a domain local user, there is no problem.

When...

Thanks!

I will take a look in the morning.

I also have a feeling it could be related to my user account.

The account is actually from a domain that is linked by...

When I run

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'Rapportage',

@recipients = 'dba@unit4.com',

@query = 'select * from UNIT4_BEHEER.DBO.ClusterActiveNode',

@query_result_header = 0,

@exclude_query_output =...

Yes,

When I run the query alone, it returns data.

The problem is with the @query parameter. When I take it out of the query, the email is sent.

I f I leave...

It worked!

Thanks so much. Really appreciate it 🙂

Cheers!

Can't believe I missed that. How stupid of me.

Thanks!

Cheers,

cor

Same result unfortunately

Msg 8114, Level 16, State 12, Line 64

Error converting data type varchar to nvarchar.

Cheers,

Cor

Thanks for your reply 🙂

I made the following:

DECLARE

@data_file_pathVARCHAR(512)

, @log_file_pathVARCHAR(512)

, @backup_pathVARCHAR(512)

, @backup_extensionVARCHAR(4)

, @mdf_extensionVARCHAR(4)

, @ldf_extensionVARCHAR(4)

, @cnv_extensionVARCHAR(4)

, @backup_nameNVARCHAR(8)

, @database_nameVARCHAR(32)

, @restore_nameVARCHAR(32)

, @logical_data_nameVARCHAR(64)

, @logical_data_1_nameVARCHAR(64)

, @logical_log_nameVARCHAR(64)

, @data_file_full_pathNVARCHAR(255)

, @log_file_full_pathNVARCHAR(255)

, @full_backup_pathVARCHAR(MAX) ...

Schema definition:

USE [Unit4_Beheer]

GO

/****** Object: Table [dbo].[DATABASES_TO_RESTORE] Script Date: 01/24/2012 09:58:48 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[DATABASES_TO_RESTORE](

[rownum] [int] IDENTITY(1,1) NOT NULL,

[backup_name] [varchar](8) NULL,

[cnv] [varchar](1)...

It turned out there was a typo in the

SET @ndf_extension = '.ndf' statement.

everything works now

Thanks to all for your help!

Much appreciated!

Cheers,

Cor

Indeed that does seem to solve the problem except for 1 thing:

Msg 8114, Level 16, State 12, Line 103

Error converting data type varchar to nvarchar.

it seems to be here:

RESTORE DATABASE...

I feel really stupid 🙂

I have been looking at it all day and never saw the insert statement commented out.

Thanks!!

There are some more problems now but I will look at...

Hi,

Same as before I am afraid.

(2 row(s) affected)

The values in the temporary database are shown. Nothing more.

cheers,

Cor

Hi ,

Actually I added serveral ' print step(n) ' to the script to see how far it would go.

It stops short of this part:

-- ** -------------------------------------** --

...

Actually it os somewhere between 300 and 700

Cheers,

Cor