Why would you post this again?

http://www.sqlservercentral.com/Forums/Topic999572-391-1.aspx

edit: spam of the broken link!

Yes, I agree though..I would try to avoid using triggers whenever possible anyway, especially if there's a better way to do it (in this case,...

Depends which CPU you're coming from and going to (how many cores, speed, etc), if the RAM is any faster (moving from DDR2 to DDR3 for instance), the speed of...

Nice one Ken. Very elegant solution to this..I didn't think of grouping on the rowdiff.

You can, but that backup file is corrupt. Try to take another full backup and restore again.

Does someone (or you) have the file open?

Well...logically there would be no difference, but I've been using EXCEPT on all 2005+ queries and have had...

Wow...are they serious? The maxdop setting is essentially useless if set to something besides 0 or 1 on all versions of SQL 2008 prior...

Can you try this?

INSERT INTO InternalML.dbo.TempEmail

(Email)

SELECT DISTINCT

Ltrim(Rtrim(c.Email))

FROM AAService.dbo.Customers c...

Do you have leading/trailing spaces on the fields showing as duplicates? You could try doing ltrim(rtrim(t.email)) on the where not in clause.

When you select the objects to script out, select only Tables (and their dependencies..make sure you get keys, indexes, etc), then run that script on the new DB.

Something like this? :

CREATE TABLE [#test2](

[name] [varchar](20) NULL,

[id] [varchar](20) NOT NULL,

[country] [varchar](20) NULL,

[state] [varchar](20) NULL

) ON [PRIMARY]

CREATE TABLE [#costdetail](

[name] [varchar](20) NULL,

[cost] [decimal](20, 0) NULL

) ON [PRIMARY]

insert into #test2 values('j&j','1','canada','alberta')

insert into...

Or do

select top 10 * from syscomments

where text like '%spNameHere%'

to see if it's called from any other SPs.

Right click the db -> Tasks -> Generate Scripts

Actually there is:

select SERVERPROPERTY('Edition') as [Edition],

SERVERPROPERTY('LicenseType') as [License Type],

SERVERPROPERTY('NumLicenses') as [# of Licenses]

edit: disregard..apparently this doesn't work, since the installer no longer puts license info in the registry.