Check this.

http://www.sqlservercentral.com/Forums/Topic644009-6-2.aspx

You can use sp_help_revlogin to transfer the login. you can find the SP from below link.

http://support.microsoft.com/kb/918992

this will also give result that you want

Select * from #Member except

Select a.* from #Member a inner join #Member b

on a.MemberFullName=b.MemberFullName where a.DateEntered>b.DateEntered

You can only take backup on cluster shared drives. SQL server can only access cluster shared drives.

check this.

http://www.sqlservercentral.com/Forums/Topic695034-357-1.aspx#bm1161456

you can do it with DML triggers and it will work only for delete , insert and update not for select.

http://blog.sqlauthority.com/2009/08/15/sql-server-introduction-to-change-data-capture-cdc-in-sql-server-2008/

and if you using sqlserver 2008 you...

You can run DBCC memorystatus() command. this command provides a snapshot of the current memory status of SQl server.the memory manger section shows overall memory comsumption by SQl server.

close your mangement studio and start again . I had a same issue in past

Good Article

http://www.sommarskog.se/query-plan-mysteries.html

http://www.sql-server-performance.com/2002/object-permission-scripts/