July 10, 2012 at 10:07 am
I am having one login srclogin is having datawriter,datareader and executer permission on the database eventhough users are complaints that getting timeouts when doing searches and trying to update the database...
can any one please suggest me on this..
July 10, 2012 at 10:24 am
I'm not sure I understand... However, the issue is timeouts from users that use an application and the application user is this srclogin?
Jared
CE - Microsoft
July 10, 2012 at 10:25 am
yes the applications user is getting timeout errors when access/executing...
July 10, 2012 at 11:49 am
Ok, well the issue then is not permissions, but the queries and overall design of the database/procedures.
Jared
CE - Microsoft
July 10, 2012 at 11:51 am
We would need a lot more information to help you here, but it is probably not worth trying to solve in a forum. Take a look at this book, and maybe get yourself some professional consulting: http://www.red-gate.com/community/books/accidental-dba
Jared
CE - Microsoft
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply