I'm not starting the non active nodig. It gives an error in the eventlog that it cannot find it on the non active machine who is non active.

Yes on the active clusternode. With sufficient rights. Can see and put files in it with SSMS

Thanks man. I was thinking about DDL but i wasn't 100% sure.

I'm going to use this role.

Kind regards,

André

I like this solution. So when there is a security thread you only have to lock one account. And when your testing somethings and the account locks you don't bother...

Thanks it works fine and even more secure that rights a service user doesn't need.

Thats a good idea, i will try a share with security.

Workshops say your server needs 1 GB for server processes. So mostly i do this.

16383 mb (it is in megabytes). 16 gig

2048 mb. 2 gig

16384 - 2048...

Gazareth (1/11/2012)

Hmm, think I'd create...

An other instance can use a different CPU and threads. But your right, it really depends on the hardware.

Thanks for your advice guys.

Kind regards,

André

15 gig, but there are databases from 1 gig too. Average 7 gig. Some are for the restservice some for the Internetapplication.

I've seen it too. But ofcourse you need to...

Thanks for the feedback Cadavre, i had read it somewhere and i wanted to be sure.

And ofcourse the oposite is add much more hardware. But dividing into more instances in...

Go to the directory where the *.rdl files are, you see here the *.rptproj file.

Edit this file with and xml editor (notepad++) or an editor (notepad) and replace the directory...

Thanks guys, i will have a look at both solutions.

Solution i use, Ray Wong published:

create function [StringToArray]

(@str varchar(255),

@delimchar(1),

@token tinyint)

returns varchar (255)

as

begin

declare @start tinyint,

@end tinyint,

@loopcnt tinyint

set@end =0

set@loopcnt=0

set@delim=substring(@delim,1,1)

-- loop naar een specifiek teken

while (@loopcnt <...

But Wayne,

Allthrough the solutions was good for me and i've learned from it.

Goes for Jeff to.

Thank you guys and the goal is that everybody learns, so thats good!

Have a great...