Thank you for this answer Colin.

I had a look at it and it sounds really promising. Thanks again for pointing me in this direction.

Hans

Thank you for the reply Jeff.

Coming from a developer background I can imagine that our developers would want to be able to add users themselves to the databases on the...

Hello there,

I did not want to start a new thread, and came across this one.

I wonder how you arrange the security regarding logins / users. If a developer needs to...

Many congratulations to you all!

Hans

Rudy, Yelena,

Thank you for this information.

Now I am a bit confused; I thought that through the use of AWE I could use 3GB per Standard Edition server?

Hans

Thank you for this valuable feedback. It gave me some clue about what to take into account when using more than one instance.

As we have MSDN I will certainly make...

Thank you for this reply.

Limiting the access to the database is a good option. It raises a question though: how do you go about when a developer needs a new...

Hello Amit,

I want to send a http request to our helpdesk system. In the http string it specifies some parameters (which operator, which department etc). An example:

http://helpdesk/incident?action=new&status=first&field0=request&value0=1 ...

Personally I do not think it's a good idea to write passwords down (also notes get lost...).

At work we are forced to use strong passwords. I can not...

Thanks Michael,

this was indeed the case; the database name was never explicitly mentioned. After correcting this it works.

Also thanks to all others who replied.

Hans

Yes, the table exists. The task that creates the first view uses it also, and it succeeds; it's only after the 'shrink tempdb' task, and then trying to create the...

Ok Phil,

thanks again, I'm definitly going to try the view-solution then.

Admin/Moderator: consider issue closed.

regards,

Hans

Thank you Old Hand,

the VIEW solution will do just fine; any drawbacks known with this solution (performance or otherwise)?

Hans

Thank you for responding Yelena.

I tried this, but I get no records as a result from this. When I check for the owner of a database by checking the Properties...

Forget the last entry, it turns out the data are not clean! My mistake, should have checked this first.

Consider this thread closed please.