I am new to ms sql server and need your help .
I have ms sql server 2008 enterprise edition sp3 on windows 2008 server.
My instance total size including all databases is 15 GB ,need to upgrade to sql server 2012 enterprise edition.
My question is ,how much time it takes to upgrade to ms sql 2012 enterprise edition?

your help will be appreciated.
thanks in advance.
regards.
os:win server 2008
db:sql server 2008 sp3 enterprise edition.]]>2automatic change principal server for connection - mirroringTue, 26 Sep 2017 10:00:20 +0000http://www.mssqlforum.com/threads/automatic-change-principal-server-for-connection-mirroring.26067/
http://www.mssqlforum.com/threads/automatic-change-principal-server-for-connection-mirroring.26067/AlinAlin
But IP and server name in principal server and mirror server is different, and my application and webs are connect to principal and in Failover connection cannot change automatically.
I changing IP in mirror server to principal Handy , how can i resolve this problem?]]>DTS Run Error: activeX component can't create object when running DTSFri, 30 Jun 2017 12:13:21 +0000http://www.mssqlforum.com/threads/dts-run-error-activex-component-cant-create-object-when-running-dts.26033/
http://www.mssqlforum.com/threads/dts-run-error-activex-component-cant-create-object-when-running-dts.26033/Grand WavineGrand Wavine
Regards,
Grand]]>1SQL Server Reporting Services IndicatorsFri, 03 Feb 2017 07:04:27 +0000http://www.mssqlforum.com/threads/sql-server-reporting-services-indicators.25997/
http://www.mssqlforum.com/threads/sql-server-reporting-services-indicators.25997/sandralynnsandralynnIndicators are a visual way of assigning categories to values. In the same way that conditional formatting in Excel might be used to highlight any negative values in red, low numbers in orange and high numbers in green, in reports, you can add an indicator to show a number of conditions.

A common indicator is the 'traffic light', which can be used to show whether certain targets have been met or not. Green for yes, amber for...

SQL Server Reporting Services Indicators]]>Migrating data from local MSSQL server generated script to Azure web app MSSQL serverSat, 24 Dec 2016 13:44:04 +0000http://www.mssqlforum.com/threads/migrating-data-from-local-mssql-server-generated-script-to-azure-web-app-mssql-server.25993/
http://www.mssqlforum.com/threads/migrating-data-from-local-mssql-server-generated-script-to-azure-web-app-mssql-server.25993/umenumen
i have generated 200 mega data script from local MSSQL server , which i generated via Tasks -> generate script in the SQL engagement studio.
When i try to execute it from the SQL Management studio i get massage that i have noא enough memory to run it , which is weird i have 16 giga ram on my pc.
So my question is simple :
How can i update my remote...

Migrating data from local MSSQL server generated script to Azure web app MSSQL server]]>Unable to connect to msSQL DatabaseTue, 06 Dec 2016 04:58:45 +0000http://www.mssqlforum.com/threads/unable-to-connect-to-mssql-database.25989/
http://www.mssqlforum.com/threads/unable-to-connect-to-mssql-database.25989/Anurag AnandAnurag Anand
I have a standalone application on my desktop.Whenever i am launching the application it is not starting.

I am able to connect to the server but not the database.

Can you suggest me a fix for the same. I am using a remote msSQL Database remotely .

I have created a user with widows authentication in the Database and granted it sysadmin permissions also.

Regards

Anurag Anand]]>2Error: Creating an instance of the COM component with CLSID from the IClassFactory failedThu, 05 May 2016 07:22:08 +0000http://www.mssqlforum.com/threads/error-creating-an-instance-of-the-com-component-with-clsid-from-the-iclassfactory-failed.49/
http://www.mssqlforum.com/threads/error-creating-an-instance-of-the-com-component-with-clsid-from-the-iclassfactory-failed.49/Peter SchmitzPeter Schmitz

Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS)

Additional information:
Creating an instance of the COM component with CLSID...

Click to expand...

