After running dbcc show contig: if scandensity is 100% than no need to go for defrag or rebuild. If scan density is 50% than rebuild required. What else are...
Krishna, That is the only parameter which indicates the fragmentation level. If it is SQL 2005 it is recommended to use the dmv sys.dm_db_index_physical_stats...
Dear all, I am planning do MCITP sql 2005, please guide me which is the best institute giving training for this exam in Kerala, Bangalore or Hyderabad. if you...
Hi Team, My database is in restore process.Is there any command to know what was the status of the resore process[How much restore done and how much still need...
Hi, While creating Linked Server on SQL 2005, I am getting error Msg 15466, Level 16, State 2, Procedure sp_addlinkedsrvlogin, Line 91 An error occurred during...
try looking at dbcc outputbuffer(restorespid). Return the value in text mode, on top you can see %age of completion. thanks jyothi <BR> <BR> <blockquote...
Hi Team, while executing the DTS package am getting the following error. "ActiveX component can't create object excel.application" on that system excel is not...
Manish, This is security issue with the linked server and you need to do couple of things here. 1. Add: Local server login to remote server login mappings 2....
HI All, i have 2 node windows cluster in 64 bit env in production. on top of it we have sql server 2005 in 64 bit. the configuration is like : 1) HP Server...
Hi Rakesh,  It is normal behavior of cluster. Whenever you move cluster groups, sql server services will be restarted because services will stop on...
Online Accounting Degree <http://www.onlinelearningschool.com/degrees-by-subject/online-accountin\ g-degrees.html> With the expansion of business and industry...
Rakesh, Does the SQL Server gets restarted or the physical node by itself gets restarted? If its just the SQL Server its an expected behaviour if the physical...
Hi Rakesh, Yes, it is a normal behavior of cluster, however as per your details what type of cluster your using Active \ Active or Active \ Passive cluster?...
Hi Radhye, i do RDC of any Windows Public IP/Private IP  then from  cluster Administrator select 2nd virtual sql server group ,right click and move...
Rakesh , I find it unclear the issue faced,Here are few things you might want to know Few things as seen by me a) When you move a group which has SQL Server ....
Dear Rakesh, In clustering there will be a shared location which will be common for both/all nodes and you will install the cluster on this shared disks. So...
Hi All, some times in the server sql server agent is up and running, but jobs are not executing for some time like 2 hrs. after that compulsory manual start is...
MBA School Rankings <http://www.mbacareerprogram.com/mba-school-rankings.html> Several publications such as Business Week or US News & World Report have ranked...
Hi Team,  We are looking for some script which will provide below details for all the databases at a time.  1. Sql server login ID’s 2. Database name ...
MBA from Kennedy Western University <http://www.thembadegreeonline.com/university/kennedy-western-university\ .htm> Hundreds of corporations have evaluated...
Hi This is Vijaya Krishna Kadiyala, just wanted to share my knowledge in SQL Server over so that i can share some knowledge and gain some knowledge from you...
Hi All, We have a timing problem in our existing database design, the main purpose of our database is to produce reports in RS and all the reports are time...
Double OK ! , welcome to the group :-) On Fri, Jan 23, 2009 at 9:11 PM, vijaya_krishna_birju < ... [Non-text portions of this message have been removed]...
UTC Datetime is a good way to go as the way i see , would recommend altering the tables by adding another field with UTCDatetime ..and Having different ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
