Thanks Mohammed! quote:Originally posted by MohammedU FIX: ODBC Driver May Return "TDS Buffer Length Too Large" Error...
<br />Hi All,<br /><br />Can someone please advise on error below. <br /><br />TDS buffer length too large [SQLSTATE HY000] (Error 4940<img...
Thanks Mohammed.<br />Team Memeber has fixed it. I will keep it for future <img src='/community/emoticons/emotion-1.gif' alt=':)' />.<br /><br...
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...
Thanks! quote:Originally posted by techbabu303 Yes...it is important the monitor the log usage, check fragmentation level for clustered index and...
Thanks for your reply. We are using both authenticctions. quote:Originally posted by madhuottapalam check the authentication... it seems to be...
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...
Thanks Mohammad and Satya!!! I will get back to this post later.. currenlty i have some other issues which need to be fixed. Really appreciate your...
During Maintenance window, NT team couldn't bring up MSDTC services. While they were messing up with server, all dbs went to suspect mode. we...
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...
Thanks Mohammed. Provided info was helpfull. quote:Originally posted by MohammedU AWE configuration is sql configuration...you should use...
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...
Thanks for valuable info. We have only one default instance. As you guys suggestd, it should be fine. quote:Originally posted by MohammedU If...
Mohammad i meant to say this configuration will be done on Cluster server. I will review the provided links. Thanks for prompt help! Sahil...
Thanks Girish. I will have them to create a mail box for us. quote:Originally posted by gvphubli Should not be an issue in this case. However...
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...
Thanks Satya! We are using this server account on few other servers and i think it has enough permissions. Since we have added it in lock page.....
It's in C drive. Thanks Satya. quote:Originally posted by satya Where is that PF stored? Satya SKJ Microsoft SQL Server MVP Writer, Contributing...
Yes Mohammed this is dedicated sql server. Thanks Sahil quote:Originally posted by MohammedU Is your dedicated sql server paging when max server...
Separate names with a comma.