have a look at a central management server,

under registered servers --> database engine --> central management servers

add in your central server, then register any child servers under the central server

then...

from what I understand in sharepoint 2010 you can use filestream to store the documents off to disk instead of in the database, all it stores is the metadata to...

can you post all the screenshots of your dbmail setup, profile account etc

On the same subject but not instances this time but backups and restores

Just run through a practice exam and there is one question which I got wrong and I appreciate...

have a look at a tool called scriptomatic from Microsoft, this can write WMI for you in seconds if you know which WMI nodes you want to query

are you hosting it with a SQL cloud provider or are you having the DB server hosted on site and creating a private/public cloud.

from what I have seen if you...

you asked the same question in relation to licensing yesterday, was the information what we gave you unclear? is there anything you would like us to expand on?

I also...

you will need to look at the services on all of the machines you want to check

if the machine has a service which has MSSQLSERVER or MSSQL:#### where #### is...

i know we are all human and we all make mistakes but something as easy as this shouldn't really slip through the net.

hope they resolve and redistribute the points

this is the updated quick reference on licensing R2 from Microsoft direct

what is the definition of Procedure _dta_mv_123?

i suspect that someone has created the procedure with a 4 part qualifier instead of a 3 part qualifier so it is always looking...

Evgeny Garaev is right, anything database server which accepts connections from a website needs to be licensed as per processor.

Now this is per physical processor not cores, so if you...

Thanks Perry, I knew the book was flaky when I bought it, but the instance issue hadn't cropped its head in any of the comments that I looked at about...

instead of having one task to backup all databases and one task to clear them out, I would create seperate MP's for each database and run them staggered

or split out...

there will usually be three connections, one for the object explorer (this is the program WITHOUT query at the end) and then the query window connection itself and I also...