That won't work because instead of -2345.00 it should be -23.45 at least according to what the OP said.  Of course, having just said that I realize that as long...

That's a good point, I was basically assuming that all the other restriction clauses used in generating the SP's result set would be included in the INSERT, but I didn't...

Since you are doing DELETEs the Bulk-logged model will not help.  The only operations that benefit from that recovery model are BCP and BULK INSERTs.

Setting the recovery mode to Simple will have no effect on performance since the DELETEs are still fully logged. 

No, you can't place the log file on a NULL device SQL...

The simplest method of moving DTS packages from one server to another is to open the package in designer and under the "Package" menu select "Save As" you will be able...

I have to say that after reading some of the comments posted at those weblogs I feel dummer for having read them   Those...

Well it's ugly but it works assuming that the right two digits are always supposed to represent cents.

declare @vchar varchar(10),

  @Dollars varchar(10),

  @Cents varchar(10),

  @Amt varchar(11),

  @Money money

set @vchar = '-0001234'

set @dollars = (left(@vchar,...

Is your new instance running at the same release level (SP and Hotfixes) as the original?

For SQL Server 2000 you must be sysadmin to run Profiler.  There are several reasons for this, Profiler can show a great deal of information about the data and the...

I usually use Query Analyzer's Object Browser, find the view (or any other object) right click on it and select one of the scripting options available there.  You can also...

It doesn't make much sense to me, but I'm not familiar with your system and its requirements...  Based on what you told me I would just throw in a simple...

Actually that might make it real simple.  But before I can tell I need to ask a few more questions:

Do you want the audit records to be written only when...

Do you want to write the record only if a record CC_Type = 50 appears in the result of the stored procedure or do you want the record written if...

Sure you can.  You need to have the appropriate Oracle ODBC driver installed on your server, configure your Linked Server and make sure that RPC is checked on the Server...

...just to expand on rockmoose's comment.  IDENTITY columns in and of themselves are not meant to ensure uniquness, but by not reseeding the value and using a unique constraint (or...