Is your distribution database on the same server or on a remote server? I set up my distribution database with t-sql commands. Doing it this way might help you isolate...

deny overrides grant except in your case becasue you are in the sysadmin role.

Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.

If the commands that the application is executing are done through stored procedures then setuser='heraccount' in management studio and attempt to execute the stored procedures through management studio. If the...

What system, application, and/or users DO need to see the salary data? If you rely on the SQL engine to decrypt the data, then you cannot avoid sysadmin from being...

You can pipe the output somewhere, and then read that output, but you cannot treat with it like you would an output parameter. What do you want to do with...

You can also control the min memory

EXEC master.dbo.sp_configure 'min server memory (MB)', xx

which may be beneficial if you want to keep the buffer pool and proc pool filled....

SET NOCOUNT ON

DECLARE @DB SYSNAME

,@OldUser SYSNAME

,@SQL VARCHAR(MAX)

SET @OldUser = '' --<----------------THIS VALUE NEEDS TO BY CHANGED----<<

DECLARE db CURSOR FAST_FORWARD FOR

SELECT name FROM master.sys.databases

WHERE State_desc = 'ONLINE'

...

This could work, but keep in mind that the information in sys.dm_db_index_usage_stats is only since the last service start. If your SQL service just started yesterday there won't be any...

The following gives summary information about the four high availability solutions:

http://msdn.microsoft.com/en-us/library/ms190202.aspx

Using application or business function names is better. For instance you could use

Production - and additionally ProdAdmin/DevAdmin/QAAdmin

QA - and additionally QATester/QAWriter etc if necessary

Development

Consider your writer AD group. Do you...

I don't have a script for this, but it seems like you could just use sys.tables and sys.columns and sys.types inside of a cursor or while loop to create dynamic...

In order to give a more useful answer you really need to answer the questions stewartc-708166 submitted. However, I will post some general commentary.

It sounds like you are indeed suffering...

Many times the questions are ambiguous or semantically misleading. This was not one of those times. Also, I learned something new. Thanks for the good question.

David is correct on the the other thread about the @C varchar(10). I haven't looked at the code you posted too closely but it appears be a matter...

David beat me to it. . .