AllIcansuggestispostthenexttimeyoucopypasteyourcodeusingCODETAGESavailablebeside.

Cant understand what's that above?

Now looks at this

All I can suggest is post the next time you copy pste your code using CODE TAGES available beside.

That's what you have...

Use This

SELECT TOP 2 AppName, Date, Query FROM YOUR_TABLE

GROUP BY AppName, Date, Query

That's what I meant in my last reply.

In the Query Editor,

Use this

USE

[NDP-MWD]

SET IDENTITY_INSERT [NDP-MWD].dbo.[Comments] ON

INSERT INTO NDP-MWD.dbo.Comments Select * FROM NDM-MWD.dbo.Comments

SET IDENTITY_INSERT [NDP-MWD].dbo.[Comments] OFF

Steve is right. You should not use SCOPE_IDENTITY, instead use Inner Join to get the corresponding value for each record.

Trying to figure out without the table structure and some sample data would be difficult.

I encourage you to post the create table scripts and also some sample insert scripts (5-10...

Use the Following Script

INSERT INTO NDP-MWD.dbo.Comments Select * FROM NDM-MWD.dbo.Comments

You need to take additional care if there...

Right Click on your SQL Instance and select Properties.

In the very first dialog, you have the last property Is Clustered . A TRUE Value Indicates it is clustered a...

Gail is right with her reply.

You posted a question

which should have been searched in a...

Seems to be crazy but I ran the same query without the

WHERE Convert(varchar, Date, 101) = '11/13/2009'

and got the result what you wanted.

It will not create...

Good Question Flo and wonder if someone would use that many Parameters.

It is 2100 Parameters, not sure if it has been increased in SQL 2008.

Can you try this

Copy the DTSX Files from the ServerA(2005) to ServerB.

Go to the ServerB(2008) and then create a new solution and try to add the packages into that solution.

Hmm Seems to be strange, have not got an idea what does it alter?

Any way have you tried to rerun that job?

What is the script you have?

Post it here.

Without that we have to do guess work on your script...