Right, I'm just looking for the month, day, and year to match up. Using your format would the function GetDate() and the data-type datetime for Holiday_Date be comparable using the...

thanks guys, how's this look. I'll just set a job to execute this code. The spoc is cnvflag.

BEGIN TRAN

DECLARE @holiday VARCHAR

SET @holiday = (SELECT * FROM Holidays WHERE HolidayDate =...

thanks for your help. I appreciate it.

-pat

any ideas on how to get server name, dbname, DB owner, and version?

thanks jody, that was great help. I'll give that a go. Also, good tip on the sql accounts. Thank god for this site and the people on it.

-Pat

I'm sorry. Did you mean the server alias set up on both sides as well?

Thanks, Jody. So, by setting up a named-alias, and its parameters including IP address and port number, I could reference this name in sp_addlinkedserver, or in a dts package and...

here's the setup. Server A, is located at building A, within a private network. A third party points the public IP to one of our private LAN addresses. Server B...

quick question. is log shipping available only in enterprise edition, and not standard?

Thanks for responding so quickly guys. As I understand it, log shipping would make the off-site DB read-only, whereas transactional replication would enable the DB to be written to and...

Thanks steve. That's just what I was looking for. That works fine. I was trying to make it too complicated. Any opinion on the dts package. I am dropping and...

thanks for replying steve. I must have had brainlock this morning. I just need to update the columns in each record with matching primary keys, not update the keys. However,...