Thanks Guys. That was helpful.

Thats the DDL for the source table

CREATE TABLE [dbo].[Channels2](

[Name] [varchar](50) NULL,

[ChannelRate] [varchar](50) NULL,

[MAS90ID] [varchar](50) NULL,

[SLXID] [varchar](50) NULL,

[CommPlan] [varchar](50) NULL

) ON [PRIMARY]

GO

Thanks Gail and SQLBalls for the info.

Thanks Gail.

My bad, I pasted the wrong sql. The correct select statement is pasted below:

exec sp_executesql N'SELECT

[Project2].[JobID] AS [JobID],

[Project2].[Name] AS [Name],

[Project2].[OwnerAppName] AS [OwnerAppName],

[Project2].[OwnerAppVersion] AS [OwnerAppVersion],

[Project2].[Pri] AS...

Thanks for the Quick response Gail. An EF generated select runs first which is as shown below:

SELECT

[Extent1].[Pri] AS [Pri],

[Extent1].[JobID] AS [JobID],

[Extent1].[Name] AS [Name],

[Extent1].[OwnerAppName] AS [OwnerAppName],

[Extent1].[OwnerAppVersion]...

Any ideas??

My MSDTC Trace log file is not helping much as well. Please post your valuable inputs if anyone has seen such issues. Thanks a bunch.

Unable to parse the MSDTC tracelog files in WIndows server 2008 R2 without these Tracefmt.exe and traceprt.dll.

And that number is 10/minute? 20/minute? 2000/minute? How are you judging that it is too many? Every time a connection is reusing a pool, it is executing this. So what...

Thats based on the count (number of times it appears in the trace file)

Sure John. I usually prefer the scripting approach as well because I can store them in my repository as they are changes to structure of a table.

Thanks

GSquared..That goes straight into my performance hit checklist.

Thanks much

Mystery Limbo and Lowell thanks for the info. I was not aware of this.

Cool...it warns me. It wont recreate the table just like that when I have data.

Thanks Lynn.