Viewing 15 posts - 37,891 through 37,905 (of 39,456 total)
If your clients connect by IP, then yes. Most clients connect using DNS/Wins/NetBIOS, so you may not need to.
Steve Jones
February 27, 2002 at 2:44 pm
Strange. I don't have a good answer, but are you positive the old dev box and the prod box are setup the same? No "test" things done to the dev...
February 27, 2002 at 1:28 pm
Can you give an example? It may be that there are carriage returns that are causing formatting issues in QA.
Steve Jones
February 27, 2002 at 1:25 pm
Tend to agree with Andy, though I'd add that you would want a separate physical device for the ldf.
Steve Jones
February 27, 2002 at 1:23 pm
A couple solutions:
1. Insert a value in a table using a trigger. Run a DTS package every 10 sec, check for new values and run the command
2. Use master..xp_cmdshell. It...
February 27, 2002 at 12:12 pm
February 27, 2002 at 11:59 am
Yes they can access the box, just not SQL Server. The bad points are not having a secondary backup to get into SQL Server.
Steve Jones
February 27, 2002 at 11:58 am
February 27, 2002 at 10:47 am
I agree with Brian. How often would you need to restart an app without affecting others? If you need to restart an instance, it likely is already affecting the other...
February 27, 2002 at 10:46 am
Sorry, no experience on this. I'd double check all the information in BOL and on TechNet.
Steve Jones
February 27, 2002 at 10:42 am
February 27, 2002 at 10:40 am
Two things, check the language setting and the client has more of an impact on the display. Have you changed the W2K settings on the client or the server?
Steve Jones
February 27, 2002 at 10:35 am
For SQL? I've run over 5-6 months on v6.5 with no downtime. Haven't really pushed the envelope on Ss2K, though I'd have to check my current box.
I used to run...
February 26, 2002 at 7:07 am
February 25, 2002 at 4:58 pm
can you post code?
I think you want to build the query using the value of the variable, not the variable.
so if I want to email people named 'steve' and...
February 25, 2002 at 4:55 pm
Viewing 15 posts - 37,891 through 37,905 (of 39,456 total)