Feb 14, 2015 · Is it possible for a SQL Server 2012 Failover Cluster to host a SQL Server 2008/R2 Instance? That's dependent upon the OS used and if it supports SQL Server …

Dec 27, 2011 · The instance collation will affect all applications. SQL_Latin1_General_BIN is case-sensitive so all variable names, tempdb objects and GOTO labels are case-sensitive.

Feb 28, 2014 · However the SQL instance is 2008 R2 and it looks like the filtering option is not available at this version. I'll stick with the trace for now, but bear this in mind once the instance …

Nov 13, 2016 · Quickest way is to kick the machine out of the cluster, install a stand-alone SQL instance, then re-add it to the cluster. Since the machine doesn't participate in an FCI, the …

Feb 5, 2018 · First of all a hostname CANNOT have SPID or service ID, this identifier is given to queries running on SQL Server not to any machine. My query is IF it is the query initiated from …

Mar 16, 2018 · These instructions assume you are taking a back-up from another SQL Server instance and trying to restore that back-up file to a new/separate SQL Server instance.

Feb 19, 2017 · Now, my real question is if I can create a synonym for a linked server on a test instance? for example can I create a synonym 'lsrandomprod' that points to 'lsrandomtest' in …

Jul 31, 2013 · 1-SQL server authentication - if we are using SQL server authentication then first click on connect to server option in SSMS then we got a small window. in this window we …

Jun 10, 2014 · I created a new user, LinkedVFP, and added to the SQL Instance (using Windows Authentication), mapped the user to the master database with the db_datareader role.

Jun 6, 2018 · In SQL Server Configuration Manager I have SQL Server, SQL Server Browser and SQL Server Agents all running. Under Client Protocols, I have Shared Memory, TCP/IP and …