Wayne i thought the OP was running into the fact that...

I don't see an advantage to not copying the functions to the new server's master database.

Cross database functions with a synonym are going to be slow, and have an additional...

you can always connect to the tempdb database and run your scripts; your objects will not have any impact anywhere.

i would simply install a local SQLEXPRESS on my own development...

Mac:

CREATE TABLE definition?

the actual [Account_Code_AK] values for one of the items that is duplicated so we can see?

names of the tables that reference that alternate key?

Mac we probably need a little more info...does the table for Account Code have an identity/primary key, in addition to the two columns you showed us? are their foreign keys...

here's another example i posted that has additional logic, and check out the thread it came from for more info:

http://www.sqlservercentral.com/Forums/Topic927131-359-1.aspx

in this case, i'm trying to prevent SSMS and also...

oops..

forget the cursor, you can and should do this with a single update:

UPDATE SOMETABLE

SET new_date = start_date

WHERE new_date <> start_date

AND status <> 'reopen'

here's an example, but i don't think you can generate then column names dynamically this way(i know you will ask that!)..i think the AS 'Val' + RN will not work.

;with...

the answer is yes and no.

once I have a username and password, I'm good to connect with anything i can get my grubby fingers on...SSMS, a program i write, Access,Excel,...

great job on providing the data we need to test.

rows to columns and columns to rows is probably the single most asked question on the forum; i bet there are...

I don't think that will not work. Outlook.exe accepts no exposed command line arguments, so you could not automate it like that, i think.

what's wrong with opening a new email...

did you create linked servers to them yet?

once the link exists, it's nothing more than referencing them with a 4 part name:

SELECT * FROM LinkedServerA.databasename.dbo.TableA myAlias1

LEFT OUTER JOIN

LinkedServerB.otherdatabase.dbo.TableB myAlias2

ON myAlias1.Id...

http://aspadvice.com/blogs/rjdudley/archive/2005/05/13/2589.aspx

his first reason is my first guess...either the db...

ugg... i'm thinking that the same trigger in multiple databases will cause locking as soon as DB1 updates DB2 and fires the DB2 trigger, which in turn wants to update...