Viewing 15 posts - 38,236 through 38,250 (of 39,804 total)
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
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
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
Viewing 15 posts - 38,236 through 38,250 (of 39,804 total)