Which version of SQL? I believe with v7 and 2k, this is always present. So when you add a login, you choose an NT login rather than a SQL login...

Just a vote for Andy's solution.

Steve Jones

steve@dkranch.net

I believe you need to be a sys admin, but it might work for a db owner. You need to use integrated security (Windows Auth) if you want someone other...

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...