I think my table is corrupt, if it is there something I can do to fix it? Here is the story....

I have several tables with auto increment rowids that if you bring the server down hard (pull the power); on power up the rowids jump from something like 23099 to 100000000000000000000000000000000000000001.
Code:
(see post releated to this http://dbforums.com/showthread.php?t...light=timmoser)
Well we had a server guy reboot the server one night without contacting me so I can bring the DB down. Now I have an SP that when selecting from a table I get the records I expect to get, however, if I run the SQL directly on the table (without an SP) I don't get the records.

Seems as though the records are in the table but I can't see them without the compiled procedure.

This is an example of what is going on....

I run this SP
Code:
CREATE PROCEDURE dbo.s_it_sv_tc_get_userinfo
@uid CHAR(10),
@typeofinfotoretreive CHAR(10),
@rowid NUMERIC(18) = 0
AS
    BEGIN

   	IF @typeofinfotoretreive = 'USERDATA'
	BEGIN

     SELECT b.rowid, RTRIM(b.dept_number) AS dept_number, 
			RTRIM(b.business_unit) AS business_unit, 
			RTRIM(b.first_name) AS first_name, 
			RTRIM(b.last_name) AS last_name,
       		RTRIM(b.address_1) AS address_1, 
			RTRIM(b.address_2) AS address_2, 
			RTRIM(b.city) AS city, 
			RTRIM(b.state) AS state, 
			RTRIM(b.zipcode) AS zipcode,
       		RTRIM(b.contact_phone) AS contact_phone, 
			RTRIM(b.email) AS email,
			b.checkaddress, b.completed, rtrim(b.useddg) AS useddg
  	FROM it_sv_tc_userinfo b
 	WHERE b.uid=UPPER(@uid)
 
	END
	ELSE
	BEGIN
	
	IF @rowid = 0
	BEGIN
 	SELECT a.rowid, RTRIM(a.uid) AS uid, 
			RTRIM(a.device_type) AS device_type, 
			RTRIM(a.d1_owned) AS d1_owned, 
			RTRIM(a.service_provider) AS service_provider,
		 	RTRIM(a.device_mgf) AS device_mgf,
     		RTRIM(a.device_model) AS device_model,
		     RTRIM(a.device_number) AS device_number, 
			a.avg_monthly_mins AS avg_monthly_mins, 
			RTRIM(a.expense_report) AS expense_report,
	    		RTRIM(d1purchased) AS d1purchased,
    			RTRIM(deviceowner) AS deviceowner,
    			RTRIM(useddg) AS useddg,
			RTRIM(devicepin) AS devicepin,
			iscontract, contractexp, termcost, termchange
  	FROM it_sv_tc_device a
 	WHERE a.uid=UPPER(@uid)
	END
	ELSE
	BEGIN
 	SELECT a.rowid, RTRIM(a.uid) AS uid, 
			RTRIM(a.device_type) AS device_type, 
			RTRIM(a.d1_owned) AS d1_owned, 
			RTRIM(a.service_provider) AS service_provider,
		 	RTRIM(a.device_mgf) AS device_mgf,
     		RTRIM(a.device_model) AS device_model,
		     RTRIM(a.device_number) AS device_number, 
			a.avg_monthly_mins AS avg_monthly_mins, 
			RTRIM(a.expense_report) AS expense_report,
	    		RTRIM(d1purchased) AS d1purchased,
    			RTRIM(deviceowner) AS deviceowner,
    			RTRIM(useddg) AS useddg,
			RTRIM(devicepin) AS devicepin,
			iscontract, contractexp, termcost, termchange
  	FROM it_sv_tc_device a
 	WHERE a.uid=UPPER(@uid) AND rowid=@rowid

	END
	END
 END
I run it like so:
Code:
s_it_sv_tc_get_userinfo 'S69776', 'USERDATA'
I get this back:
Code:
10000000000000000000000000000034	0432	Head Quarters-Other	Tim	Johnson	[NULL]	[NULL]	[NULL]	[NULL]	[NULL]	610-296-6210	tim.johnson@emial.com	N	[NULL]	Do not use DDG	N	X	X	X	N	N
I run the SQL:
Code:
SELECT *
  FROM dbo.it_sv_tc_userinfo
And this record is not there.

Another thing I did was copy the table to a development server when I did this I got no results with the SP but the same results with the SQL.

Thanks in advance for your thoughts on what is going on.