Mar 28, 2016 · SQL Server 2014 with 1 default instance in a failover cluster of 2 nodes. We finally got another drive for the SQL server and want to move the transaction logs to this drive.

Mar 15, 2012 · long story short, i need my subscription management to be run from within SQL server, so that all applications can use subscription management features. several of our applications have …

Nov 26, 2012 · When you install SQL Server you can install it as a default instance or named instance. Only one default instance and a maximum of 50 named instance per server. in your case try install …

May 19, 2016 · Meanwhile you can get MS SQL Server Developer Edition for free at Visual Studio Dev Essential, it has the same feature set as the Enterprise Edition, but is only for developing & testing.

Feb 26, 2014 · i restated a sql server 2008 r2 in my local system and suddenly i lost all my Databases except system databases.

Mar 25, 2015 · OP, technically it is possible to do whatever you want with dynamic SQL, but as Scott suggests this is somewhat at odds with what a relational database is all about.

Jul 13, 2018 · Is it possible to migrate the SSRS Report Server database from the development environment to prodction environment for the deployment.

Dec 6, 2010 · Does anybody know how to get rid of the commitment control of the AS400 when using it as a destination with the IBMDA400 OLEDB driver?? We don't want to set journalling on but we want …

Oct 7, 2013 · This last statement is what I am having difficulty proving. I have access to 3 different SQL Server environments (SQL Server versions 2005, 2008, and 2012). The databases on the 2008 and …

May 26, 2018 · We recently upgraded to SQL Server 2017 to utilize in-database Advanced Analytics. However, when I connect to SQL Server database via ODBC or via R and Python by providing the …