Thats great thanks guys

Ok so my plan would be to trace the workload against that particular table. Then on my test system replay that and view the results, then drop then index...

Hi and thanks for the reply. It seems the ID column is being used to count the number of rows in various procedures. As such I am not...

Sorry I mean maintained but never used, have never had any read against them performed. The information as obtained from index_usage_stats.

I have since been looking at the dependencies of...

Yes it was my own account. This is just on my local machine so wasn't too bothered about security as was for personal development, however I am still intrigued...

Hi thanks for the replies.

What I did in the end was to enable the Super Admin account in Windows 7 which by passes all UAC, I then re-installed SSRS and...

Well I have found this article that has helped

http://msdn.microsoft.com/en-us/library/ms178640.aspx

Still can't get it working through the GUI though.

Hi Lynn

Yes I am still unable to create a login even with the Alter Any Login permisson granted at server level. BoL says for db_securtyadmin at the database level...

Ok - seems like the following is required according to BOL

Requires ALTER ANY LOGIN or ALTER LOGIN permission on the server.

If the CREDENTIAL option is used, also requires ALTER...

Cool thanks

No its a local windows account.

I am wanting to connect to a share in another domain using the proxy so using a domain account wouldn't work.

Believe me I don't want it to be that difficult I just get the scenario to deal with.... but thanks for the reply anyway.

Hi thanks for the replies. This is SQL 2008 R2 in integrated mode. I should say I have got a little further with this and in fact am...

Ok great thanks Grant I will check it out - btw I read your book on Execution Plans very informative 🙂

Ok great stuff thanks guys.