I feel is is usable? Click execute and all is revealed........It is the preferred way to post code on the forum.

I was having a few problems getting the updated query...

I have attached a sample script that creates the required tables (tempdb) and inserts 5000 rows.

I have modified my original query to run against the sample tables.

Kind Regards,

Phil.

Hi (still working on sample code).

I ran your code and received error:

Thanks,

Phil.

Hi. I am attempting to put together from sample data as I know it helps.

Watch this space.

Regards,

Phil.

Thanks, I will give that a whirl.

Phil.

Guys I am now revisiting allowing access to specified users.

I note if I add Login (default 'Server Role' 'Public') the user can create Logins (albeit with no permissions)? I am...

What is it you want to do? Are you hosting the websites locally or is a third party going to host? Are they intended for public access or as an...

Hi guys. Rather than deny all can I deny view to specific databases?

Jeff I did not quite follow your suggestion regards the use of Synonyms?

Many Thanks,

Phil.

That worked. However from the research I have done it appears I am unable to explicitly GRANT View to the users default database.

Any thoughts,

Thanks,

Phil.

Thanks for posting.

I gtt error msg 102, Incorrect syntax near '\' when trying to apply to AD group

Deny View Server State To DOMAIN\AD Group Name;

Can I apply to AD...

Thanks. I did not feel there was a relationship because there was no FK.

I will take a look at the blog also.

Phil.

Thanks Jack. Third party app so I have no control!

Once again, thanks for your time.

Phil.

Lutz now that is what I call service.

Many thanks,

Phil.

Thanks for the input.

I decided on SQL Express 2005 SP3.

Thanks,

Phil.

Paul great stuff. I will add in the remaining 65 columns :).

Many Thanks,

Phil.

PS: If I add all additional columns from the table to which sections of your code must they...