I have one reporting application which was running smoothly for last 3 years without any problem.For last 3 days I observed lots of blocker...
Yes
Hardware is more advanced now,we have got 16GB RAM ,earlier it was 4 GB.
Hi All, Last month we migrated all our databases from SQL 2000 to SQL 2005 and set the compatibility to 80 to support backward compatibility. Now our...
Hi All, I have a single instance SQL 2005 EE, on win 2003 EE box with 16GB RAM.To fully utilize all the available memory I decided to go for AWE...
Hi All, We have a SQL database(size 20 GB) used by a 3rd party application called surfcontrol.We need to purge data from this database keeping 3...
I unchecked the account lock option in dsa ,Created a copy of svc-sqlreplication ,with different name .Then went to security--credentials--and tried...
Hi Folks, Our replication jobs are failed with the error message 'Error authenticating proxy farm\svc-sqlreplication, system error: The referenced...
Is there is any specific hardware this is releated to ,I checked the disk using chkdisk utility ,but unable to get any issue.
Thnx Luis for your reply, Can I transfer the records of this table to another table,and then use the allow_data_loss option ? or perhaps delete this...
Hi Folks, DBCC Checkdb reported 56 consistency errors in one of the database.I tried using repair_fast,repair-rebuild,reindexing ,restart of service...
I followed all the steps one by one,checked that all the settings are fine. Any further information
SHi Folks, The SQL agent is not comming up ,a service restart failed with error message the The service didnt starti in timely fashion' Few days back...
I am not sure how this happned,but this box have sufficient memory.Unfortunately error log /event viewer didnt log any error/info msg. Any more...
Hi Folks , The Reindexing job got cancelled and the history is displayed a message that the The job was stopped prior to completion by Shutdown...
Hi Folks, Is there is any Service Pack 2 specific for SQL reporting service,I know about SQL 2005 service pack 2 but no idea about Reporting...
Hi Folks! Backup ,transaction log backup and few other jobs failed with error ConnectionRead (WrapperRead()). [SQLSTATE 01000] Msg 11, Sev 16:...
yes this spid is displayed in result set ,using sp_who2 active Is any alternate method is available without restarting
Hi Folks, One member of my team has killed the backup processes as it was blocking some other job processes. Now its almost 7 hours after the...
After further investigation I observed that the distribution job continously running , althouh it is schedule to execute every 10 min, this job...
Separate names with a comma.
