Jon's approach is a great one for reducing the load on the server.

One question, when you do this, does the stored procedure recompile? I am curious if the CASE...

I agree there will be duplicate records. However as suggested above, this is a tradeoff. The join is a simple item and you can easily test for duplicate Staff records...

Interesting. Can you open this in the Data Transform task using the "preview"? Does it look ok?

Can you open them in notepad?

You might need to open and convert these to...

this will be tough to plan for. A few questions and suggestions:

1. How many users (concurrent and max) do you have now?

2. Is this a web based application now?

3. Do...

1. Always search for a SET oriented approach.

2. Smack developers who present you cursor solutions.

3. Have someone else look over your code if possible as a sanity check. This includes...

Thought this would work, but the table datatype (from bol)

table

A special data type used to store a result set for later processing. The table data type can be used...

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