Glad to hear it worked!

in the code the HTCD column doesn't need a datatype because its value is constructed on the fly by SQL Server: the AS RIGHT('0000' + CAST(LogID...

true, but that does have security implications. using no owner name uses your current security context.

Easy!

Put Databasename.. before the table name... eg:

use dbB
GO
IF Exists (Select count(*) from dbA..TableA Where dbA..TableA.ID = 100)
Select * from TableB
Else
Select * from TableC

or example 2

Select * 
  from dbA..TableA...

Antares is right. If your database is that small, and does almost nothing for most of the month MSDE should work fine for you.

MSDE is a cut down, free version...

A Computed column would work perfectly. You need the two parts of your number (XXXX-YY) to be columns in your table. XXXX comes from your existing ID, YY would need...

Glad to hear it worked JD.

IDENTITY columns are best set as INT datatypes, a simple data type and theres plenty of room to grow.

In almost all tables you will need...

Ah ha. What else happens on your box / sql server at that time? Are you running backups? Do you have anything else scheduled to run in SQL Server, SQL...

If you are using a MONEY or SMALLMONEY currency data type in the database, it depends on your Locale / Region settings in the application.

For a ASP / ASP.Net application,...

Hi JD

The correct way to setup a primary key / ID field is to create a new column with an INT datatype, and turn on IDENTITY for the column. When you...

Hey. Why are you using Group By? The only time you need to use Group by is when you are using Aggregate Functions like SUM() COUNT() MIN() or MAX().

If your...

As always, unless you've melted the hard drive down, it's still there.

SQL Server may 'release' the datapage, but until something else is written over the top of it, it's...

How big are the databases you are planning to put into SQL Server 2000?

How complex are the queries you will be performing in SQL Server?

How quickly do you want SQL...

I'm not certain, but from your statement above everyone may be missing the point of this.  If you have five users and they all need to see the next available...

Windows Performance Monitor will help you out with tracking the stress of the hardware / os / sql server. There's some great articles on this site that cover performance monitoring.

As...

SQL Enterprise Manager and Query Analyser are both management tools. Not data reading / writing tools (though they do let you).

As rchawdry said, you'll need to use an external...