Viewing 15 posts - 8,461 through 8,475 (of 9,253 total)
Steve Jones - Editor (2/9/2009)
February 9, 2009 at 2:57 pm
jbloes (2/9/2009)
I couldn't find a free MS Virtual Server...do you have the link?
http://www.microsoft.com/technet/virtualserver/software/default.mspx
you will need to register, thats the only requirement.
Steve (2/9/2009)
February 9, 2009 at 2:47 pm
select * from ::fn_trace_getinfo(default)
peace2007 (2/8/2009)
My traceid is 2 and fn_trace_getinfo shows nothing for that;)
using the exact command above what traces does it show?
February 8, 2009 at 4:03 pm
SQLBOT (2/8/2009)
My advice is when going 12 GB or higher to ditch the /3GB switch..
the official standpoint is 16GB RAM but i have seen situations where systems with a lot...
February 8, 2009 at 3:53 pm
i wouldnt personally enable\use xp_cmdshell
schedule a windows task to run a batch file. The batch simply copies the file from one location to the other (maybe a mapped drive to...
February 8, 2009 at 3:15 am
grab yourself a copy of VMWare server or MS Virtual Server Ent 2005, they're both free.
set up a sql server VM and practice DR on that 😎
February 8, 2009 at 3:09 am
peace2007 (2/7/2009)
Have you tried running the trace as a server side trace rather than through profiler? That should have noticeably less impact.
1) Start the...
February 8, 2009 at 2:51 am
joba
run the trace server side so as not to use too much resource from the server. Either generate the script yourself (search this site for examples and check BOL) or...
February 8, 2009 at 2:38 am
Tung
sql2005 standard will address RAM to the operating system max, so no problem there. For a machine with 12GB RAM you may want to remove the /3GB switch from the...
February 8, 2009 at 2:34 am
VEB
you really are making more complex than it actually is. The whole point of a domain is to centrally manage obects within the domain. If your SQL server is part...
February 7, 2009 at 6:23 am
Great article Jonathan, should wet peoples appetites for CLR a little
February 5, 2009 at 2:05 pm
th post installation will be on the program menu on the server. Yes run the post install and configure a service. Our sql server is on SQL2005 SP2
February 5, 2009 at 6:49 am
SQL_Quest (2/4/2009)
I have just a simple question ... we are using ArcGIS server 9.2 enterprise edition... does this server have the ArcSDE service running in it? If yes,...
February 4, 2009 at 3:59 pm
VEB (2/4/2009)
If a domain account is compromised, the domain is affected
its a low permissions account so no more a risk than any other domain user. Your windows system admin should...
February 4, 2009 at 3:49 pm
VEB (2/4/2009)
Why can't I use local accounts for SS services in a domain environment?
why build a windows domain in the first place?
its not that you cant use local accounts, if...
February 4, 2009 at 10:10 am
Viewing 15 posts - 8,461 through 8,475 (of 9,253 total)