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.

Thanks for your response - I forgot to mention that it uses windows authentication.

Another approach below.

SELECT SUM(deqs.total_logical_reads) TotalPageReads,

SUM(deqs.total_logical_writes) TotalPageWrites,

CASE

WHEN DB_NAME(dest.dbid) IS NULL THEN 'AdhocSQL'

ELSE DB_NAME(dest.dbid) END Databasename

FROM sys.dm_exec_query_stats deqs

CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest

GROUP BY DB_NAME(dest.dbid)

See if sys.dm_exec_query_stats DMV helps you.

You can get closer to the resolution if you check this cool script out:

http://www.sqlservercentral.com/scripts/Administration/67567/

I meant to say ON of course..just mixing up things here a little. 🙂 You're correct.

Good (and pretty old) question indeed. Now if we choose to set them OFF in order to maintain the indexes properly what will happen? If reorganizing indexes would improve I/O...

Thanks very much for your response!

I would uninstall just to make sure 😉

dboProduct Sales for 1997testerVW VIEW DEFINITIONDDENYDENY VIEW DEFINITION on [dbo].[Product Sales for 1997] to [tester]

The result set above is what you are asking for if I understand you well....

Does the below script help?

select sys.schemas.name 'Schema', sys.objects.name Object, sys.database_principals.name username, sys.database_permissions.type permissions_type,

sys.database_permissions.permission_name,

sys.database_permissions.state permission_state,

sys.database_permissions.state_desc,

...

Hi,

You could check out how sp_changedbowner works. I mean sp_changeobjectowner 🙂

Tool? What tool? What is your question?

Hey there,

Check out the QotD section here on SSC and filter on T-SQL and go through the questions... That should help.