If I have an instance at SQL Server 2016 SP1-CU7-GDR (KB4057119) and want to jump over to the latest SP2 path, which patch or patches do I have to run?   SP2 = KB4052908 SP2-CU2 = KB4340355 SP2-CU2-GDR = KB4458621   Do I run all 3 of these in order, do I run just #1 and #3, or can I just run #3 all by itself?  It’s a bit confusing, but would appreciate the help.  Thanks,  Robert
56714
I have given an RTM version of SQL Server 2014 and I need to apply the latest SP (currently SP2) and CU (currently CU8). Do I need to apply SP1 first? Or can I straight move to SQL Server 2014 SP2 CU8 without applying the old Service Pack 1 and the related Cumulative updates?
56372
I'm working on a request to start logging some additional data for PCI compliance.  I need to log who, when, and what changed on a set of tables.  I set up SQL auditing which would work fine except for the fact that the values of what is being changed is coming through as @1, @2 etc instead of the actual data.  What are my other options for logging the needed information?  CDC does not track who made the change.  This is currently running on SQL Server 2012 but a possible upgrade to 2014 is possible if that would provide a better solution.  Thanks, Tim
89109
I read that it's possible to restore a database in SQL Server as long as you're restoring from an older version to a newer version, for backwards compatibility reasons.  Does anyone know off hand if you can restore a database from a *.bak file for different editions of SQL Server?  We are moving a very large database via FTP that will take a couple days, so we'd rather only do this once. If nobody responds by the time we transfer the database via FTP, we will obviously try this out and see if it works by testing, and answer our own question.  Below is a query to get version details of SQL Server.  The productversion is in the format {major revision}.{minor revision}.{release revision}.{build number}.  In my case, the {release revision} has a value of 5500 for the source and 5512 for the target.  So that looks okay. However, the edition is different.  Query:  SELECT    SERVERPROPERTY('productversion'),    SERVERPROPERTY('productlevel'),    SERVERPROPERTY('edition')   Source database:  10.0.5500.0 SP3 Developer Edition (64-bit)   Target database:  10.0.5512.0 SP3 Enterprise Edition (64-bit)
84656
I'm wondering if $PATH cascades entries. You'll all need to take a leap of faith with me here, but here it goes.  Let's say we have a Java executable at /usr/bin/java but this version is very old and outdated. Unfortunately, we don't have su access so we can't just replace it. We can, however, download the current version of the JRE/JDK locally and point to the updated version. My question is, how does bash handle the case where we have two or more executables with the same name but in two or more different locations? Does bash somehow choose which one to execute when we type java into the console? Assuming /usr/bin has many other executables that we need, how would the $PATH look for something like this to work correctly?  Ideally, when we type java -version we should see:  java version "1.8.0_45" Java(TM) SE Runtime Environment (build 1.8.0_45-b14) Java HotSpot(TM) 64-Bit Server VM (build 25.45-b02, mixed mode)   instead of  java version "1.7.0_45" Java(TM) SE Runtime Environment (build 1.7.0_45-b18) Java HotSpot(TM) Client VM(build 24.45-b08, mixed mode, sharing)   I'm sure this question has been asked before and has some type of jargon associated with it. I've poked around SE, SO, and some forums but didn't find anything conclusive.
81167
I have installed monitoring software on a few SQL Server instances in the environment. I am trying to find bottlenecks and fix some performance issues. I want to find out if some servers need more memory.  I am interested in one counter: page life expectancy. It looks different on every machine. Why does it change often on some instances and what does it mean?  Please take a look at the data from the last week gathered on a few different machines. What can you say about each instance?   Heavily used production instance (1):   Moderately used production istance (2)   Rarely used test instance (3)    Heavily used production instance (4)   Moderately used test instance (5)   Heavily used data warehouse (6)   EDIT: Im adding the output of      SELECT @@VERSION for all of these servers:  Instance 1: Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)  Jun 17 2011 00:54:03 Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.1 &lt;X64&gt; (Build 7601: Service Pack 1) (Hypervisor)   Instance 2: Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)  Oct 19 2012 13:38:57  Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.1 &lt;X64&gt; (Build 7601: Service Pack 1) (Hypervisor)   Instance 3: Microsoft SQL Server 2012 - 11.0.5058.0 (X64)  May 14 2014 18:34:29      Copyright (c) Microsoft Corporation  Developer Edition (64-bit) on Windows NT 6.1 &lt;X64&gt; (Build 7601: Service Pack 1) (Hypervisor)  Instance 4: Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30  Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.1 &lt;X64&gt; (Build 7601: Service Pack 1) (Hypervisor)   Instance 5: Microsoft SQL Server 2012 - 11.0.5058.0 (X64)  May 14 2014 18:34:29  Copyright (c) Microsoft Corporation  Developer Edition (64-bit) on Windows NT 6.1 &lt;X64&gt; (Build 7601: Service Pack 1) (Hypervisor)  Instance 6: Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)  Apr 2 2010 15:48:46  Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.1 &lt;X64&gt; (Build 7601: Service Pack 1) (Hypervisor)   I also ran the following query on the machines:  SELECT DISTINCT memory_node_id FROM sys.dm_os_memory_clerks   and it returned 2 or 3 rows for each server:  Instance 1: 0; 64; 1 Instance 2: 0; 64 Instance 3: 0; 64 Instance 4: 0; 64 Instance 5: 0; 64 Instance 6: 0; 64; 1   What does it mean? Do these servers run NUMA?
17901
We are going through a downgrade process from SQL Server 2008 R2 Enterprise to Standard edition.  To kick off the above activity, we were looking for available Standard Edition of SQL Server. We found one, but got confused on below points:   The setup files (saved by an earlier team member) are in a folder that says it is SQL Server 2008 R2, but just to cross check before we start installing, we went through the default.ini file, which says:   SQLSERVER2008 Configuration File [SQLSERVER2008]    This created a doubt if this is the correct version of SQL Server required. So is there any other way, in case above mentioned method is incorrect to determine the version, before we actually go ahead and try installing? Can we also check the edition of that available SQL Server, because on the set up, we can hardly figure out if it is really Standard Edition?   We cannot simply download new media, per our security policies. Also, we have no rights to download.
13358
SQL Server 2012 and 2016 Standard:  If I put if-else logic in a stored procedure to execute one of two branches of code, depending on the value of a parameter, does the engine cache the latest version?  And if on the following execution, the value of the parameter changes, will it re-compile and re-cache the stored procedure, since a different branch of the code must be executed? (This query is quite expensive to compile.)
119075
How do I limit a SQL Server Profiler trace to a specific database? I can't see how to filter the trace to not see events for all databases on the instance I connect to.
51261
I need to know the default  port settings for the following services   SQL Server SQL Browser SQL Reporting services SQL Analysis services   I neeed to know the port settings for these services for different versions of SQL Server (2000,2005,2008)  Also let me know whether the default port setting will change based on sql server versions  Thanks in advance.
107732
Batch jobs error emails report:      The transaction log for database 'WebDB' is full.   No, it isn't. Its 90% free. The transaction log backups run normally. My hardware guy tells me the hardware is running perfectly, with plenty of space. SQL Server 2008 SP3, but not R2.  I'm a developer, we no longer have a DBA. So it falls to me to try and fix this.
15666
This is a  about Active Directory DNS Settings. Related:     Assuming an environment with multiple domain controllers (assume that they all run DNS as well):  in what order should the DNS servers be listed in the network adapters for each domain controller? Should 127.0.0.1 be used as the primary DNS server for each domain controller? Does it make any difference, if so what versions are affected and how?
59767
I am setting up a new server with 18.04 based on instructions written for 14.04. I have got as far as these steps:  /sbin/iptables -A FORWARD -p tcp --destination-port 80 -j ACCEPT /sbin/iptables -t nat -A PREROUTING -j REDIRECT -p tcp --destination-port 80 --to-ports 8080 /sbin/iptables-save # To save permanently (reset-persistent): sudo sh -c "iptables-save &gt; /etc/iptables.rules" # Modify in /etc/network/interfaces # Add this line:     pre-up iptables-restore &lt; /etc/iptables.rules     # As below:  # The loopback network interface auto lo iface lo inet loopback     pre-up iptables-restore &lt; /etc/iptables.rules  # The primary network interface auto eth0 eth1 iface eth0 inet static         address XXX.XXX.XX.XXX         netmask 255.255.255.0         gateway XXX.XXX.XX.1         dns-nameservers 8.8.4.4 8.8.8.8 XXX.XXX.0.3 iface eth1 inet static         address XX.XXX.67.47         netmask 255.255.0.0   But it turns out that 18.04 does things a different way, using something called netplan.   I have found questions and answers related to how to revert back to how things were done in 14.04, but I am wondering whether it is better to do the same thing the new way.   How can I do what is being done the old way using netplan?
101994
I've got a third-party application (in this case Cognos Data Manager) installed on 64-bit Windows Server 2003.  Is there a quick way to determine if an application has been built/compiled as a 64-bit application or as a 32-bit application?  By default a program wanted to be installed in Program Files (x86). I'm guessing that means that it is a 32-bit version. I had to get it to talk to an Oracle database and to get that working I eventually reinstalled it in a directory path which didn't have brackets "(" and ")" in it, as that was causing a problem. I've also installed both 64-bit and 32-bit Oracle clients.  For future reference, I'd like to be able to type a command "xxxx fred.exe" and have it tell me whether fred.exe would be needing 32-bit or 64-bit setup (eg ODBC data sources etc).
37595
SMESERVER install has been working find for an age then this morning "The error that the other server returned was: 550 v=spf1 a -all", can anyone 'point' me in the right direction to resolving this issue.  There is an obvious element of urgency.  From my own mind 550 is access denied and SPF would indicate a DNS problem, am I right?  Still have no idea on how to resolve it though.  also getting a "bash: 22: command not found", when trying to SSH in.  Any guidance GREATLY appreciated  Stu
86788
Is there any negative performance impact for using the same service account and agent account to run SQL Server and SQL Agent respectively for all SQL server instances running at a small company of say 35 servers? The biggest database is 0.5 GB. any suggestions are welcome. Thank you.
76809
What is necessary to get CPU-G to run on 18.04? I have performed all of the necessary steps I can find (see  and ) and searched the internet generally, to no avail.  Attempting to start the program using the Super key brings up the icon, but clicking the icon does nothing. Likewise, entering cpu-g in the Alt-F2 window also has no effect.  I'm sure this must be something really basic, but I don't have the skills to know what to look for.  Thank you.
116522
I am considering applying the Service Pack 3 in a SQL Server 2008 with Service Pack 1; however, I was not able to find if there are any drawbacks in this process, specially regarding to Replication Services and Reporting Services.   Has someone done this kind of update? Was it smooth or did it generate many issues?