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..

configure profiler with appropriate filter and then run it in background while doing your activity on your application.

you will get the view names in profiler.

have you read about sp_adddumpdevices....have a look.

seems like the query you running having lots of record. Can you try running your query first with top 100 or .. and then see the execution plan to check...

then in that case if a employee having two joining date then you can filter those records in your where condition