thanks for that.

I'd always presumed that a windows group named at a database level needed a corresponding server login, regardless of what other access the user had to the...

Thanks for the replies, folks.

I finally managed to get this to work today using the original certificate, dsource.companyname.com, even though the server name is something different. What helped me was...

anyone any thoughts on this one?

thanks,

Excellent, informative and slightly scarey - all at once!

I meant to post this earlier. This works for me across my servers\instances.

It's just a slightly amended version of the...

This script only works on the default...

Great script.

For the database name problem, all you have to do is use the QUOTENAME function i.e.

SET @sql = 'USE ' + QUOTENAME(@dbname) + 'DBCC SHOWFILESTATS WITH NO_INFOMSGS'

works for me.

You can disable the metadata, which means the user won't see any objects on the server at all -

REVOKE VIEW ANY DATABASE FROM ----

She will be able to run...

thanks - I think event notifications are a Service Broker thing, and I haven't had a chance to look at that yet.

Think that'll be my next port of call.

I...

yeah, we may have to look at that sort of scenario.

Ideally, I'd rather do everything on the one box, as time is short, but if the only stable solution...

thanks for that. I don't think the Oracle client for 9 will work with a 7 database however. The highest I could get to work was 8.

cheers,

thanks for that. looks ideal.

I would definitely advise using the inbuilt SQL Debugger in Visual Studio 2005. There is an article on MSDN which explains how to set it up (very straightforward). Using this...

What error do you receive? Is it a syntax one?

I would tend to do this:

DECLARE @recipients varchar(100)

exec sp_Getmail 'xyz', @recipients OUT

SELECT @recipients

How many records are we talking about here (being returned from your SELECT statement)? If it's a relatively small number, I would be tempted just to do this in...