Viewing 15 posts - 8,881 through 8,895 (of 9,208 total)
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!
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...
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....
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...
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...
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.
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...
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?
September 3, 2008 at 4:35 pm
definitely sounds like an authentication issue
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...
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
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...
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?
September 2, 2008 at 10:32 am
xp_regread to enumerate the installed instances in the registry 😎
September 2, 2008 at 6:55 am
Mohanraj (9/2/2008)
Created Supervisor group in the Active Directory and added 4 person in that group. (AA,BB,CC,DD) - Windows Authentication users
Later, I have Added AD group Supervisor under Server->Security->Logins
This Supervisor...
September 2, 2008 at 6:43 am
Viewing 15 posts - 8,881 through 8,895 (of 9,208 total)