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

we have found (from experience) that if you shrink the log of a logged shipped database that it changes the LSN's making the next TX log none restorable on the...

totally agree with you on that Perry the domain admins should handle the DC's.

the issue came that once power was restored, all of the servers powered on at exactly the...

we use the followin script to find out which objects are on which filegroup

SELECT

o.[name] AS ObjectName,

o.[type] AS ObjectType,

s.[name] AS SchemaName,

f.[name] AS [Filename],

i.[name] AS PrimaryKey,

i.[index_id] AS IndexID

FROM

sys.indexes...

are you also taking active directory offline?

if so dont power on the sql servers until ad is back online.

our server guys have fallen into this trap many a time, where...

don't make me laugh, A4, i would need to be superman to be able to read an A0 poster printed on a A4 sheet of paper.