Viewing 15 posts - 4,066 through 4,080 (of 6,216 total)
And then depending on what you're doing, decide if it shouldnt be a permanent table to start with. You can use the spid to identify records inside a permanent table.
Andy
June 7, 2002 at 8:19 am
Should be the lifetime of the connection or of the proc, depending on how used. If you create one inside a proc it gets dropped on exit (though I code...
June 7, 2002 at 8:16 am
Nope, not a a good idea. For production you don't people being able to do things like truncate the employees table by mistake.
Andy
June 7, 2002 at 7:42 am
I'll have to disagree that using app role is better - wouldnt you think that most development will take place in EM or QA?
Andy
June 7, 2002 at 7:41 am
It also will vary widely depending on both your definition of a "transaction" and the complexity of said transaction, combined as Antares mentioned with hardware plus how well tuned the...
June 7, 2002 at 6:30 am
The first solution should work, the second is "better" depending on your overall requirements. I'd suggest profiling to confirm what is being actually executed. Is there a chance you have...
June 7, 2002 at 6:27 am
June 7, 2002 at 6:24 am
Im not sure if upper would rule out the index or not - you'd think it would only matter if the column(s) in the index were case sensitive. Using portions...
June 7, 2002 at 6:23 am
BOL is not bad, but by far the easiest way is to set up trace in Profiler and then save it out as a script file. That will give you...
June 7, 2002 at 6:23 am
ADO tends not to like it either - not sure its 100% consistent, but I've seen a lot of cases where it misinterprets the nocount message as a recordset with...
June 7, 2002 at 6:20 am
Dont know the answer. But a good alternative is to make them use QA. EM is good for administering, not great for editing.
Andy
June 6, 2002 at 4:24 pm
Tell me that isnt a design flaw! Running a package should execute it entirely on the server. I can see having the ability/option to offload the processing, but when I...
June 6, 2002 at 4:23 pm
I agree that they dont need access. Job makes sense. No reason they cant start the job, if nothing else indirectly by having the job poll a table periodically, they...
June 6, 2002 at 4:21 pm
June 6, 2002 at 12:49 pm
I agree. You can use sp_addlogin to help in the process, has a switch to pass that indicates the password is already encrypted (which you would get from server a).
Andy
June 6, 2002 at 12:48 pm
Viewing 15 posts - 4,066 through 4,080 (of 6,216 total)