Hi Charlie, no. You will have to migrate the structure and data from the 08 to a 05 database.

Which edition is your windows?

If STD, then thats your problem..

http://technet.microsoft.com/en-us/library/dd443539(v=ws.10).aspx

Depends a lot of the type of industry you're in, your clients and their business operation hours, how much they are willing to spend on overtime, and whether they see...

Were these IP's randomly selected, or are they reserved and assigned for static use on your cluster?

Sounds like DHCP behaviour, but 5minutes sounds a bit short for renewal.

Wait for others...

Since you need ALL the work done on your behalf, contact a good consulting company who will be more than willing to charge you for a full implementation and documentation...

Ok perfect, lets add a twist to it..

I've got different Codes as well.

The cte so far only returns rows for the same Code.

Keep in mind my ID, CODES do...

ColdCoffee (3/1/2012)

---

I took the liberty of adding an IDENTITY column to the base table.

Here is my stab at the issue

; with cte as

(

select id,currmonth,nextmonth, monthly,startval , cast( (monthly * 2.00)...

Erm....the answer options were incorrect. only 1 option was correct.

select * from sys.dm_service_services --<-- As in the question, this doesnt exist

select * from sys.dm_server_services --<-- As in the explanation, this...

use BETWEEN...

select column where daterange between @startrange and @endrange

Your answer states:

Correct answer:

Query sys.dm_service_services, Query sys.dm_server_registry

Explanation:

After SP1 for SQL Server 2008 R2, there is a new DMV that allows you to query for the service accounts...

After the comments, I think its safe to say:

Yes, model can be set to Read_Only

No, it wont affect new databases created?

Please see screen shot of the test I did....I'm running R2....

handkot (2/21/2012)

---

select @@VERSION

Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64) Sep 21 2011 22:45:45 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT...

next time, I'll run it past you, to ensure it meets YOUR requirements.

I'll...

🙁