Or that ...

This definitely needs to be thought thru before committing to either solution. Here is the way I see it from the db design and continuity of business perspectives:

1. Separate...

From MSDN:

Segment http://msdn.microsoft.com/en-us/library/ms180774(v=SQL.100).aspx] is a physical and a logical operator. It divides the input set into segments based on the value of one or more columns. These columns are shown...

Steve,

That is actually not that difficult with the correct T-SQL functions:

Substitute :

rtrim(vendor) + replicate(' ', 7-len(rtrim(vendor)))

for your RTRIM(VENDOR) to get the 7 character vendor code regardless of the incoming vendor...

Thanks Pradeep. That would not really work, as the script name would have to be 1st) inserted into the table, 2nd) retrieved with a query using WHERE criteria to...

I had to know as well:

Oracle(r) Enterprise Manager Introduces Systems Management Capabilities for Microsoft .NET Framework and Microsoft Windows Server System

New Plug-Ins Enable Customers to Reduce the Cost of...

Yes, we are using a SAN.  Also, the SQL server 2000 does have the SP4 installed from the beginning.

I implemented the suggestion Clive Strong provided. It's been nearly two weeks and I have not received the same error yet. I used to have to rebuilt the index at...

I've been using "2. Get row count from all Tables" for some time now to monitor the size of tables and their changes over time.  Today, I noticed that some...

OK, not all with data types was fine.  Thank you govinn, I'm going home now.  It works great.

Jan S.