Recent content by denimblue

I'm running ARCserve Brightstor version 9 on Windows 2000 server. Under c:\ProgramFiles\ComputerAssociates\ARCserve\DATABASE resides a file Astpsdat. The last time this file was modified was 8/26/03. Is it safe to delete these files? My server is tight on space and one file is 907,776kb.

I have been doing the below statement to populate a column called &quot;o_rowid&quot; with a number. The table &quot;AP_Dept1113&quot; has over 80,000 rows of data. After I do an import into this table this column is <NULL> where the new data is. It has to have a row number to accomplish...

Already resolved, Thank you.

How do I get rid of dup rowid's without looseing the data and where did I go wrong to make this happen?

This is what I did Imported new data 4099 rows They import without a rowid assigned I performed the following: declare @currrow char (10) declare @counter int declare @numrows int declare @numrows2 char (19) declare x cursor for select count (*) from AP_Dept1113 open x fetch x into @numrows...

I discovered that I have duplicate rowid's in a table. How can I fix this?

I just did an import into an exisiting table with rows of data. I now have my new data in the table (no rowid assigned). I'm looking for a simple rowid update query.

How do I change a column name in MS SQL 7? I have data in two columns reversed. Can I change the column names or do I have to move the data? Can anyone assist with the proper sql query statement.