Is this what its supposed to look like?

Start-Process –Wait -FilePath R:\Setup.exe -ArgumentList '/Features=IS ISSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /UpdateEnabled=True /UpdateSource="D:\Install Files\Updates"'

This does not work. It takes it through the whole install...

;SQL Server 2014 Configuration File

[OPTIONS]

; Specifies a Setup work flow, like INSTALL, UNINSTALL, or UPGRADE. This is a required parameter.

ACTION="Install"

; Use the /ENU parameter to install the English version...

Thanks Gail!

Unfortunately the application that connects to the database does not support clustered indexes. This is a vendor supplied database.

We are doing a manul failover. Its ok...the problem was sorted. The server was rebooted and that basically fixed the issue.

regards

IC

Thanks Gail!

I will convey to the developers...thanks

Hi Gila,

Thanks for the reply. I am not sure why it is there....this code was written by a vendor...it is a bit difficult to change the code.

Regards

IC

Hi there,

I have created a test user with SQLAgentOperator role rights but the user still cannot see the status in the SQL Job Activity Monitor.

Regards

IC

Got this from another website:

Select Workstation components, select Books Online and development tools, and click Next. This will install the components below:

?Client Components

Connectivity Components

Management Tools

Business Intelligence Development Studio

Software Development...

thanks

I think it has to do with the fact that I am installing a component of SQL 2008 R2 which SP is lower that the one that currently exist on...

Thanks for the fast response but like I said in my mail, the 64 bit option is selected for the installation. We are not trying to install a 32 bit...

thanks!

Hi All,

I create the missing index as the estimated query plan suggested which improves statistics on the query.

Thanks!!