Viewing 15 posts - 8,476 through 8,490 (of 9,253 total)
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
domain or local the account should be low permission. Setup will assign the correct permissions for the account when installing the system or when setting through SQL configuration manager
domain account...
February 2, 2009 at 1:55 pm
what version\edition of VMWare are we talking?
if its VMWare server forget it for a production system. The point of clustering is to remove the hardware failure factor (not load balancing)....
February 2, 2009 at 1:49 pm
Mark Thornton (2/2/2009)
it shows that I have 9.00.1399.00
that's RTM not SP2, apply the service pack again and you should be golden
February 2, 2009 at 12:52 pm
check the onepoint database recovery model as suggested already
February 2, 2009 at 12:51 pm
your welcome Jason
as we have stressed already, just make sure resource is i the same place as master.mdf otherwise when you come to upgrade you could\will hit problems
February 2, 2009 at 12:46 pm
IIRC the only time you get problems with upgrades after moving the master database is if the resource database is in a different location. That is why they need to...
February 2, 2009 at 11:24 am
its in BOL but here goes
open sql configuration manager and modify the startup parameters for that sql instance. The paramaters will look something like this
-dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL...
February 2, 2009 at 11:11 am
up to you entirely really, tempdb is the one you should ideally relocate. Bear in mind if you do move master, where ever you put master.mdf the mssqlsystemresource.mdf and ldf...
February 1, 2009 at 4:00 am
dude i dont know what you're smoking but i'd sure like some LOL
February 1, 2009 at 3:46 am
Viewing 15 posts - 8,476 through 8,490 (of 9,253 total)