Viewing 15 posts - 4,966 through 4,980 (of 6,216 total)
I think you'd be better served to use a view to tailor the presentation. IMHO. Making these kinds of changes can wreak havoc depending on what is coded against them....
February 8, 2002 at 8:18 am
Not clear on why you have so much work to do. Regardless of where you get the value from you still have to do conditional execution, right? I think if...
February 8, 2002 at 8:14 am
So you KNOW the recipe for Aunt Martha's sauce? I have the one for Steve Jones SQL Scones.
Andy
February 8, 2002 at 5:21 am
How about just passing a parameter in for Langauage? Or storing it when the user connects, then all other queries could join/select from the "config" table to set the language.
Andy
February 8, 2002 at 5:19 am
I wouldnt think so, but I find it pays to test! If you cant get the performance you need via linked server, what about using DTS directly?
Andy
February 8, 2002 at 5:17 am
I dont recall seeing "after" supported. Two methods would be to re-create your table in QA putting the column whereever it belongs - this requires bcp'ing the data out to...
February 8, 2002 at 5:08 am
Regardless of your MS position, its long past time that MS upgraded the VS suite. Im sure its not the right tool for everyone, but I find it meets my...
February 7, 2002 at 6:18 pm
Seems like it would be only one connection. Maybe set up a 2nd linked server and test doing two jobs, one on each linked server?
Andy
February 7, 2002 at 5:16 pm
I havent decided yet on the MTS part, needs more thought from me. We used XML early on for debugging, decided to switch to the binary format, smaller, faster, discourages...
February 7, 2002 at 4:42 pm
If that is your ultimate goal, have to decide if you really need 4 instances to match the four "uses". I'd have concerns about doing testing on a production box...
February 7, 2002 at 8:18 am
If you add the /3GB switch AND the /PAE switch to the boot.ini (requires a reboot) AND enable AWE in SQL you can address almost all of it. I typically...
February 6, 2002 at 4:08 pm
Dont know. Maybe you have to do as two parts, retrieve the file, then DTS. Looking forward to seeing what solution you come up with!
Andy
February 6, 2002 at 12:05 pm
Maybe you're opening more than one connection per client, exceeding the limit?
Andy
February 6, 2002 at 12:04 pm
I like the Administrators companion also. Other than the recovery model there isn't anything you need to spend time on immediately.
Andy
February 6, 2002 at 11:21 am
If its just for an install why not use attach instead of restore? You'll still have to copy the file to whereever it belongs, regardless of method.
Andy
February 6, 2002 at 11:19 am
Viewing 15 posts - 4,966 through 4,980 (of 6,216 total)