Viewing 15 posts - 8,461 through 8,475 (of 9,248 total)
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
VEB (1/29/2009)
I run SQL Server 2005 instances under local service accounts for Servers, Agents, and Browser services in order to follow less privilege account practice. I have no problem so...
February 4, 2009 at 8:54 am
EdVassie (2/4/2009)
February 4, 2009 at 8:48 am
BOL = SQL server Books online
February 3, 2009 at 1:47 pm
elitejyo (2/3/2009)
created using SQL Profiler
:blush: oops missed that one totally
February 3, 2009 at 10:33 am
fn_trace_getinfo returns five rows for every trace active. Property id 2 indicates the trace path and file, maybe you are not checking the correct property for the active trace
February 3, 2009 at 6:58 am
Viewing 15 posts - 8,461 through 8,475 (of 9,248 total)