<br />Hi All,<br /><br />Can someone please advise on error below. <br /><br />TDS buffer length too large [SQLSTATE HY000] (Error 4940<img...
All, I have renamed our existing Test (grogts)server to Production (grogPs). Now i am unable to update or delete old jobs. I don't have...
Hi Experts! Is it recommended to run maintenance jobs (reindex/defrag, dbcc checkdb, update stats) on master database. Thanks in Advance. -S
Hi All, I have scheduled a DTS package with my login and running this package under service account abcadmin. My id has SA rights on server. When i...
Hi All! Can some one please assist me on below issue. During maintenance window, our datbases went to suspect mode.Another DBA has fixed them. Now...
All, In past i have configured AWE on cluster server but now i am bit confused. Do i need to configure these values on both active and passive...
Hi All, On cluster server,SQL Services are started with domainsqladmin-sql15. account. I need to configure SQL Mail on the server, therefore, I am...
All, Query time-out setting needs to be set to '0' on one of server. Do i need to recycle SQL Servises to have the settings take effect. Please...
Hi All, We have 16 GB of memory on our server. We have allocated 12 GB to SQL server and left 4 for OS. sp_configure shows run value of 12288 but...
Hi All, we are missing SQL performance objects in our cluster server. We do see all other perfromance counters but notting releated to SQL. Any...
Hi All, How do we monitor the blocking on sql 2000 server other than running the procedures below. It's a production server and i can not run the...
Hi All Any one can tell me what is Firehouse mode? When i tried to update the table i got the error msg " transcation connot start while in...
Separate names with a comma.
