the load is almost the same. The data on PRD is not more than 5-10% of TST. Infact a few days ago everything was okay.

What comparison tests can be...

ok just a clue, I have installed sql2005 express. I think ssis is not the part of it. If not, then how can I add ssis.

That is actually the help I need.

When I run the profiler a lot of junk information scrolls through the screen, however, I just want to filter my profiler on...

Thanks Jeff,

but its about bringing the data in a new table in sql. what if we want to append the data to an existing table.

Thanks Andras

It works.

When run through query analyzer the following query gives me the correct results:

Query:

select Task Task,coalesce(cast(Added as varchar(10)),'') Added,coalesce(cast(Updated as varchar(10)),'') Updated, [Time] [Time(ms)], Message Message from MyTable

Results:

Task Added...

Thanks R2ro

Appreciate your support.

Mark, I need to capture the error message alongwith all the variables. I want to record this message in my table ErrorsTable along with message number.

sysmessage table gives me...

Thanks R2ro

Thanks Greg, Its working for me.

Thanks Ramesh, It works fine.

I want my complete table 5X5 printed by select statment other than the nulls. as of now only the first row contains the null values in two columns.

Ramesh

as of now I have only 5 rows in my table and only the first one contains null values in Added and Updated columns.

In worst case I may have...

select top 1 Task Task,coalesce(cast(Added as varchar(10)),'') Added,coalesce(cast(Updated as varchar(10)),'') Updated, Time [Time(ms)], Message Message from MyTable

The columns Added and Updated have null values in the first row while the...

Thanks Ramesh/Andras Your solutions worked fine, but they are only good for the first row of the table, What about the other rows. All the records are not null.