So why it is called that Include column does not increase non-cluster index size......

you all are correct,

but I want to know the usage of 251-255 these id used by indid column in sys.sysindexes....

Hi

I had tried all possible options but relult is same.

And its due to using single line comment for multiple lines.

What is the cardinality between two tables.

If M:M then use a juncture table.

Any Suggestion

Thanks for reply.

I create a MDW to capture different type of event on a central server, But when I view report, it show detail on one server only. Can you...

Thanks a lot

without table name its works.............................................

Thanks to both of you for quik responce.

Actualy I already have a DDL trigger that capture all DDL in database.

But issue with this is that anyone can disable this trigger...

Thanks,

Query is running but I have two concern.

1-- TextData column is null

2-- If I am diable/enable triger that event is not captured in default trace.

Thanks a lot,

I am not part of DBA team so i can't view that folder.

Is there any other way to track this history.

Thanks

KD

my be you are deleting records

if so the run dbcc command

Thanks.

Can we do same in Sql Server or in SSIS directly.

If column is Numeric then frist convert to varchar(8)

Alter table <Table name> Alter column <COlumn Name> varchar(8)

I had fix the problemmm.

As per my understanding we can't alter a datetime column directly into numeric type. So I convert frist into varchar(8) then to Numeric.

Thanks for your reply..................

Thanks u all

problem is solved