If you want to track changes ... you need to first check whether its insert, update or delete.

If insert the inserted table only will have record... if delete... only deleted...

Yes exactly... the sysindexes might not have correct values in all the cases.

I think you better use...

The code you provided is not sufficient. Please provide full code so that we can try to...

select object_name(id), rowcnt from sysindexes where id in (select id from sysobjects where type = 'u') and indid = 0

Use the above code.

IF NOT EXISTS(SELECT NAME FROM SYS.COLUMNS WHERE NAME = N'OPTION'

AND OBJECT_ID = OBJECT_ID(N'MARKS_SHEET'))

BEGIN

SELECT @sql= 'ALTER TABLE...

Using the same DB... I mean without using backup ... we cant restore a stored procedure to the previous version.

As Gail Shaw mentioned if you have backup of the...

You cant achieve this using only ssrs

I think you have not selected bids while installing.

or what you can do is install bids from sql sever cd.. it will definetely install bids.

If you have already installed vs2005...

Are selecting column names from information_schema.columns?

Try running only that query which is getting you the column names. Check whether is it returning column name.

Try running the query part by part...

Yes I think it may be the case.

Try this code

create proc test

as begin

return 1

end

GO

create proc test1

as begin

declare @a int

execute @a = test

print @a

end

execute test1

Here...

Refer following code:

declare

Yes Anoop, please explain it further.

If you want get object_name using object_id.

you can use the following command

select object_name(object_id)

ex:

select object_name(1000)

It may due to concurrency.

If you are selecting the data from the server and at the same time some insertion is happening then the new inserted row wont be reflected...