SQL server 2005 std requires installing to a server OS not a client OS, for clients use developer or Express

blom0344 (8/20/2008)

---

I have the following query that is supposed to update a date-column in a table based on the lowest value of another date from the same table for every...

where exists

would be more efficient than

where in

you;ll need to move the data files over first and attach them to the server. Then you create the extra filegroups. Then create\move objects into those filegroups

WMI, much easier 😎

strComputer = "."

Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\CIMV2")

Set colItems = objWMIService.ExecQuery( _

"SELECT * FROM Win32_LogicalDisk where drivetype=3",,48)

For Each...

in this scenario the best way to analyse the log status is using

dbcc loginfo

look at the status column and they should ideally be 0. The further down you scroll...

this shouldnt...

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...

this should get info on all logical drives

strComputer = "."

Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\CIMV2")

Set colItems = objWMIService.ExecQuery( _

"SELECT * FROM Win32_LogicalDisk...

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!

a2zwd (9/4/2008)

---

Hi,

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...

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....

it shouldnt be used on machines with over 16GB RAM (in fact it could be nearer 12GB RAM)

if your machine...

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...

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.