Thanks Guys

I alreadyupdated statistics during the time of migration.

The schema for the object are detailed below.

CREATE TABLE [dbo].[PersonProfile](

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

[PersonURN] [varchar](30) ,

[SourceCode] [varchar](1) ,

[SourceCode_Updated] [varchar](1) NULL,

[CP_Service] [varchar](100)

)

GO

CREATE...

Thanks guys, I did think about computing the columns instead of using the substring functions as well, but if you look at where the substrings have been used, you will...

smunson (11/12/2008)

---

As CLR should in most cases just not be necessary, one way to help with it's memory usage would be to ensure it's only used for scalar functionality, which...

Hi Guys,

Yes, I mean a UNC path either directly or mapped onto a computer, not sure which one will be easier but just one way or the other really.

thanks.

kendal.vandyke (11/20/2008)

---

I agree with other posters - sounds like what you need here is a dedicated distributor. Moving distribution responsibilities off your core server will HELP performance because you're transferring...

Hi,

Thanks for your...

Perry Whittle (11/12/2008)

---

if you have 4GB RAM or over you need to enable AWE for each instance. What version OS do you use and what version SQL server. You should...

winash (11/11/2008)

---

What kind of memory pressure errors are you seeing in the SQL error log? Are you using CLR TVFs, SPs or UDTs?

Have you applied SQL Server SP2? (there were...

Hi Guys,

When i did try to run it now, here are the errors i am geting.

Msg 107, Level 16, State 2, Line 2

The column prefix 'IC' does not match with...

thanks for your reply, I have added the +, but i am still geting errors. can someone help please ?

Hello

below is what i tried to run..

DECLARE @searchSQL AS VARCHAR(4000)

DECLARE @SearchItem AS VARCHAR(4000) ; SET @SearchItem = '%SEARCHSTRING%'

+ CAST(COALESCE(MIN(CASE WHEN IC.Ordinal_position = 2 THEN ' OR ' + IC.Column_Name...

Thanks very much for the reply, can you please do me a favour by puting the script together as I keep geting errors whilst trying to do this.

thanks.

Hi,

I didnt quite get the insert/exec idea, do you mean save the results in a table ?

The problem is the results that I expect back can be in different formats.

Thanks

Its simple, but i am looking at changing this to provide us with more backup options.

Hi

I have tried moving the files onto various paths, both local and also on the network to no avail.

Also, SQL version is SQL 2005 SP2

MDAC version (When i tried using...