Viewing 15 posts - 37,381 through 37,395 (of 38,961 total)
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...
February 28, 2002 at 10:26 am
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...
February 28, 2002 at 9:46 am
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...
February 28, 2002 at 9:44 am
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...
February 28, 2002 at 9:40 am
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...
February 28, 2002 at 9:34 am
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...
February 27, 2002 at 4:47 pm
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...
February 27, 2002 at 4:43 pm
February 27, 2002 at 4:38 pm
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...
February 27, 2002 at 4:37 pm
you'd do a join.
select *
from staff s
inner join
staff_pub_link sp
on s.staffid = sp.staffid
Steve Jones
February 27, 2002 at 4:34 pm
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....
February 27, 2002 at 4:33 pm
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...
February 27, 2002 at 4:31 pm
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...
February 27, 2002 at 4:28 pm
February 27, 2002 at 2:48 pm
Easiest? Backup/Restore.
Need more real time, then replication may be best.
Steve Jones
February 27, 2002 at 2:45 pm
Viewing 15 posts - 37,381 through 37,395 (of 38,961 total)