does he have execute permission on the procedure? He needs that, and control permission to modify it.

rmechaber (9/23/2009)

---

Thanks sturner. Two questions:

How long is "a while" and how do I force a recalculation of those stats? It's a real problem if I'm trying to verify...

the old stats will age off after a while

That is the best way, but requires all the users to be using integrated security.

is that the only index on the table?

bounce SQL server and see if it is still consuming that much. If so then check the actual min and max memory configuration settings.

Only advise I could give is to avoid XML and use straight text. XML is costly in terms of resources and if all you are doing is just logging the...

There is no way to tell which account the SQL Agent is 'configured' to run as by looking in the database. It uses whatever Windows account (local, domain or system)...

look at ONLINE option for index rebuild, see if it can be done on your particular table. Beyond that, you should be able to set up an Agent job...

What is this "built in key management" you are talking about?

To answer your questions, for a) make sure you have appropriate time and backups. For b), I would re-encrypt to...

if the column being updated causes a page split, it will affect the indexes.

Performing a number of DBA type duties can be done sans TSQL, but I would never hire someone as a DBA managing large amounts of critical data unless they were...

This subject has been covered at length in another thread. In my opinion a DBA must know TSQL to be 100% competent.

As to your second question, there are quite a...

As you stated, the database conversion takes place during and after the restore to the 2005 server. It will be in version 8 compatibility mode. There is no need to...

A few things like better connection pooling and multiple active result sets (mars) [need to upgrade to SQLNCLI], better management tools [and better interface i think]in SSMC, better security granularity.

But...