check BOL

from performance perspective, it should be clustered index with appropriate fill factor.

Also make sure the index is being updated regularly for threshold limit like :-

if fregmentation is <30 then reorganise...

but if its secured connection which is connecting to database then i dont think reading matters that much. They have no permisssion to modify it.

Correct me if I am wrong.

then in that case I think we need to setup the auditing on every connection getting connected to database.

are you configuring the correct account for sevices to run.

Also just check either the service name its creating is having default name or having the instancename as well.

Jut...

sp_who2 will run for all the databases.

If its specific to one database then you can try something like :-

select * from sysprocesses where dbid = yourdatabaseid(which you can get by...

Never love your company because you never know when the company will stop loving you.

Thats what I follow.

Being in one job for years is always no no for me. I...

you mean something like sp_who2

great.....good to see you happy with the self developed resolution

hope this article will be useful for you

http://www.sql-server-performance.com/articles/dba/Data_Compression_in_SQL_Server_2008_p1.aspx

i think its better if you create function which take three variable or whatever number of column you have and then pass the column names on those variable.

then within function...

just replied on one of the post today, so will advice the same here...

there is tool tablediff utility which will compare 2 tables and will show the difference.

Actually there is nothing predefined steps which you need to follow in such excersie(so far I am aware) but you can very well use tools like dbdesc.

For more information on...

jobs are in msdb database so as long you not restore msdb, its not gonna affect secondary server.

Also just a suggestion, instead of scheduling the shrink log file, you...

give it to developer who designed the application..