Just execute an ALTER DATABASE staement, like this:

ALTER DATABASE databasename

SET SINGLE_USER

There can't be any users logged on to the database in order for you to execute this statement, but...

quote:

---

There is some prilimnary work going on with documentation and should begin in mid september.

---

As...

EXEC sp_spaceused 'TABLENAME'

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

My guess is that this has to do with how Excel names it's 'tables', SQL just use the name that Excel recommends. Naming the tables manually would solve the problem.

Chris...

Use COALESCE or ISNULL, like this:

COALESCE(a.company,0)

or

ISNULL(a.company,0)

This way, if the value in the column is NULL then 0 will be used for the comparison.

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

This is probably caused by the optimizer deciding that a clustered index scan checking each rows value in c2 will be as quick as first going to the non-clustered index...

Clive, you said there where no indexes on the table. I guess that includes clustered index, i.e. there was not a clustered index on the table. If so, did the...

quote:

---

By giving db_ddladmin are there any security implications?

---

Definately, that means the user is able to...

Either use the SQL Server 2000 Setup and choose uninstall, or use Add/Remove Programs in Control Panel.

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

quote:

---

This is because product number 965004876 has the largest stock and order volume.

---

OK, so then...

Thanks for the input guys.

Scott: Yes, they result in the exact same behaviour and execution plan. SQL uses the best index available to it.

Greg: Absolutely, the fastest way of getting...

Store your data in a nvarchar column instead of a varchar. That should do the trick for you.

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

I'm not entirely certain how to translate the business req. "largest stock and order volume", but I chose to translate it to A_STK + A_ORD. If that's correct, then maybe...

Depends on how you are trying to do this. If you're using ADO to insert it into a table or something, check this KB out:

http://support.microsoft.com/support/kb/articles/Q258/0/38.asp

Also, if you're just doing it...

quote:

---

What are DBCC commands?

---

DBCC CHECKDB for instance checks your database for allocation and consistency errors.

Are...