Good work Grant. You could probably tune a little bit more for example specifying the page_count limit in the clause and modify the line from

SELECT @command = ''ALTER INDEX ''...

Lowell, this is what I wanted to hear. I assumed both the database owner and the db_owner role members have pretty much the same permissions on a specific database but...

I suggest you to start using Powershell.

Mr. Holio (2/27/2011)

---

Very useful article. However I've recently came across quite a few entries while checking my integrity check maintenance plan history:

Executing the query "DBCC CHECKDB WITH NO_INFOMSGS "...

Very useful article. However I've recently came across quite a few entries while checking my integrity check maintenance plan history:

Executing the query "DBCC CHECKDB WITH NO_INFOMSGS " failed with...

Does c:\test\ exist at all?

Appreciate your response.

Yours,

Mr.Holio

Grant Fritchey (2/24/2011)

---

I agree with Mr. Holio, or can I call you Bung? It depends. In...

Is he member of the dbcreator server role?

updated 2/25/2011

damn, for some reason I read CREATE DATABASE 😉

I would say it depends. You shall monitor the number of reads and writes on a...

Have you double checked your paths specified above? There are a couple of typos in this script..

I welcome any ideas. Thanks.

When I was saying the log was full I meant 10-15 entries per day and those have been generated by the actual user who tried...

For those who might be interested... the ODBC data source has been tested and guess what...

Running connectivity tests...

Attempting connection

Connection established

Verifying option settings

Disconnecting from server

TESTS COMPLETED SUCCESSFULLY!

But not working from the...

I can't investigate it further as application users get the error msg.

That's all I can see in the log: 18456 severity 14 state 5

I appreciate your response Gail. Thank you.