This is an example of reading the registry

EXEC master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\Setup', N'SQLDataRoot', @local_backup_Dir OUTPUT

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

You can use xp_regread to read the registry and BULK INSERT to import the delimited data.

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

You can use SET ANSI_NULLS OFF which will evaluate NULL = NULL as true.

You should also not that your query will not use any indexes, because it does not know...

How is your data modifed i.e 10% inserts, 20% updates, 5% deletes?

How big are your tables, do you have fillfactors set?

Have you monitored for pagesplits, high values indicate you need...

Not likely, what makes you think it is not correct.

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

An logon and logoff should only occur when the connection closes, I am suprised that you are finding this.

It is likely that after a while of no use the connection...

Which country?

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

I don't know. Taking our jobs, and you can't even be bothered to come over here

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

Use profiler to log logins and logouts. These can be logged to a table in your database.

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

This is not dynamic sql so you do get caching. There is an issue where you have an SP and you pass it very different values for the same parameter....

Also be aware that col3 + 'x' will be NULL if col3 is NULL unlike in 6.5 where it would be 'x', you might want to include ISNULL(col3) + 'x'

Simon...

The simplest is to catch the reads, writes, cpu and duration from profiler.

If you added the correct indexes then these should all reduce. The smaller the numbers the better the...

I think you have it. Can't see any other reason why it would do it.

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

The one (dbcc reindex) actually reindexes the table, i.e physically moves the data around so that it is ordered correctly, a sort of de fragmenation.

Update stats does just that updates...

Try reapplying the latest service pack.

Can you run

select * from ::fn_listextendedproperty(NULL, N'user', N'dbo', N'table', N'ByProductsData', NULL, NULL)

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088