Viewing 15 posts - 8,911 through 8,925 (of 9,241 total)
dmc (9/8/2008)
Now on to figuring out the %cpu usage!
give it a go yourself and if you're still stuck post back.
Try searching for "Scripting guy", it'll be a lot of help...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 8, 2008 at 3:11 pm
this should get info on all logical drives
strComputer = "."
Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\CIMV2")
Set colItems = objWMIService.ExecQuery( _
"SELECT * FROM Win32_LogicalDisk...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 8, 2008 at 3:01 pm
when you create a maintenance plan it creates an associated job with it. Maintenance plans are just a graphical way of creating jobs in sql server!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2008 at 3:09 pm
a2zwd (9/4/2008)
I have my sql server installed in C drive(160GB) and my database files(mdf and ldf) are stored in D drive(40GB). Now my D drive is not...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2008 at 2:58 pm
sql authentication modes are either
windows
mixed
in mixed mode windows accounts can still authenticate. Logon as the server administrator and you will gain access to the sql server via the builtin\administrator group....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2008 at 2:56 pm
rc0776 (9/4/2008)
Is it for system with more than 16GB of ram
it shouldnt be used on machines with over 16GB RAM (in fact it could be nearer 12GB RAM)
if your machine...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2008 at 2:52 pm
they will support you up to a point and that point is where they believe the hyper visor is causing the problem. Note their term "commercially reasonable support". If its...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2008 at 6:08 am
i prefer a clean install rather than in place upgrade, main advantage is if anything goes wrong your SQL2000 engine is still available to serve databases.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 3, 2008 at 4:53 pm
James Horsley (9/2/2008)
(i.e. that whole SAN can go pop - they do you know
a well designed and configured SAN should be capable of losing a fabric and still be...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 3, 2008 at 4:45 pm
what happens when you try
server\instancename?
Have you set the instance to use a static port or dynamic?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 3, 2008 at 4:35 pm
definitely sounds like an authentication issue
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 3, 2008 at 4:30 pm
DavidB (9/3/2008)
The VM solution should take care of making it highly available
that would be depend on what virtualisation platform is employed and how it is licenced\configured!
7 separate VM's for homing...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 3, 2008 at 4:22 pm
AFAIK on a server side trace you would need to use the function fn_trace_gettable to read the trace file(s) into a table
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 3, 2008 at 5:10 am
when you launch the installer (via cd or control panel) you get the option to modify an existsing instance. You select an instance then elect to uninstall components from that...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 3, 2008 at 5:05 am
denying select and insert should stop the users opening the objects, are you sure they havent been given sysadmin server role?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2008 at 10:32 am
Viewing 15 posts - 8,911 through 8,925 (of 9,241 total)