If I am allowed to venture a comment on this, I would say, The DBA should know when to enforce Normalization and when to DE-normalize. 🙂 There are times when...

Steve Jones - Editor (9/16/2009)

---

Here's my take. All of the agent based tools have had issues at times. I've sen too many of them fail on restores, which is what...

Thats what I thought. I guess the rights were not mapped to the right Schema. 🙂 Thanks for clarifying. 🙂

You get the Tag Mr and Mrs 500 when you have 500 points/Post counts. It shows that you are getting addicted to SSC.. :hehe:

Well done Bob. Enjoy your Pass. Hopefully I can come to Pass next year. This year I cannot

I usually use not exist. But you can check the performance by looking at the statistics. Also if you are looking at SQL 2008, You should check SOME/ANY/ALL

For SQl Server, you can remove the BuildIn/Administrator role (before removing it make sure you add your windows user as a Sysadmin). That means not every administrator can log on...

You state that you have given these rights to the user.. "db_datareader, db_datawriter, db_ddladmin". That should automatically give permission for executing the user defined stored procs. But are you sure...

Thanks for the update Grant. Please do give her my regards when you talk to her.. 🙂

It is very quiet... And where is Gail? Is she doing fine? It has been long time since I have seen her comment.

Good one Markus. I never thought about that. But does the user have to be a...

Thats what I thought as well.. 🙂 Well, hopefully the OP will take the advice of GSquared 🙂

I do not think it is possible. But I am not sure why you need to be a local admin to connect to the DB using SSMS?

Would someone want to help this OP out? I am not getting anywhere with this guy.

Increasing the lock timeout is not going to help you. You have to find out what is causing this. That is your only solution.