i have verified the which database has using CLR objects, there two type of CLR stored prcedure and CLR Scalar funtion. but these two objects CLR Permission is UNSAFE_ACCESS. it...

Thank you for posting Dead lock article, it is very useful for me

READ_WRITE dead lock frequently happaned in my production system, this is 3 rd party application and they...

There is one way deadlock resolution as below steps

Step 1: captured the SELECT Query from Deadlock graph

Step 2: created actual execution plan and found the Total Query cost is...

Thank you for identified the issues.. as you suggested i used sysname datatype on schema_name column and its worked..

For the above errors need to check as bleow points

1. N/W connection break and not stable

2. application not able to connect with user name & password which was mention exists...

I want to know if an issue with...

Thanks for your valuable replay..

I have verified in Application event log- Error apperaing related to SEP (symantec Endpoint Protection) due to updateing new version of SEP.. it was courrupted...

Due to that error AUTO SHIRNK enabled on that database..after disabled error was not appear in log file during transactions..

also log file inital size 1 GB and allow gorwth upto...

Bhuvnesh (10/17/2013)

---

This could be reason....

Bhuvnesh (10/16/2013)

---

Is the log drive being used by other things too like tempdb or data files ?

And what was the initiall size of this log file ? and have you...

Mr. george sibbald your replay is most valuable..Pl. Do't mistake me, I am reply the Mr. Perry question

Thanks

I am just asking secondary server movement to another location which was configured database mirroring setup?

what are the steps need to follow during movement activity? suggestion Pls.

For database backup taking on network dirve, Is it really require to enable XP_CMDSHELL feature in instance side? there may be security issues

Hi,

I am going to deploly at production database for Mr. Michal rebuild index script,

http://sqlfool.com/2011/06/index-defrag-script-v4-1/

I have doubt as below parameter

@forceRescan 1 - forace scan and 0 =...

I have changed Global Temp Table as per your suggestion

yes.. It is working fine.. and Grate solution given to me

Thanks a lot..