Hi, I am not sure comment on this with complete confidence since I can not reproduce this issue. But after seeing your post, I had done some google...
Just my thought: Can we use Integrated Security=SSPI here? -Johnson
Thanks Satya
Yes, I second you Satya. What I said from my specific environment background. We do not apply SPs soon it launched. We will kept the latest SP in DEV...
What I used to do in this case is, use the below script for each DB and kept if for my activity time. Hope this will helpful for any specific DBs (50...
It was an good question which also prompt me for some reading. I got a blog from MSDN, hope this will help you and it also points out similar issue....
I would also suggest to apply SP2 on the Server. It really make sense. SP2 build will never break any of your code as per my info (try it on dev or...
I would like to ask few questions here before commenting on this: 1) What is your main goal, you want to get your data be protected? or compressed?...
HI Deepak,This info is published in the Service Pack release document by Microsoft.For SP3 you can refer this link:...
HI,Usually, distribution cleanup job will take care of this issue.Check this link; this will help you....
HI Kaushik,This is a generic question and difficult to answer. You may need to answer many questions like, how was the performance till now? I mean...
I found memory issue related readings earlier.Try this:http://www.sqlservercentral.com/Forums/Topic413091-360-1.aspx Before all these, ensure the...
HI Mani,I have one suggestion too. You can set T-Log backups for this database if you observe the hug transactions and Log Growth. Like this way, you...
Thanks Satya and John,Though we may know the features, we never try these things unless until we experience it. Thanks for John's experiment and...
HI,You are getting this access denied message, because your account do not have relevant permissions to grant the privileges. If you know the 'SA'...
HI Mani,What I understood from this is, Microsoft Visual Studio Project Model DLL or .olb is not installed peroperly. Since you tried repair and it...
HI,Can you go through this link? http://articles.techrepublic.com.com/5100-10878_11-6161839.html This Link gives an idea, how to configure and test...
Hi Thulasi,I think your issue is not performance, but want to show the amount of space you saved after the clean-up.In this case, what you can do is;...
HI Chetan,This Microsoft link will give an idea on this : http://msdn.microsoft.com/en-us/library/ms175537.aspx
Hi Joy,unless until you give more info about your database size and its growth, concurrent user connections, nature of the databases (OLTP/OLAP), no...
Separate names with a comma.
