I tried that before and it kept giving me an error when I ran the create code on the new server. For some reason I had to remove the...

hey thanks for the tip. I did download and install that and it looks like it will generate the script to copy the data over but it does not...

no its just not there. I think I have the free version of the management studio.

thanks for the replies - that would definitely be nice and easy but unfortunately i dont have that option when I right click.

I have actually already uninstalled everything SQL server or visual studio related. Thats why i am kind of stumped on how to get rid of it.

did you ever resolve this? I am having the same problem.

yea we are a large company - the network/DB guys have a sql cluster set up in the server room. that's what i am accessing with my current version...

the other datasource is some other obscure 3rd party database. not sure what exactly it is - i will find out this afternoon when i meet with my boss.

and...

hey thanks for the info but i don't seem to have that option.

if i right click and go to tasks, all i have is Detach, Shrink, Backup, Restore, and Generate...

worked like a charm - thank you!!!!!!!

well i think were getting closer...

now i get the following:

Executing: Update T

Set , [Title] = Replace([Title], '"> <!--', '')

, [description] = Replace([description], '"> <!--', '')

From dbo.itaps_RAENS T

Msg 170,...

ok so i tried running it from a new query window and i get the following messages:

Msg 170, Level 15, State 1, Line 1

Line 1: Incorrect syntax near 'max'.

Msg 137,...

no i am not using the view designer - not even sure how to get into that. i...

rbarryyoung (8/18/2008)

---

All you need to do is modify the DECLARE statment:

Declare @sql AS varchar(max)

Set @sql = 'Update T

Set '

Select @sql = @sql

+ CASE When ORDINAL_POSITION = 1 Then...

rbarryyoung (8/18/2008)

---

Yes, it does matter, and yes you should have mentioned that before. ...