Thanks...

Please clarify why tempdb is encrypted...Because tempdb is used by all the databases.

Thanks,

I was trying it from GUI!!

Using command it works!!

Is there any microsoft link for this.

Sorry Gila..but some persons only know Microsoft..

I can't do installation and I have close and Open SSMS also.

I have not the admin priviledge on the server.

Error:

The module "C:\Program Files\common files\microsoft Shared\MSEnv\TextMgrP.dll" was loaded but the call to dll register server failed with error code 0X80070005

I am getting this error:

https://picasaweb.google.com/117663646730679854624/26May2011#5610996827147206882

Thanks a lot Gila,

My Edition is:

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Enterprise...

Thanks,

I know also restart will work But I cant restart.

I have killed the intellisense SPIDs also.

Lowell I am not getting why u have pasted your "OPTION" Screenshot.

session_idrequest_idstart_timestatuscommandsql_handlestatement_start_offsetstatement_end_offsetplan_handledatabase_iduser_idconnection_idblocking_session_idwait_typewait_timelast_wait_typewait_resourceopen_transaction_countopen_resultset_counttransaction_idcontext_infopercent_completeestimated_completion_timecpu_timetotal_elapsed_timescheduler_idtask_addressreadswriteslogical_readstext_sizelanguagedate_formatdate_firstquoted_identifierarithabortansi_null_dflt_onansi_defaultsansi_warningsansi_paddingansi_nullsconcat_null_yields_nulltransaction_isolation_levellock_timeoutdeadlock_priorityrow_countprev_errornest_levelgranted_query_memoryexecuting_managed_codegroup_idquery_hashquery_plan_hash

102011-05-26 15:29:44.767backgroundRESOURCE MONITORNULLNULLNULLNULL01NULL0NULL0SLEEP_TASK010NULL000523003310485780x055EE1C00004096us_englishmdy7000000002-10001001NULLNULL

202011-05-26 15:29:44.767backgroundXE...

Thanks Tom...Gila..and all...

What is the difference between query plans and compiled batch plans?

if the SQL Server Browser service is not running, the following connections do not work:

Any component that tries to connect to a named instance without fully specifying all the parameters...

Thanks..

Seperate resource means:

1. One more data drive from SAN

2. IP for MSdtc and Ip for sql server

anything else...

have u used

domain\userid and then Password

Have u checked the IIS Authentications?....