Not that I know, sorry

Steve Jones

steve@dkranch.net

you will have to be careful about permissions and for that reason I would not do it, but yes, you can

create trigger mytrigger on mytable for insert

as

exec master..xp_cmdshell 'dir c:'

Steve...

you'd do a join.

select *

from staff s

inner join

staff_pub_link sp

on s.staffid = sp.staffid

Steve Jones

steve@dkranch.net

Should be. The only thing that is bound to the old box is the sid, so if you had some service that relied on an ACL, you might have issues....

You should be abl to just connect using whatever method you want and giving the server name. The default might be for clients to use Named Pipes, but other than...

I'd vote log shipping, but honestly don't like either one.

Let me clarify with Replication is more mature and probably more stable. If you have an issue, it might be a...

np. glad you found it.

Steve Jones

steve@dkranch.net

Easiest? Backup/Restore.

Need more real time, then replication may be best.

Steve Jones

steve@dkranch.net

If your clients connect by IP, then yes. Most clients connect using DNS/Wins/NetBIOS, so you may not need to.

Steve Jones

steve@dkranch.net

If your clients connect by IP, then yes. Most clients connect using DNS/Wins/NetBIOS, so you may not need to.

Steve Jones

steve@dkranch.net

Strange. I don't have a good answer, but are you positive the old dev box and the prod box are setup the same? No "test" things done to the dev...

Can you give an example? It may be that there are carriage returns that are causing formatting issues in QA.

Steve Jones

steve@dkranch.net

Tend to agree with Andy, though I'd add that you would want a separate physical device for the ldf.

Steve Jones

steve@dkranch.net

A couple solutions:

1. Insert a value in a table using a trigger. Run a DTS package every 10 sec, check for new values and run the command

2. Use master..xp_cmdshell. It...

You can always CONVERT() the data.

Steve Jones

steve@dkranch.net