Steve..first of all..can this be done using procedure?

No problem even if its tough to do this...but i want to know.is this really doable in a proc?

am not sure the table names and clolumn names in each table. This new program should handle all..If Proc p1 returns 3 record sets, new program should be able to...

Tried that..It doesnot work.. Can anyone help me here...

Thanks AlzDBA ..

Can you please explain "how the result can be anayzed by looking at Total_accesses, Seeks,Scans and lookups"?

I gues..This is going to be big learning for me...

Regards

Jus

Developer edition..

I checked all prerequisites. all are fine.

--Jus

Infact i do not know any tool / methodology which can measure / calcualte the performance hit with the specified number of events.

Is there any tool available to tell...

Thanks Elliot...Can you please update me once you done with your solution.

Regards

Jus

Thx..I will take care of that...

Roy / Umar:

Does the following script good enough to serve the purpose or does it require any changes?

select distinct a.id,a.name,b.name,d.name,b.type_desc from sys.sysobjects a

inner join sys.syscolumns d on a.id =...

Thx Roy....I will look into it...anyway..if you have proven script with you..can you post it here....

First option is not possible, because prod environment is not in my control.

Second, I will be getting the backup file only from production, nothing else.

Any changes can be performed in...

No. my question was......If you take the differential back up second time after the full backup, will it (second differential backup file) be holding the data changed after the first...

Hello GSquared..

Wonder is that when i ran your code it works...but in my db, it returns no records...

--Jus

I am sorry for not providing data lynn.

Data is a follows.

INSERT INTO testcases ([testcase_id],[ScenarioName],[scenario_category],[expected_bundles],[expected_promotions],[on_order],[on_profile],[Change_to],[creation_date],[user_name])

VALUES ('2737','[Change5]-[Existing Customer]-','Change','','AutoAdd: 1.24 M PL ','','FE / FDV + Data + Video Triple','FE /...

DDL:

CREATE TABLE [dbo].[testcases](

[testcase_id] [int] IDENTITY(1,1) NOT NULL,

[ScenarioName] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[scenario_category] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[expected_bundles] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[expected_promotions] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[on_order] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[on_profile] [varchar](max)...