I don't know that you can force the use of a full text index that way. You could, however, force it to use a specific execution plan. Look...

What are you using to load the database? SSIS and an SQL Agent job? Something else?

Have you tested the SP by itself, not as part of a package?

Ah. There are more requirements than just copying data. Got it.

You'll need to look into more of the options SSIS has for merging data without duplicating existing data....

Steve, I'm not sure how we would move the performance stuff to another thread. Copy and paste? Or should I copy and paste it into Word and send...

You'd have to build a table of months (or a full-on calendar table) and do a cross join from that to the locations, and then a left outer join from...

To do that, you're going to need to do something like this:

create table #Rows (

TableName varchar(100),

ColumnName varchar(100),

Rows int)

declare @sql varchar(1000), @Table varchar(100), @Column varchar(100)

select @Table = 'dbo.MyTableName', @Column = 'MyColumnName'

select...

Correct is "MacDonald", "van Dyke", "D'Angelo", but most people usually won't get upset by "Macdonald", "Van Dyke", "D'angelo". Those are wrong, but people are accustomed to the error. ...

There are lots of ways to automate this. It basically boils down to, what errors do you want?

For example, you can just Title Case every word (first letter is...

Open up BIDS (Business Intelligence Management Studio), start an Integration Services project, and drag your data transformation object onto the work area. Open that, add your sources, destinations, any...

Scott Anderson (1/27/2009)

---

I'm still up in the air about all this hybrid stuff...

I was at a dealer for car inspection and there was a Prius idling in the parking lot...

I've done this before, and I do recommend the upsizing wizard. It worked out quite well for me.

Are you sure you don't mean you want to create an SSIS package for that? SSIS pretty much replaces DTS in SQL 2005 and 2008.

iainthepitman (1/27/2009)

---

problem might be that your @z is declared as an int yet you're trying to set it as a string. if @z is supposed to be a character...

That's fine. You just can't do it that way in the Exec command, like you have in your proc.