SSMS Right-Click Modify selection issue?

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

I've never seen it do that.

I tried looking for an option that might do something like that. All I can say is play around with the scripting options a bit, see if one does that.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 2

Are you sure you are not using the Script To option in the menu?

If you are:

Go to Tools -> Options -> Scripting

I think it is the "Include IF NOT EXISTS" option that is doing this to you.

Just verify the scripting options are the same on both machines.

Some of these settings make some pretty ugly scripts for you

Jack Corbett SSC Guru Points: 184394 More actions · Answer 3

Thanks guys. I thought about messing with the scripting options. I'll have to compare them on both machines.