CONFIGURATION IN THE CORE 2 DUO PROCESOR

Hello,

I need change a SQL Server 2005 configuration, this service is placed in a server with 2 Physical processors dualcore and 4 processing nucleus.

I need that it′s use only one of the Physical Processors....How i do that?

TKS

I think the following 2 articles should be of help

http://support.microsoft.com/kb/931279

http://msdn2.microsoft.com/en-us/library/ms186255.aspx

Thanks

Vikas

Configuration in SQLCLR Assembly

Hi,

I have an SQLCLR assembly which is required to connect to a remote WCF service. In order to do this in a host such as IIS you would need to store all your WCF configuration data (endpoints, types etc) in the Web.config or App.config (in a windows forms app). This begs the question: Where do you store configuration data for SQLCLR assemblies?

The System.Configuration assembly is available in the SQLCLR, but this assumes a Web or App config files exists? Does SQL have its own config file that you can keep your settings in which is called when the assembly is running from within the SQL process?

If this is not possible, should I rather be storing configuration data in the database itself?

This particular example relates to WCF configuration but is relevant for assemblies using Enterprise Library which is also config driven.

Any help would be appreciated.

Chris

You can use a config file with SQLCLR. Create a config file sqlservr.exe.config and place it in the same directory as the SQL Server executable (sqlservr.exe). Whatever is in that file will be parsed in when an appdomain is loaded.

However, config files are not supported as such, and there is no guarantee it will work in the future. In addition, there is no way to differentiate between config ettings for different databases.

So, use the best storage facility there is - the database.

Niels
|||

Hi Niels,

Thank you for your response. I will test out the sqlservr.exe.config today. I agree that as the application will be running in SQL that the best storage spce is the DB, this however does not solve the problem where you are using tools like EntLib or Technologies like WCF where they rely specifically on configuration files. I am not aware of anyway to make WCF or EntLib collect configuration data from a sql database rather than the Application configuration file.

Chris

Conditional Formatting in Report Builder

Hi all!

I would like to know if Conditional Formatting in Report Builder is supported in Service Pack 2 CTP.

Thanks for your time.Conditional formatting in Report Builder is not in SP2. We are considering adding it to a future release.

-Josh|||

I am interested in conditional formatting for ad hoc reports as well. Is this something that will be available in the SQL 2008 release?

Thanks,

Lisa

Conditional Formatting in Report Builder

Hi all!

I would like to know if Conditional Formatting in Report Builder is supported in Service Pack 2 CTP.

Thanks for your time.
Conditional formatting in Report Builder is not in SP2. We are considering adding it to a future release.

-Josh
|||

I am interested in conditional formatting for ad hoc reports as well. Is this something that will be available in the SQL 2008 release?

Thanks,

Lisa