Yes, it is offhours but not in single-user mode.

Steve

Not quite sure of what you want to do.  But to return the Identity value you can you @@IDENTITY or Scopy_Identity() after  your insert statement.  Like this

For me, what would be interesting is people responding with their best practice to solve this situation. 

Here's what I think,

The DBA receives from Development the scripts to update...

Reese's Peanut Butter Cups... and many of them.

This is not to confuse the original post-er. 

I ran the example above on Query Analyzer connected to SQL Server 2000 and then on the same machine Enterprise Studio connected...

Here is a sample of the two options

CREATE TABLE [dbo].[T_Money_Test] (

[ID] [int] IDENTITY (1, 1) NOT NULL ,

[moneyField] [money] NULL ,

[DECField] [DECIMAL] (10,2)...

I agree Money is the way to go.  Float is just trouble should be used only for Scientific data and even then maybe.  It seems Microsoft put Money datatype in...

What is the application?  What does the column represent?

Steve

We are a very small shop and SQL Server 2000 is very stable.  There is no compelling reason to convert.  At this point - no plans - no budget.  I...

Can you redefine the column to be type datetime.  It makes calculations simpler.

The article you posted although interesting is for SQL Server 2005.  Is there anything like it for 2000?

Steve

Thanks Matt... I had thought of DTS, but I would have to pass the Path and Filename from the Access Application to the DTS Package.  Is there a method to...

My Colleague, who I still owe a dinner, came up with this solution (I just coded it) But we both like the previous one...

SELECT