Registry Entries

[Ola B]

Below are the registry entries I want to update but "Trusted_Connection" = "Yes" does not seem to have any effect when it is run. Any ideas??


REGEDIT4

[HKEY_CURRENT_USERSoftwareODBCODBC.INIAAED]
"Driver"="C:\WINNT\System32\sqlsrv32.d ll"
"Description"="AAED"
"Server"="SIM0108"
"Trusted_Connection"="Yes"

[HKEY_CURRENT_USERSoftwareODBCODBC.INIODBC Data Sources]
"AAED"="SQL Server"

[Keith]

Hi,

Can you tell me if these traceflags (302,310 and 317) are available in SQL Server 2000 ? I think they were available in SQL 6.5 and we use them in Sybase for:

302 - estimates a cost of using particular index
310 - estimates cost of performing a join
317 - rejected join plans are printed

I have searched all over for these in SQL Server 2000, and have not managed to find anything. If these traceflags are not included in SQL 2000, what are the alternative methods to find out the information.

Many thanks
Keith

[Navneet]

They do work in sql 2000. Go here fo more info.

http://www.sql-server-performance.com/rd_traceflags.asp


------------
Keith at 7/26/2002 12:20:06 PM

Hi,

Can you tell me if these traceflags (302,310 and 317) are available in SQL Server 2000 ? I think they were available in SQL 6.5 and we use them in Sybase for:

302 - estimates a cost of using particular index
310 - estimates cost of performing a join
317 - rejected join plans are printed

I have searched all over for these in SQL Server 2000, and have not managed to find anything. If these traceflags are not included in SQL 2000, what are the alternative methods to find out the information.

Many thanks
Keith