Error: Creating an instance of the COM component with CLSID from the IClassFactory failed]]>1SQL Server 2008Wed, 27 Apr 2016 18:41:30 +0000http://www.mssqlforum.com/threads/sql-server-2008.25972/
http://www.mssqlforum.com/threads/sql-server-2008.25972/Novita RiniNovita Rini
i have some database in one SQL Server.
if one of database working with more data, the other database working slowly.
So very disturb the others database. how the solution of this case?]]>1Querying LDAPS Active Directory Data from SQL ServerWed, 16 Mar 2016 21:28:37 +0000http://www.mssqlforum.com/threads/querying-ldaps-active-directory-data-from-sql-server.25971/
http://www.mssqlforum.com/threads/querying-ldaps-active-directory-data-from-sql-server.25971/Phillip UdelPhillip Udel
Please help]]>Odbc connection dont workTue, 15 Mar 2016 11:39:47 +0000http://www.mssqlforum.com/threads/odbc-connection-dont-work.25970/
http://www.mssqlforum.com/threads/odbc-connection-dont-work.25970/ZionAssedoZionAssedo
I'm running a MSSQL 2012 server in a 2012 R2 server in a VM and I want to create an odbc connection on my host computer.
The IP address of my VM is 192.168.42.146 and I can ping the VM from the host as well, but when trying to establish an ODBC connection to the Sql server it fails.
The Sql server instance name is WIN-74DOGP6POB3 so in the dsn wizard I specified \\192.168.42.146\WIN-74DOGP6POB3, what is wrong ?...

SELECT ROUND(CAST((ROUND(CAST(80.0-(CAST(SUBSTRING('01:20.70',1,CHARINDEX(':', '01:20.70') -1) * 60 AS FLOAT)
+ (CAST(SUBSTRING('01:20.70',4,4)AS FLOAT)))AS FLOAT),1)/0.2)*-1 AS FLOAT),0)]]>1update triggersFri, 16 Jan 2015 19:15:50 +0000http://www.mssqlforum.com/threads/update-triggers.24921/
http://www.mssqlforum.com/threads/update-triggers.24921/Nazar GabrielNazar Gabriel
Reason am asking, some delete triggered seem to be fired by the update action - is that normal or third-party -softewre annomally ?]]>Line numbers in Management StudioThu, 27 Nov 2014 20:39:45 +0000http://www.mssqlforum.com/threads/line-numbers-in-management-studio.24918/
http://www.mssqlforum.com/threads/line-numbers-in-management-studio.24918/Peter SchmitzPeter Schmitz
How often have you looked at an error message that mentions a line, and then had to click at random spots in your code and then checked the satatus bar (lower-right of the SSMS window) to determine what line you were on?

I know I wasted plenty of time with that over the last few years. But no more! If you go to your menu, and select "Tools" ->...

Line numbers in Management Studio]]>SSIS - Attunity Connector for OracleWed, 22 Oct 2014 09:44:10 +0000http://www.mssqlforum.com/threads/ssis-attunity-connector-for-oracle.24912/
http://www.mssqlforum.com/threads/ssis-attunity-connector-for-oracle.24912/Peter SchmitzPeter Schmitz
Your first struggle will be to figure out exactly which Oracle client you'll need. Chances are you run a 64-bit server. The problem here is that SSIS runs in Visual Studio, which is a 32 bit application. You probably need to install both 64 and 32 bit (the package can actually be ran in 64-bit mode; you just cannot develop it unless you have the 32 bit connector running)....

However, at the time of writing, it is only a bunch of DLLs, and requires registering these in the Global Assembly Cache by means of gacutil.exe. My SQL Server did not have Visual Studio installed, and thus no gacutil.

Installing custom SSIS DLLs]]>Corrupt database: Could not read and latch page (foo:bar) with latch type SHSat, 24 May 2014 10:47:10 +0000http://www.mssqlforum.com/threads/corrupt-database-could-not-read-and-latch-page-foo-bar-with-latch-type-sh.47/
http://www.mssqlforum.com/threads/corrupt-database-could-not-read-and-latch-page-foo-bar-with-latch-type-sh.47/Peter SchmitzPeter Schmitz
You will typically notice it by the database being unavailable and not responsive. If you then check SQL Server Management Studio, you will see the database...