If I try to disable the login from either the GUI or direct using T-SQL both come back with the same error.

Great article.

I've been enforcing extended properties on database objects now for two years and it has made an incredible difference.

Tables and procedures are now well documented.

SSRS reports are available to...

Yes, one row

type_desc = WINDOWS_GROUP

is_disabled = 0

Thanks, I'll give it a try

Many thanks for your replies.

I had already tried creating ODBC connections using the 32-bit application (you are correct, I am running 64-bit).

When I finally managed to squeeze a 32-bit client...

Many thanks for the comments and postings so far.

I've spent the day avalysing various things, and at least now I can eliminate the network traffic (thanks Karl - it never...

mmmmm toast, and here I am with a bowl of weetabix :hehe:

Hardware, for me it has to be the mouse. I can spend a good half hour pondering over which...

When we installed SQL Server 2008, we did so with SQL 2008 on one server and SSRS on another server, this caused it to install with no report server databases...

I've got it sorted and thought I'd post the solution in case this trips anyone else up. I didn't notice what had happened until I tried to have the...

We never did resolve it. Our network department decreased the time between replication of the active directory but it never made a difference. We have just learned to live...

Erm, having seen the way that the network department configured active directory, it was migrated directory from the original domain, so it is just one huge chunk.:crazy:

Don't ask me why...

As soon as a change is made to a group or user, we always ensure that they log out of the network and log back in to ensure that the...

All users within the company are members of quite numebr of groups as they control all our resources, however we do not allow nesting.

What was peculiar is that other...

GSquared: I was actually under the impression that nothing ever got finished these days!

Jeff: Any jobs going at your place? Initiative here tends to be welcomes with a ".. and...

Many many thanks for the suggestions so far.

We already implement a helpdesk system (a corner of it I have hijacked just so we can track the work coming in and...