can't find SQL Server 2012 Configuration Manager
Sep 29, 2017 · Because SQL Server Configuration Manager is a snap-in for the Microsoft Management Console program and not a stand-alone program, SQL Server Configuration …
compare rdl files - social.msdn.microsoft.com
May 20, 2011 · I would like to know if there is a way to compare rdl files with each to see where a difference may lie. Basically I have the orginal SSRS 2008 r2 report and know it has been …
Error: 615, Severity: 21, State: 1 Could not find database table ID 2 ...
May 31, 2012 · Not sure if this will help... given that it is on a cluster, I would ask, how does SQL know where the tempdb information has floated... TempDB can fluctuate based on the needs …
net_packet_size being overridden? - social.msdn.microsoft.com
Apr 19, 2010 · Our running values for net_packet_size are set to the default, 4096. however, a select from sys.dm_exec_connections reveals TCP connections (MS JDBC 2.0 via Tomcat) …
SQL SERVER 2016 Setup/Upgrade Error: Client Tools SDK and …
Nov 22, 2018 · SQL Server 2016 SSMS 1033 Enterprise Edition 13.0.15000.23 No Yes
tempdb won't shrink - social.msdn.microsoft.com
Jul 15, 2020 · We’ve been on SQL 2008 R2 for about a year and have had zero tempdb problems. SQL does a good job of managing its size, until now. Tempdb is configured with 8 …
Unable to Ping - social.msdn.microsoft.com
Jun 6, 2018 · Under Client Protocols, I have Shared Memory, TCP/IP and Named Pipes all enabled.\ In SQL Server Management Studio, if I go into properties of my server and go to …
Permissions within SQL Server Agent jobs
Oct 24, 2011 · By default every job step runs in the security context of SQL Server Agent Service account. If the SQL Server Agent Service account is different from the login account and if it …
Replication Snapshot - The subscription to publication has expired …
Sep 15, 2011 · I have 2 sql 2005 instances within a host. InstanceA is the publisher and distributor while InstanceB is the subscriber. I had configured db1 in InstanceA to be replicated …
Why does UPDATE STATISTICS WITH SAMPLE take longer then …
May 2, 2014 · The reasons why WITH SAMPLE RATE might take longer is that SQL Server will try to find an access path that is NOT sorted on the leading column of the statistics.