September 6, 2013 at 12:48 am
Hi
We recently installed Lync at our company.
Lync creates 4 SQL instances and I have set up maintenance tasks for these instances.
Strange thing is that sp_UpdateStats does not exist in any of the databases created by the Lync installation.
If I create a new database on the server, I can run sp_UpdateStats with no problem.
I have not found one article out there about anyone having this problem. Strange. Can anyone help?
Server OS: Windows 2012 DataCenter
SQL: 2012 SP1
Please, please can someone help.
Thanks,
TDP
September 6, 2013 at 1:08 pm
That procedure isn't in a user database. It's in the system resource database and, because it's a system procedure, can be called from anywhere.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy