Please confirm that Mssqlserver services are running on your notebook? Olu Adedeji
you may also visit herehttp://msdn2.microsoft.com/en-us/library/aa496081.aspx for more information. also read certification path from sql server site...
XiNull, I think there is something fundamentally wrong in the way that the security has been setup by your network administrators. The port 1434...
also note that high OLEDB waitstats is generated as a result of the following 1) selects on system/virtual tables sysprocesses etc.. 2) linked...
Just a quick one to point out that update statistics with norecompute is hardcoded into sp_MSDistribution_cleanup :-( this was what I was alluding to...
no problem Hollywood, index rebuild rebuilds stats also..however if sp_MSdistribution_cleanup is running frequently, this does stats rebuild of...
go into syscacheobjects and determine if the setops values, if these values are all the same for the proc and the TSQL then check if this is a case...
I have not looked at this but, this looks like a MOM error(filter error within MOM) are you running MOM in your environment, secondly are there any...
not very explicit the errors for job 1, however it appears there may be some anomalies with the schema of the destination table within the...
Cheers Satya, feels good to be back. <img src='/community/emoticons/emotion-1.gif' alt=':-)' /><br /><br />Olu Adedeji
ensure the sql server service account has permissions to your workstation(assuming this is a one off) and use a UNC path referencing your...
is this coincidental (ie. the fact that it only shows slow performance when accessing large tables), and it is indeed the case that during "cleanup"...
Hi I am new to this Forum, can I suggest that you use sqlprofiler to determine the actual execution time at the server you can do this by selecting...
Separate names with a comma.
