If the mirror is not in the same domain as the principal you must get the SID from the principal and manually add it to the logins used on the...

Go to MSDN and search for the article Replication and Database Mirroring. (Books online Sept 2007).

http://msdn.microsoft.com/en-us/library/ms151799(SQL.00,printer).aspx

I belive that is the link to printer friendly version....

Once again thanks for the helpful replies. Same as always.

I was able to use the 4 part syntax by creating a new link sever or whatever 2005 is calling...

Also, i tried to call the proc with recompile and put with recompile into the proc definition. No luck there either.

Note: I do not get any error just no update.

update :

Jsut to try, I used the declare @sql nvarchar(4000) tactic and packed the entire select * from openqery etc into a string and used execute sp_executesql

Nah, got it. Way too many rows were being called. the function does a basic random number routine. You can find that code just about anywhere....

well I hit the return key..here is the rest of my post. I am calling a function in a select statement. When I do the query just keeps...